Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Need to know the tickets created and tickets closure count in shifts

Siddhant VSK
Tera Contributor

Need to know the tickets created and tickets closure count in shifts ( Morning shift, general shift, afternoon shift, night shift ) , but the catch is that the shifts are overlapping by 2-3 hours .
Ex: Morning shift : 6AM - 3PM , General Shift: 9AM- 7PM , Afternoon shift : 2PM - 10PM , Night Shift: 8PM - 6PM .
Is there a possibility to achieve the tickets created and closed in each of the shifts and not get the tickets duplicated while getting the dump of tickets .
Please let us know , if there is solution for this case.

Thank you,
Siddhant.

2 ACCEPTED SOLUTIONS

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Siddhant VSK 

Yes, you can use the operator Trend in this case.

 

DrAtulGLNG_0-1758280992705.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

Ankur Bawiskar
Tera Patron
Tera Patron

@Siddhant VSK 

you can use Trend in filter condition but since you have overlapping it might not be proper.

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

View solution in original post

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Siddhant VSK 

Yes, you can use the operator Trend in this case.

 

DrAtulGLNG_0-1758280992705.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]

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

Ankur Bawiskar
Tera Patron
Tera Patron

@Siddhant VSK 

you can use Trend in filter condition but since you have overlapping it might not be proper.

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