how to create a real mttr

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-11-2022 10:22 AM
Hello, is there someone who has been able to solve this problem?
I am using the "Incident State Duration" metric to obtain the time that each incident was in "In Progress", this is correct for incidents that passed through this state only once and I have no problems obtaining the average.
The problem appears when an incident or more go through the "In Progress" status twice, since when obtaining the average it is dividing it by the total number of incidents, since these are duplicates.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-12-2022 07:23 PM
Hi Horacio,
The task table already contains 2 fields for what you need, calculated via the marked_resolved BR.
JP

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-14-2022 04:41 AM
Hello Jp, how are you?
My client does not want to measure from open to closed, he wants to know how long the incident was in "in progress" status or the task in "Work in progress", the problem that I detect with the "metric Definition" is that if the incident or the task is in that state more than once, create a new record, multiplying the times that incident appears with the respective time, the problem is that by having multiple incidents, the total average of the assigned group is less than the corresponding one and is not real the metric that would be showing.
This can be seen in the attached image.
Anyway, thank you very much.
Regards.
Horacio.-.