Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've created a run chart that is accumulting 10-steps (months) back. In the chart display, I would like to hide the months that are not fully accumulated as they are just a sloped line. Any advice would be greatly appreciated. Thanks ahead of time.
-Brian
This isn't quite what you're asking for, but for a rolling 10 month average, for example, you could get an average of the months so far for the first 9 months. Rather than doing the accumulation, do this:
rangeavg(above(Amount,0,10))
That says you want the average of the current row and the nine rows above it. For the first nine months, it will only average the rows it can find.
Unfortunately, I haven't thought of how to actually exclude the first nine rows since they're used in the accumulation.