Create a report that shows how many incidents created per hour, per week, per week and per month

Rahul Raja Sami
Tera Guru

How to create a report that shows how many incidents created per hour, per week, per week and per month related ro some group or CI ?

please help.

8 REPLIES 8

Hemanth M1
Giga Sage
Giga Sage

Hi @Rahul Raja Sami ,

 

Create a trend type report as below > in the type section select trend.

 

you can group by CI or Assignmnet group to relate

 

HemanthM1_1-1697479878533.png

 

You have option to selcet per hour,day, Month, Quarter, Year ...

 

 

 

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

In addition to this when I group by CI, I also want to group them by assignment group or Assigned to.  I think interactive filter will do that but how to make assigned to filter depends on assignment group filter ?

Hi @Rahul Raja Sami ,

 

Add addtional group by as "Assignment group" and create interactive filter on the assigned to Field as below.

You can filter on both Assignment group / Assigned to /CI's

 

HemanthM1_0-1697559429814.png

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

AndersBGS
Tera Patron
Tera Patron

Hi @Rahul Raja Sami ,

 

Reports can be created through the report designer utilizing the incident table, where time series reports can be generated:

 

AndersBGS_0-1697485753372.png

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/