- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2022 02:55 AM
Hi,
I want to report on how long an incident spends wihtin a certain status. For example and Incident is created -> work in progress -> on hold -> work in progress -> closed complete.
How do I report the time it spends in the state "ready", "work in progress" and "on hold"?
Solved! Go to Solution.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2022 03:09 AM
Hi
You can create the Metrics Report on metric_definition.LIST table
Something like below screenshot:
Under related list you can see all these data
By using above table you can create report easily.
Thanks,
Murthy
Murthy

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2022 02:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2022 03:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2022 03:52 AM
Hi
The duration is only showing me when the INC is already closed. So I see the duration the INC was in the sytem in total but not the time for a specific Status so how long the ticket spend in the status Ready.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2022 03:56 AM
You need to refer Value field as well to understand the state. So, its combination of Start, End, Duration & value.