Reporting - relative filter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2014 07:55 AM
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!
- Labels:
-
Service Mapping

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2014 08:22 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2014 09:30 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2015 09:05 AM
hi...Subhajit, writing LAST 5 MONTHS will work? whereas there is no defied thing for same in dropdown
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2015 10:14 PM
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.