Report for incidents opened within a time period

joshmorris
Tera Guru

Hi,

 

I need a report that shows incidents opened between 6-7pm everyday. But to have it so I can see the data of this for say the last 6 months. Is there a way to configure this?

2 ACCEPTED SOLUTIONS

Anurag Tripathi
Mega Patron
Mega Patron

Hi,

This should work for you. You will have to be careful with time zones, as this would run in logged in user's time zone.

incident created 6-7.png

 

 

 

-Anurag

View solution in original post

Try to run the above condition with the time frame means without

AGLearnNGrow_0-1729609296990.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]

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

View solution in original post

5 REPLIES 5

Anurag Tripathi
Mega Patron
Mega Patron

Hi,

This should work for you. You will have to be careful with time zones, as this would run in logged in user's time zone.

incident created 6-7.png

 

 

 

-Anurag

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @joshmorris 

 

It is easy to do in SN

 

AGLearnNGrow_0-1729608488789.png

 

 

Use the trend operator. 

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

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

joshmorris_0-1729608908718.png

This didn't work for me. It returns 0 records when there definitely should be 

Try to run the above condition with the time frame means without

AGLearnNGrow_0-1729609296990.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]

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