Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

Generate Report using PA indicators

sugand
Tera Contributor

Hi,

Can anyone help how to generate the below report using PA indicators.

MTTR = (Sum of "Actual duration + Pause duration" of the resolution SLA / Total number of incidents)

 

Since I'm new to PA reports, need your assistance to achieve this. 

 

Thanks,

Sugand

3 REPLIES 3

AndersBGS
Tera Patron

Hi @sugand ,

 

Where are you getting stuck? What is your issue according to your requirement?

 

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

 

Best regards

Anders 

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/

sugand
Tera Contributor

Hi @AndersBGS ,

I have no clue where should I start with, which indicator should I create (Automated or Formula indicators)?
And how to add the 'Actual duration and Pause duration'?

sugand_0-1707984670689.png

Thanks,

Sugand

Hi @sugand ,

 

Ok, you should create an indicator source based on the incident_sla database view with your defined conditions. Afterwards, you create two automated indicators (1 for sum of duration and 1 for count of incidents). last you create a formula indicator to create the calculation of your choice. 

 

If you have no prior experience with performance analytics, I would recommend you to take the NowLearning training: https://nowlearning.servicenow.com/lxp/en/pages/now-learning-get-certified?id=amap_detail&summary_id...

 

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

 

Best regards

Anders 

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/