Measure average time lapse between order placed time and order approved time.

[wanyunyang]

My data model has fields: OrderId, OrderPlaceTime (mm/dd/yyyy hh:mm:ss), OrderPlaceWeekDay (Weekday, Weekend), OrderAprroveTime (mm/dd/yyyy hh:mm:ss).

I have measured average time lapse between OrderPlaceTime and OrderApproveTime for all orders with expression:

 avg(OrderAprroveTime-OrderPlaceTime).

Now I'm trying to measure average time lapse between OrderPlaceTime and OrderApproveTime for those orders places during Weekend. How should I write the expression? avg(OrderAprroveTime-OrderPlaceTime) won't work, since an order placed during weekends may be approved during weekdays.

Any advice helps. Thank you in advance!

[Frank_Hartmann]

try this in textbox:

=sum(NetWorkDays(OrderPlaceTime,OrderAprroveTime))/count(OrderPlaceTime)

[timpoismans · Accepted solution]

Try the following:

 avg({<OrderPlaceWeekDay={'Weekend'}>}OrderAprroveTime-OrderPlaceTime)

Regards,

Tim P.