How to create report?

shabbir5 · ‎02-03-2025

Hi Team,

How to create below report on problem table?

	Problem Records
Open	Closed	Average RCA	Max RCA
assignment group1	0	0	N/A
assignment group2	0	0	6 d
assignment group3	0	0	N/A
assignment group4	0	0	N/A	N/A

is this possible ?

Thank you,

Shabbir Shaik

Dr Atul G- LNG · ‎02-03-2025

Hi @shabbir5

We can't create a whole report in one go. It is multi pivot, you can add rows and columns and you can get only a count in the pivot table. Avg RCA and max RCA you need go create a new 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/atul_grover_lng [ Connect for 1-1 Session]

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

AndersBGS · ‎02-03-2025

Hi @shabbir5 ,

you can’t create a table as shown, but there are different capabilities in ServiceNow. To guide you further, do you have performance analytics available or only the normal reporting module?

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/

shabbir5 · ‎02-03-2025

Hi Andres ,

Thank you for the response , we are using normal report module

//Shabbir Shaik