How to create a report for approvals per change

Shashi K
Tera Contributor

How to create a report for this below requirement?

1.Average number of Approvals per Change

2.Highest number of Approvals per Change 

it’s possible for PA please explain?

 

Thanks for advance 

 

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

Yes @Shashi K with PA it is possible but per change will be too much for you. Try to add parameter per month / week to ease the analysis.

 

https://www.servicenow.com/community/platform-analytics-forum/average-approval-time-after-creation-r...

 

https://docs.servicenow.com/bundle/washingtondc-it-service-management/page/use/dashboards/applicatio...

 

*************************************************************************************************************
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/atul_grover_lng [ Connect for 1-1 Session]

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

AndersBGS
Tera Patron
Tera Patron

Hi @Shashi K ,

 

For average number of approvals pr. change this is defiantly possible. Here you can do the calculation in a formula indicator. For the highest number of approvals per change, I don't fully get your requirement here, but I do think you need a scripted automated indicator to do this. 

 

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/