I have a series of service calls and actions within those service calls.
SERVICE CALL - ALR125
Initated: 07/14/2009 10:30:15
Tech Arrival: 07/15/2009 09:42:15
Tech Clear: 07/15/2009 13:23:21
Parts Ordered: 07/15/2009 14:14:08
Parts Arrived: 07/16/2009 08:13:27
Tech Arrival: 07/16/2009 12:45:17
Tech Clear: 07/16/2009 17:43:11
Closed: 07/16/2009 17:48:53
The date and time are assigned to formula @DT
To find the elapsed time between entries I’m using DateDiff (seconds later converted to days, hours, minutes, seconds):
DATEDIFF(“s”, PREVIOUS({@DT}),{@DT})
To find the total time of the Service Call (seconds later converted to days, hours, minutes, seconds):
DATEDIFF(“s”,MINIMUM({@DT},{@CALL}),MAXIMUM({@DT},{@CALL}))
Now here’s where I’m stuck. I need to find the average of the Total Times. Each time I try it, I end up with “this field cannot be summarized”.
Is there a better way to do this?
Neinta (BOB member since 2008-05-22)
