1 Reply Latest reply: Jun 25, 2009 11:20 PM by John Witherspoon RSS

    Hide previous months when accumulating dates

    Brian Veara

      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

        • Hide previous months when accumulating dates
          John Witherspoon

          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.