Chart Macro: Is there a way to not have a line Chart render, if the values are 0 or empty

[Paul Samuel]

Is there a way to not have a line chart render, if the values are 0 or empty... So far, no luck when I tried to get this to work.  I tried to turn "Forgive" ON/OFF... Tried setting the column values (# of Defects Open) to blank, 0, -10 with no luck.

Example:

If I have this data with the 3 columns/headers below... I expected that the "# of Defects Open" would not render after the value 25 ... It should show blank for 6/23 and 6/24 on the chart.  But it's rendering as 0 (meaning is renders on the x-axis).

Date, # of Defects Open, # of Test Cases Run

6/21, 10, 100

6/22, 25, 200

6/23, 0, 300

6/24,  , 400

[Andrey Khaneev _StiltSoft_]

Hello Paul,

As a workaround you can try Chart from Table macro - it doesn't render empty values, but it render zero values:

This macro is a part of Table Filter and Charts app.

[Paul Samuel]

Thanks Andrey, but unfortunately, the version of Confluence that my company is using (below) does not seem to have the Chart from Table macro.  I'll follow up with the internal team to see if it can be upgraded. 

License Information for Confluence Cloud

Confluence 1000.0.0-52f4e0df752

Copyright © 2003 - 2017 Atlassian Corporation Pty Ltd