Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hallo
please could some one help me. I have posted this a couple of days before but no luck.
I am so stuck and very new to qlikview.
I have a table showing volumes per interval (hour) for June month per weekday (i.e Mon, tues, wed etc). I know what to know on average for the month of June how many volumes I received on a Mon, Tue, Wed etc. In example below June month got 4 Fridays therefore on Fridays we receive on average 29 calls between 8 and 9 and on average 44 calls between 9 and 10.
how do I write it in my expression field.
thank you very much
June | Friday | |
Hour_Int | volume | Ave per day |
8 | 114 | 28.50 |
9 | 175 | 43.75 |
10 | 139 | 34.75 |
11 | 128 | 32.00 |
12 | 129 | 32.25 |
13 | 116 | 29.00 |
14 | 134 | 33.50 |
15 | 126 | 31.50 |
16 | 35 | 8.75 |
17 | 18 | 4.50 |
18 | 7 | 1.75 |
Total | 1 121 | 280.25 |
I would use
Sum(volume) / Count( distinct Hour_Int )
to get the hourly average, but displayed per day/week etc.
HIC