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.

How to Report on age of ticket per quarter of the year

Joshua Comeau
Kilo Sage

Looking to find the timeline of when a ticket from opened to closed how to display that data?

I am working on a report it is showing same day, 2 days, 2-5 days, 5-7 days, 1-2 weeks, 2-4 weeks, 1-2 months
per quarter of the year


but the data is incorrect how to report on home office build operations closed sctasks same day, 2 days, 2-5 days, 5-7 days, 1-2 weeks, 2-4 weeks, 1-2 months per quarter of the year

 

EX:

JoshuaComeau_0-1723145267426.png

 

 

 

1 ACCEPTED SOLUTION

Group by business duration was the solution

View solution in original post

3 REPLIES 3

AndersBGS
Tera Patron
Tera Patron

Hi @Joshua Comeau ,

 

First of all, to change the timeframe you need to create a report range to match the timeframe. Furthermore, you state that the data is incorrect - what do you mean by this? 

 

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/

@AndersBGS It is showing only 8 closed on the same day but I have checked the closed and opened fields and noticed that more have been closed.

Group by business duration was the solution