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
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?