Incident Report aggregated by time/date

syamano
Tera Contributor

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.

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

@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

@syamano 

Hope you are doing good.

Did my reply answer your question?

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

Dr Atul G- LNG
Tera Patron
Tera Patron

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]

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

Bhuvan
Mega Patron

@syamano 

 

You can use trend option in report to display the incidents created between a time window.

 

Below is a sample report. You can change the visualization type as per your requirements and do group by to show the data in the desired format.

Bhuvan_0-1757656295563.png

 

You can also create Platform Analytics Dashboard and share the details with users/roles/groups or schedule the reports to be sent to stakeholders

Bhuvan_1-1757656588145.png

As per community guidelines, you can accept more than one answer as accepted solution. If my response helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan