Average calculation

[shamitshah]

Hi,

Please see attached.

I am trying to get the the number of orders completed / interval time i.e. the  result of 12 /16:32:12 either in a text box or as a total in the column 'Orders Completed per hour". The result should be 0.73. Tried a couple of things, but it does not seem to work.

Any ideas?

Thanks

[sunny_talwar · Accepted solution]

May be this:

=Sum(Aggr(Count(DISTINCT{$<AUD_ResultCode={'*Remote*'}>}AUD_ResultCode), name))/24/Sum(Aggr(Max(ActionTime)-Min(ActionTime), name))

[shamitshah]

Sunny,

Thanks! Works just fine.