Average Per day of Month

[kroberts13]

Hello,

I am looking for a way to get an average amount per day of the month over the last 12 months. For example, I would need to sum the amount on 12/1, 1/1, 2/1, etc. and average that number. I would need to do that for every day. Any help on this would be greatly appreciated.

Thanks in advance!

[kroberts13]

Yes, Rolling 12 months. I am using the set Analysis below:

RangeSum(above(Aggr(Sum({$<[DETAIL_TYPE] = {1,10}>}AMOUNT), POST_DATE),0,rowno()))

But it is giving me current month numbers, rather than averaging the last 12 months per day.

[sunny_talwar]

I would suggest to use  The As-Of Table to resolve this.... it will be efficient and easy to maintain

[kroberts13]

This would be the best way to look at the prior 12 months?

[sunny_talwar]

I would say the most efficient way to do it... other methods are going to be somewhat complex and will slow down the chart