Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
QFanatic
Creator
Creator

Calculating Average as Reference Line on Chart

hi all

Please find attached.

The model contains Volumes per Day, per Table.

On my chart, I want to display the (1) Average per day (of the selected month) and (2) Average per Hour. But the figures I am getting on Per Day seems too low, if I just look at the figures.

I was considering =avg(aggr(Sum({$<PERIOD={$(vMaxMonth)}>} HOUR_VOLUME)
/
count({$<PERIOD={$(vMaxMonth)}>} distinct REQ_DAY),PERIOD)) as well?

Any help will be appreciated? I'm not great with Averages...actually, I'm very Average 🙂 🙂

Thanks

Labels (2)
1 Solution

Accepted Solutions
Brett_Bleess
Former Employee
Former Employee

Have a look at the following Design Blog post, may prove helpful, but I am not sure:

https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

2 Replies
Brett_Bleess
Former Employee
Former Employee

Have a look at the following Design Blog post, may prove helpful, but I am not sure:

https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
QFanatic
Creator
Creator
Author

Thank you