Reporting time between status changes
Updated: 21 May 2010 | 1 comment
I'm trying to create a report that will give me the time spent on a given ticket between each change in status. So as an example I need to see the time spent from the time it was submitted to the time it changes to open. I then need to see the time spent between the time it was opend to the time it was closed. Gettingt he time from created on to closed is simple it's the middle section that I am haveing trouble with. How do I identify the time stamp on the ticket at a specific status change?
discussion Filed Under:
Comments
A quick thought would be
A quick thought would be looping through the versions of the incident and detecting when the status changes. Start out by recording the start time and then reset this "Start Time" everytime you detect the status changes. Subtract the workitem modified time from the "Start Time" variable and you have your timespan between status changes.
Would you like to reply?
Login or Register to post your comment.