average per interval, per day name

Thu, 02 Jul 2015 04:37:12 GMT

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

Re: average per interval, per day name

hic — Thu, 02 Jul 2015 06:08:46 GMT

I would use

Sum(volume) / Count( distinct Hour_Int )

to get the hourly average, but displayed per day/week etc.

See Average – Which average?

HIC

topic Re: average per interval, per day name in QlikView

average per interval, per day name

Re: average per interval, per day name