Aggregation in Average?

[QFanatic]

hi guys

PFA

I am desperate to get help on this one.

My model contains volumes per Table in a Database - per Days, Weekday and Hour, and Period

what I need to do (the expressions in my chart)...

1. Get the total volume PER Req_DATE, per REQ_HOUR, per TABLE (that part works LOL)

2. Then I need to get the AVERAGE VOLUME PER WEEKDAY(SATURDAYS ETC), per REQ_HOUR and compare what I've calculated in (1) to this average - and color code it. Easy as that.

Please have a look at the attached image...

look at Saturday 20200502 for example. For 00 Hours the volume is 21 899. The total of ALL the volumes for 00 Hours for May is = 21 899 + 9023 + 9739 + 11 144 and 14004 = 65 809.

Now that 65809 should be divided by 5 (the Amount of Saturdays in May) to find the average (per REQ_HOUR of course)

I dont know how to achieve that. The division is currently happening by 99 (as highlighted) 

Please - this is urgent.

Thank you

[Brett_Bleess]

Have a look at the following Design Blog post, believe that should be of some help:

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

Regards,
Brett

[QFanatic]

Thanks Brett