Need help in ServiceNow Report

AnamN
Tera Contributor

‎06-18-2024 10:57 AM

Hi Team,

 

I need help with ServiceNow Report.

We have table with column as below fields

State (In Progress/Complete/Cancel) , Number of Incident, Number of Change, Number of problems

and we want to display report like below:

StateNumber of IncidentNumber of ChangeNumber of problems
In Progress346
Complete666
Cancel155
Total101517
0 Helpfuls
  • 360 Views
6 REPLIES 6

AnamN
Tera Contributor

‎06-20-2024 03:31 AM

@Ankur Bawiskar @Maik Skoddow  Can you please help here ..Thanks

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron

‎06-20-2024 06:07 AM

Hi @AnamN 

 

AGLearnNGrow_0-1718888854525.png

 

Report Type = Multi Pivot

 

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

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

‎06-20-2024 06:12 AM

You can modify the condition as per requirement

 

AGLearnNGrow_1-1718889172402.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]

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

AnamN
Tera Contributor
In response to Dr Atul G- LNG

‎06-21-2024 11:31 AM

Yes I have tried that option , but unfortunately there is a limitation of rows and columns in Multipivot report type. I think only 5 rows and columns can be selected. there are around 150 fields (columns) for which we need this report.

0 Helpfuls