Average Needed

Anonymous — Mon, 11 Jul 2016 13:54:04 GMT

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

Re: Average Needed

sunny_talwar — Mon, 11 Jul 2016 13:58:04 GMT

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

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

Anonymous — Tue, 12 Jul 2016 16:10:57 GMT

Thanks Sunny...As Always