Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
=Sum(Aggr(Count(DISTINCT{$<AUD_ResultCode={'*Remote*'}>}AUD_ResultCode), name))/24/Sum(Aggr(Max(ActionTime)-Min(ActionTime), name))
May be this:
=Sum(Aggr(Count(DISTINCT{$<AUD_ResultCode={'*Remote*'}>}AUD_ResultCode), name))/24/Sum(Aggr(Max(ActionTime)-Min(ActionTime), name))
Sunny,
Thanks! Works just fine.