We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

MTTR Calculation

brianlan25
Kilo Patron

I'm trying to Calculate MTTR. I know there is a field on incident called Business resolved time which populates when an incident is resolved. My question is how to I sum that specific field in PA so that I can calculate MTTR on a monthly basis? 

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron

Hi @brianlan25 

 

You can simply sum the resolved time in 1 automated indicator, and have another automated indictor for count of incidents. On top of those, then have a formula indicator with sum / count = MTTR.

 

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

7 REPLIES 7

Tanushree Maiti
Tera Patron

Hi @brianlan25 

 

In PA , you can follow the formula as given in this post .

Monthly Average resolve time for Resolved incidents 

 

 

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti

AndersBGS
Tera Patron

Hi @brianlan25 

 

You can simply sum the resolved time in 1 automated indicator, and have another automated indictor for count of incidents. On top of those, then have a formula indicator with sum / count = MTTR.

 

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

But how do I get it to sum the specific field?

Never mind I found it. When you choose sum as the aggregate it lets you chose the field. 

brianlan25_0-1778860619690.png