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.

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
  • 523 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