Incident MTTR Dashboard Creation in ServiceNow Performance Analytics

[RajaputanaN]

I am trying to create an Incident MTTR Analysis dashboard in ServiceNow Performance Analytics similar to the attached screenshot.

Requirements:

• Incident Count as Bar Chart
• MTTR (Hours) as Line Chart
• Dual Y-Axis
• Monthly trend
• Separate reports for Priority 1/2 and Priority 3/4

Could anyone please suggest the best way to configure this in Performance Analytics and calculate MTTR correctly?

Thanks.

[Tanushree Maiti · Accepted solution]

Hi @RajaputanaN 

Check these resources:  Need a Query For Calculating Mean time to resolve by month 

MTTR (Mean Time to Resolution) Reporting 

Create a chart showing correlation between reassignment count and MTTR 

KB0793124 How to create a report to track total time duration when the field "incident change" chang...                                            

  https://www.youtube.com/watch?v=_XfUeWtGD9g