Reporting - relative filter

[Eli Guttman]

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!

[Brad Tilton]

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:

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

[Subhajit1]

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

[Community Alums]

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

[Subhajit1]

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.