How to run report of tasks that were closed after a specific variable date?

Brent Cox
Mega Guru

We have an offboarding request that has a specific variable to document the "termination date" of the account. Is there any way I can run a report on the tickets that are closed after this date? I tried doing a "closed 1 day after" but it doesn't seem like I can pull a variable from here. Is there a better way? 

1 ACCEPTED SOLUTION

Brad Bowman
Kilo Patron
Kilo Patron

Hi Brent,

Did you try the reverse in the filter - variable... is more than #hours/days before Closed?

BradBowman_0-1729249039085.png

 

View solution in original post

3 REPLIES 3

Brad Bowman
Kilo Patron
Kilo Patron

Hi Brent,

Did you try the reverse in the filter - variable... is more than #hours/days before Closed?

BradBowman_0-1729249039085.png

 

Perfect this worked! Interesting, I normally use the classic view, and from there, I couldn't pull the same information from the report. Where you have "closed" selected at the end of this condition, this wouldn't appear at all in the other view. 

Ha!  I recently switched to the 'new UI' for reports and found I couldn't do something I could in the classic view.  I guess when one doesn't work, try the other!