How to set filter condition as 'most recent discovery - before - Last 20days' in the snow report?

[Durgaprasad Jo1]

Hello All,

While creating report, how to set filter condition as 'most recent discovery - before - Last 20days' in the snow report? We have option for 7days, 30days, 90days and 120days. How to set it for 20days?

[Durgaprasad Jo1]

Thanks for your response. I need this report to monitor CIs everyday which are not discovered from past 20days. If I select particular date, everyday I need to change in the report. 

[D Dollbaum]

Hi there you can actually get your exact requirement (before 20 days) by using the "relative" function.  This can be used for any number of days (as well as other increments of time.

Example attached.  

Hope this helps.

-Dan

[D Dollbaum · Accepted solution]

Here's the picture of the method I mentioned in my post @Durgaprasad Jois 

I believe this will meet the requirement you gave.

-Dan

[Prasad43]

[juliaelder2234]

There is not a specific filter condition for the "most recent discovery - before - Last 20days" in the snow report. However, you can try using the "Date" filter and selecting "is before" and then selecting "Last 20days" from the drop down menu.