Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
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
sunny_talwar

May be this

Sum(Aggr(Avg(Value), Date))

jonathandienst
Partner - Champion III
Partner - Champion III

Sunny, don't you mean:

Avg(Aggr(Sum(Value), Date))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
sunny_talwar

Not sure I am clear if OP wants to do Avg each day and then sum or sum each day and then average.... but you could be right

kroberts13
Contributor III
Contributor III
Author

I would want to sum every day (12/1, 1/1, 2/1) and then average

sunny_talwar

Then jontydkpi‌'s response is the right one I guess

effinty2112
Master
Master

Hi Kyle,

try a straight table with calculated dimension

=Day(Date)

and expression

avg(Aggr(Sum(Amount),Date))

Good luck

Andrew

prat1507
Specialist
Specialist

Maybe this

=avg(Aggr(Sum(Amount),YearField,MonthField))

Regards

Pratyush

kroberts13
Contributor III
Contributor III
Author

How would I just grab the last 12 months?

sunny_talwar

Are you trying to get rolling 12 months?