I have built a bar chart visualization with Spotfire that includes the use of the Over function to give a running total. Months are on the X axis and counts are on the Y axis. My data set contains months where there were no values. When I graph that there is no bar for months not containing a value although a running total should still contain a value, since previous total plus zero should still be the previous total.
How do I get a month with no value to still show a bar for that month?
Custom Expression for the Y axis is this:
Count() OVER (AllPrevious(Axis.X))