Calculate Averages in set analysis

[#1]

Good morning,

I am trying to calculate averages for the attached file. The formula I have used to calculate

Total_PreviewTime=Sum ({<PreviewedFirst={1}>}PreviewTime) and I want to calculate the Average Total_PreviewTime  and similarly for

Total_CallTime=sum(CallTime) I want to calculate Average Total_CallTime

PFA,

Thanks

[tresesco]

Perhaps the output you are getting has to be parsed as seconds. Try like:

Time#(Avg(aggr(Sum ({<PreviewedFirst={1}>}PreviewTime),Day)), 'ss')

and then apply your time format in the presentation tab.

[Anonymous · Accepted solution]

Hi Moses,

you can try

Aggr(Sum ({<PreviewedFirst={1}>}PreviewTime),Dim1,Dim2,Dim3) / Count ({<PreviewedFirst={1}>}PreviewTime)

[#4]

Thank you much for  your assistance and but Payal's is correct and the format is also correct.