Create report that can show how long an incident has occurred in the respective state.

[Karl Wir_n1]

Has attempted to get a report that can show how long an incident has occurred in the respective state.

For example, if There are 100 incidents in the state "Responding". I would like to see how the distribution looks like how many days the 100 incidents have been with that status. That's not how long they were open or how long it lasted since last update.Anyone have a clue about how we could create this?

Br Karl 

[Alberto Consonn]

Hi,

you'll want to make a "pivot" report (but start with a list report, it's easier to understand the data you're manipulating) on the "database view" called "incident_metric" and then you'll filter the "definition" field with "Incident State Duration".

Play a bit on it and have a look also to this documentation, it will help you to do it:

Create a metric definition

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[Alberto Consonn · Accepted solution]

Any update on this?

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto