Aggregation in Average?

QFanatic — Sat, 16 Nov 2024 00:32:59 GMT

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

Re: Aggregation in Average?

Brett_Bleess — Thu, 25 Jun 2020 20:58:12 GMT

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

Re: Aggregation in Average?

QFanatic — Fri, 26 Jun 2020 06:05:54 GMT

Thanks Brett

topic Aggregation in Average? in QlikView

Aggregation in Average?

Re: Aggregation in Average?

Re: Aggregation in Average?