Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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

yes @Shivani_singh 

 

Take report type = Trend or column

In condition just put closed and resolved.

group by priority

 

AGLearnNGrow_0-1740406337074.png

 

*************************************************************************************************************
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/dratulgrover [ 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. 

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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

How to create that?
Can you please help me.