average per interval, per day name

[#1]

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

[hic]

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