Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Performance Analytics Report and Dashboard

Narmadha PR
Tera Contributor

an hour ago

Hi,

I need to create a Performance Analytics Report and Dashboard for the excel sheet provided below, that gets the count when an incident record is created from the CI . Also it needs to provide the count on both yearly and weekly basis. Please help me on my requirement. Thanks in Advance!

 

Preview file
52 KB
0 Helpfuls
  • 56 Views
3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

23m ago

Hi @Narmadha PR 

I tried this in myPDI, but generating the report exactly the way you want isn’t possible. You can create a multi-pivot and add the required rows and columns, but most of the work will be manual. To get this specific data, you would need to create a trend report separately.

 

DrAtulGLNG_0-1765261743774.png

 

*************************************************************************************************************
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]

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

Narmadha PR
Tera Contributor
In response to Dr Atul G- LNG

9m ago

Hi Sir,

Thank you! Can you please send me a step by step procedure to implement this?

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to Narmadha PR

6m ago

Hi @Narmadha PR 

 

It's a simple report. The type is pivot.

 

You can see the screen shot for row and columns.https://youtu.be/UNnSPE2eP4s

 

This video gives you more in-depth.

*************************************************************************************************************
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]

****************************************************************************************************************
0 Helpfuls