Creation of report for incident and how much time it spent on particular state.

[Atchutaram]

Hi Everyone,

Good Day!

                     I need to create a report on incident table and the report should show how much time it spent in every state. 

how can i generate this?

BR

[Kieran Anson]

OOB there is a metric definition [metric_definition] which will capture the duration of a field value - 'Incident state duration'. Aggregating that information may be complex depending on your needs and could require performance analytics 

[Ankur Bawiskar]

@Atchutaram 

there is an OOB metric defintion for this. Did you check that? you can use that for reporting

How to create a report to track total time duration when the field "incident change" changes using m... 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ramesh Poola]

Hi @Atchutaram,

You need to create a report on incident_metric table and you can use filter conditions like Definition is Incident state duration and some other filters if you want, then you will get the report. Its better to run this report in off business days, because incident_metric table contains very high volume of records.

Best Regards,
Ramesh