Hi there
I would like to see the time spent on request, and
luckily I found TimeSpent custom report
I have selected 'Time Elapsed', 'Created Time', '
COMPLETEDTIME
', 'Resolved time'.
As a result I get the query
SELECT wo.WORKORDERID "Request ID",wo.TIMESPENTONREQ "Time Elapsed",wo.CREATEDTIME "Created Time",wo.COMPLETEDTIME "Completed Time",wo.RESOLVEDTIME "Resolved Time" FROM WorkOrder wo WHERE (wo.ISPARENT='1')
I would expect that
wo.TIMESPENTONREQ "Time Elapsed"
is the difference between closing and opening the request, but it is not always like that
My question is: What is exactly
wo.TIMESPENTONREQ "Time Elapsed"?
What is the best to use as a measurement of how long time does it take to solve an issue?
I have attached snapshot of the report. On the red line - Time Elapsed is 00:45:21, but the difference is 154:26:00. And there are many like that
Thanks,
Tzvetan