Display Average on Chart

[QFanatic]

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

[Brett_Bleess]

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