Average Needed

[Anonymous]

Hi All i have the following date on left date and time per day for the weeks

I needed to get week number and the average for this time.

No Sure how to do this because to get this i already have Sum(Time)

So to get the Average of that time per week is a bit tricky.

So bit in Black i have =

Dimension -   Date

Expression - Sum(Time)

Need bit in red.

Thanks All

04-Jan	05:00	Week 1	00:03:53
05-Jan	04:09
06-Jan	03:59
07-Jan	04:46
08-Jan	03:58
09-Jan	01:25
10-Jan	00:00
11-Jan	04:15
12-Jan	03:31	Week 2	00:03:48
13-Jan	03:23
14-Jan	05:06
15-Jan	04:34
16-Jan	01:57
17-Jan	00:00

[sunny_talwar · Accepted solution]

Do you have week field from your script? If it has, then may be this:

Avg(TOTAL <WeekField> Aggr(Sum(Time), Date, WeekField))

[Anonymous]

Thanks Sunny...As Always