Calculating Average as Reference Line on Chart

[QFanatic]

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

[Brett_Bleess · Accepted solution]

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

[QFanatic]

Thank you