plot sum from beginning date through date on x axis
I need to plot the daily A/R Balance on a line chart. The measure is named 'ARBal' and can be calculated by any data by summing all entries up through the ARAgeDate field, which is the dimension I'd like to use on the X axis. For example, if 12/31/2010 were a plot on my X axis, I would sum ARBal where ARAgeDate <= '12/31/2010'. Please advise.
Dimension = ARAgeDate Expresison = sum(ARBal) turn on full accumulation
But that's probably not what I'd do, because if your data starts in year 1974, for instance, and you select January 2011 to look at, it will only accumulate from the start of January 2011, not from 1974.
I would likely generate an AsOf table that ties each AsOfDate to that ARAgeDage and every previous ARAgeDate. Use AsOfDate in the chart, again use sum(ARBal), but don't use full accumulation. The accumulation would happen as a result of the data model. Therefore, even if you select January 2011, it will still accumulate from the start of the data.
