Incident Report aggregated by time/date

syamano
Tera Contributor

3 hours ago

Is there a way to create a report that aggregates incident record by the same date or same time?

 

For example, if User wants to aggregate incidents created between 1:00 PM and 3:00 PM, they need to count all incidents created during that time window, regardless of the date.

0 Helpfuls
  • 36 Views
2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

3 hours ago

@syamano 

yes this is possible in reporting

worth checking these links

Reporting on incidents created between certain times daily 

Report showing incidents between 8pm fri and 8am mon - how??? 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron

3 hours ago

Hi @syamano 

 

Yes, you can do that. Use the trend operation on the created field

 

DrAtulGLNG_1-1757581906256.png

 

DrAtulGLNG_0-1757581872510.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