Reporting Incidents on amount, day and creation time possible?

AdamUMC
Giga Guru

Hi there,

I would like to report how much Incidents were created after our daily service window (let's say 6:00 p.m. till 7:30 a.m.). I would like to see:
- Amount of Incidents
- Creation time (rounded) of each Incident

It would be nice if the Y- axis could have the hours and the X- axis the days, but then there would be no space for the amount of Incidents. A table grouped on the days and rounded hours would be good enough was well.

I have no Performance Analytics, so I'm wondering if this even is possible?

Thanks!

1 ACCEPTED SOLUTION

Hi @Dr Atul G- LNG and @AdamUMC ,

 

Just create the report based on below basic condition - one minor correction is, that ServiceNow OTTB only shows whole hours - not half hours:

AndersBGS_0-1704885228629.png

The condition can off course be enhanced according to specific needs.

 

Based on the condition, the trending can be made by hour of day:

AndersBGS_1-1704885301542.png

Or by day/year:

AndersBGS_2-1704885335456.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/

View solution in original post

9 REPLIES 9

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @AdamUMC 

 

I tried the 1st part created after our daily service window (let's say 6:00 p.m. till 7:30 a.m.). 

But did not get any way to filter , as dynamic. 

 

Or 

Give a try on metrics , on created field.

 

or

 

PA is only way.

 

@AndersBGS  thoughts.

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

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

AndersBGS
Tera Patron
Tera Patron

Hi @Dr Atul G- LNG and @AdamUMC ,

 

There is no problem in creation of report for service window (let's say 6:00 p.m. till 7:30 a.m.). This can give you a report where you can see incidents created in the time span either by time of day or by day e.g. if you would like to see a trend by week. @AdamUMC you can't have both day and hours in the same report, hence only solution is to create two reports instead of just on. 

 

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/

Hi @AndersBGS 

 

Thanks for giving me a good confidence. We can achieve this via Schedule or kind of maintenance window?

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

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

Hi @Dr Atul G- LNG and @AdamUMC ,

 

Just create the report based on below basic condition - one minor correction is, that ServiceNow OTTB only shows whole hours - not half hours:

AndersBGS_0-1704885228629.png

The condition can off course be enhanced according to specific needs.

 

Based on the condition, the trending can be made by hour of day:

AndersBGS_1-1704885301542.png

Or by day/year:

AndersBGS_2-1704885335456.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/