Generate Report for non-business hours

Rakshanda Kunte
Tera Contributor

Hi All,

 

Requirement: We need to create a report to show incidents created in non-business hours. i.e. It should run daily from 6pm - 4am and show the data in the report.

 

What filters we can apply?

 

 

 

Thanks.

1 ACCEPTED SOLUTION

Hi @Rakshanda Kunte ,

 

I would think that the conditions should be set as below:

AndersBGS_0-1706601021659.png

 

Above will work as a daily report that runs after 4AM.

 

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

5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Rakshanda Kunte 

 

You can create report like this

 

LearnNGrowAtul_0-1706521758713.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]

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

AndersBGS
Tera Patron
Tera Patron

Hi @Rakshanda Kunte ,

 

You can create a condition like the one below:

AndersBGS_0-1706521796080.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/

Hi @AndersBGS ,

 

When I apply this filter there are no records shown. 

However, when I apply only one of the filters it shows the incident list else with both filter there is no data.

I tried with 'OR' operator, but it shows today's data from 12 am onwards.

 

Requirement is to get the data from 6pm-4am (hours requirement is changed). 

 

Would you please share your inputs?

 

 

Thanks.

 

Hi @Rakshanda Kunte ,

 

I would think that the conditions should be set as below:

AndersBGS_0-1706601021659.png

 

Above will work as a daily report that runs after 4AM.

 

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/