Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank you