Average P1 Duration Report Without SLAs

mania · 3 hours ago

Hi,

I would like to build an “Average P1 Duration” report. However, we are not using SLAs in our setup.

Is there a way to create this report without relying on SLAs? If so, could someone please guide me on how to achieve this without script inside report itself? It would be very helpful.

Thanks!

Dr Atul G- LNG · 3 hours ago

Hi @mania

create a single score report

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

AndersBGS · 3 hours ago

Hi @mania ,

If you're not utilizing the SLA for P1 duration and it should be without script, you could utilizing performance analytics with the build in duration and a formula indicator to calculate the duration of the sum of P1.

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/

Dr Atul G- LNG · 3 hours ago

Hi @mania

create a single score report

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

mania · 2 hours ago

Thankyou and it worked.
Previously tried on case table so i am not able to fetch that field and after applied in incident table same as per you screenshort it worked and again tried on case with dot walking so it worked in case as well.

Thankyou!