Report on Incident overall duration

[GBS]

Can we create a report on the incident and the time spent in each state? I have made a report that only shows the average business duration. But I want to see each state's duration in a stack bar. 

[Dr Atul G- LNG]

Yes @GBS 

But for this PA is best. Check OOTB KPI on Incidents.

[GBS]

@Dr Atul G- LNG Thanks for the reply, but I want the incident number to be displayed on X-axis which is in the screenshot 

[Dr Atul G- LNG]

Try this:

https://www.servicenow.com/community/platform-analytics-forum/average-time-by-state/m-p/1221942

[AndersBGS]

Hi @GBS ,

 according to your requirement, you’re should look into incident metric table, and create a duration definition for state.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up,

best regards

Anders