Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kroberts13
Contributor III
Contributor III

Average Per day of Month

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!

13 Replies
kroberts13
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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