How to keep line chart from reflecting empty value

[Dave Collins]

I'd like to keep this simple line chart from "dropping" when there is no value (empty) or using 0 = same results. 

I would like for it to end at the last entry, not drop to 0

[Andrey Khaneev _StiltSoft_ · Accepted solution]

Hi Dave,

You can use Chart from Table macro (Table Filter and Charts add-on), it ignores empty values. Also you can combine it with Table Filter macro to apply additional filtering to the table.

[Dave Collins]

Unless I am missing something, it also "ignores" the dates that have no value, and so draws nothing... 

[Andrey Khaneev _StiltSoft_]

I thought that's what you need - to skip empty values. Please, describe the chart you expect to see and the table with data.

[Dave Collins]

The date actually runs to Oct 5 and is reflected with the date in the table. Having an empty Opena and Closed value. I expected to see the entire table drawn out, with the date, only the lines in the chart would end on the last date that had a value.

[Andrey Khaneev _StiltSoft_]

Then you can set Maximal Y Value to Oct 5 2018 in the Chart from Table macro settings.

[Dave Collins]

That would be the X value actually, and it did nothing to extend the date range - neither with min or max.

[Andrey Khaneev _StiltSoft_]

Date was entered in a wrong format, it should be the same as in the source tale. In this case: 5 Oct 2018.

[Dave Collins]

Thanks, with that in Max, working. Appreciate the help.

[Dave Collins]

Is there any way to omit certain dates? (weekends)

[Andrey Khaneev _StiltSoft_]

No, it is not possible to omit weekends. Glad I could help you.

[Alexander Klimetschek]

Note this is a 3rd party macro that at least in our Confluence enterprise installation is not available.

[Katerina Kovriga _Stiltsoft_]

Hi @Alexander Klimetschek ,

The Table Filter and Charts for Confluence app is an add-on created by the Stiltsoft team.

This is a paid app related to working with Confluence tables (filtration, data aggregation and visualization, calculations in tables, conditional formatting, etc.). Our main goal is to create mini-Excel right in Confluence so that our customers will keep everything in one place.

You can always try the app for free (it's available for Cloud, Server and Data Center) and decide if it suits your needs. Besides we'll be happy to organize a live demo for you - please book a time slot here.

[Dave Collins]

@Katerina Kovriga _Stiltsoft_ or @Andrey Khaneev _StiltSoft_ for some reason, this no longer works.

Also, unable to place a JQL in a cell with an issue count. We were able to do this before, but it breaks the table now.

[Stiltsoft support]

Hi @Dave Collins ,

Our corporate Cloud instance allows to place issue counts inside a table, have checked it right now:

The first count comes from the new Jira Issues macro, the second - from the old Jira Legacy macro.

They are standard Confluence features and are not related to the app.

What concerns the app and the chart that "stopped working", you may check the source table (is it manually created or macro generated (by the Jira macro, we mean)? do you see it well if you copy it out of the Chart from Table macro and publish the page? was smth changed regarding the date format?).

Please, check this and refer to our support portal that is confidential and you'll be able to share data freely.

[Dave Collins]

@Stiltsoft support the "new" Jira issues macro is being used, and does not work (I have to create a table with numbers put in manually.

Not working, meaning i put the start and end date (tried date formant several different ways). If the field is blank, only draws for days with a value.

[Stiltsoft support]

The new Jira Issues macro can't be fully supported by the 3rd party macros at the moment, I guess it is shown as a link after wrapping in the Chart from Table macro even if you choose to show it as a panel.

So, you may use the old Legacy Jira instead - it works as it has been working before.

What concerns the Chart from Table macro, it seems that your date formats are mixed up.

The second table from your screenshot that is wrapped in the Chart from Table macro has the following date format "7/8/24" that corresponds to the "m/d/y" format. This format should be set in the macro:

The Maximal X value on your screenshot is set as "12/7/2024" but it should be "7/12/24" (as are the dates in your source table):

Then the macro works as expected.

And here is my original table for reference:

[Dave Collins]

Thanks @Stiltsoft support the date just doesn't work for me, no matter the format.

However, using the Jira Legacy resolved the other issue.

[Stiltsoft support]

It shouldn't be "no matter the format", the format should be the same for the source table, date format field and Maximal X value field in the macro.

Please refer to our support then: go to the upper right corner of the page -> menu ... -> View storage format, save it and attach to the ticket. If you don't see the option, ask your Confluence administrator to do it for you.

Then we'll be able to recreate exactly your page and see what's wrong there.

[Shawn C]

Hi Dave, 

Currently the Chart Macro in Confluence will try to render all values that are provided to it in the table; this also means if an X value is provided but does not contain a Y, the line chart will render a 0.

There is a Feature Request to treat empty cells as no value and not plot a point on the line chart.  If this is something you'd like to see added to the Chart Macro, I ask that include any feedback you may have on the following Feature Request: https://jira.atlassian.com/browse/CONFSERVER-54801

If you have any other questions about this, please let me know. 

Regards,
Shawn