I have a line chart that shows cumulative sums over time, and I want it to chart weeks when the count is zero - but I also want it to suppress weeks where the value is null. The chart's expression is an "if" statement that returns a null() value starting at the day where there's no more data.
The problem is that if I check the "Suppress Zero-Values" box on the chart's Presentation tab, then it suppresses both the weeks where the value is zero and where the value is null, whereas I want it to show the zero weeks but hide the null weeks. Is there a way to do this?
Thanks,
Jeff
