Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys, please find attached.
On my chart, my Expression looks like this...
=Sum({$<PERIOD={$(vMaxMonth)}>} HOUR_VOLUME).
I want to display a reference line to display the Average...what sort of Average will make sense in this context - Average per day will just follow the pattern of the current Expression...so maybe a monthly average?
How would the expression for the Monthly Average look like?
(I have a date field called Report_Date as well as the PERIOD field)
Thanks
Have a look at the following Design Blog post, should provide some ideas to pursue:
https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654
You can use the following link to search the Design Blog further:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett