Average per interval per day name

[#1]

Hallo

please could some one help me.  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

[#2]

hi

is there anyone that can help me please.

[ikarimov]

I think you can do this like so:

[pratap6699]

avg({$<month={'june'},hourint={"8,9,10"}>}volume)

[timanshu]

Hi,

Write aggr(sum(volume)/count(Weekday),Month,Weekday)

[jagan]

HI,

Try this expression

Dimension: Hour

Expression:

Volume - Sum(Volume)

Avg Per day - Sum(Volume)/Count(Distinct DateFieldName)

Regards,

Jagan.

[sasiparupudi1]

Can you please post your data here