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