Can I create single a report on the below requirement

Shivani_singh
Tera Contributor

How can i create a single report :
total incidents logged for each priority & "Closed+Resolved" incident count for each priority in a particular time frame.

15 REPLIES 15

Dr Atul G- LNG
Tera Patron
Tera Patron

yes @Shivani_singh 

 

Take report type = Trend or column

In condition just put closed and resolved.

group by priority

 

AGLearnNGrow_0-1740406337074.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]

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

But how can i see total no of records created by priority.

Hi @Shivani_singh 

 

SO you want to be Resolved + Closed as total, which is not possible in those reports, for that you need to create a pivot type. 

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

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

How to create that?
Can you please help me.