Reporting - relative filter

Eli Guttman
Tera Guru

Hello,

 

Can someone point me to an explanation on the relative operator, when using date filter in reports?

How can i use it and in which cases?

 

Thank you!

7 REPLIES 7

Brad Tilton
ServiceNow Employee
ServiceNow Employee

I couldn't find any documentation on using the filter, but here's an example. Let's say I wanted to run a report that shows approvals that are requested and were created more than 24 hours ago, but are not older than a week. I could use this report:



faee206a8d.png


You can really use it any time you want to relatively report on a date field.


Subhajit1
Giga Guru

Hi Eli,


You can also use the Relative Option in the Filter when you do not have Predefined Options in the Duration Dropdown, for example:-



We have the Last 3 months, Last 6 months options available, but if we require Last 2 months, Last 5 months and so on for Durations for which Ready Options are not available, you can use the Relative Option to Build your Duration Query.



Thanks,


Subhajit


hi...Subhajit, writing LAST 5 MONTHS will work? whereas there is no defied thing for same in dropdown


Hi Ankit,


For options that are not readily available, like Last 5 months, you will have to use the RELATIVE option in the filter condition builder.


Let me know if that helps.