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.

30, 60, 90 Day Aging Tickets Widget

Peter B
Giga Expert

Hello Community,

I am trying to create a 30,60, and 90 day ticket aging widget (tickets that are in someone's queue) and I cannot figure out the correct logic/expression to add in creating this widget. I cannot figure out the correct expression to tell the report to show a list of records that are still open after 30 days since its created, 60, days that a report that has been opened since it was created, and 90 days...For example, when I do the 60 day report, it will also include the 30 days tickets which is not what I want. I only want to see tickets that have are still open 60 days after its creation without including the 30 days. Below is what I currently have for my 60 day report but also picks up the 30 days. Any suggestions is much appreciated:

find_real_file.png

1 REPLY 1

Boyan1
Kilo Sage

Hello, 

I believe that below filter will capture the needed tickets

 

find_real_file.png

Best regards,

Boyan