Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi Moses,
you can try
Aggr(Sum ({<PreviewedFirst={1}>}PreviewTime),Dim1,Dim2,Dim3) / Count ({<PreviewedFirst={1}>}PreviewTime)
Thank you much for your assistance and but Payal's is correct and the format is also correct.