Allow users to choose Days/Weeks/Months for a relative date in report filters

9

When users choose relative dates in a report filter, allow them to choose both a number and time period -- 1 Day Ago, 3 Months Ago, 2 Weeks Ago, etc.

We have the right dropdown for these time periods for Recurrence Intervals, but for filters we need to have separate templates for Days and Months.

Category

Status: 
Under review

Comments

Re: Allow users to choose Days/Weeks/Months for a relative ...

Moderator

Hi Elizabeth,
I realize it's been a while since you posted this.  You are able to choose relative dates in a report filter, but it requires a different date set-up when you create the report template.  I believe it is controlled by the "Change transform" button and instead of using "Raw Data", you transform to Days ago (or months or weeks ago).
-Alex

Re: Allow users to choose Days/Weeks/Months for a relative ...

Moderator

Thanks, Alex, I see I wasn't clear in my original message.  We know how to change the transform, but this means we have to have two versions of nearly every report that uses date ranges:

LIA-08-01: List of items by owning library, copy location and ACTIVE date range (month)

LIA-08-02: List of items by owning library, copy location and ACTIVE date range (day)

That's what we're doing now, but this leads to long lists of templates and is one of the things that makes it difficult for users to spot and grab the correct template to do a report.  What we'd like to have is the date presented the way it is for the Recurrence Interval, with a dropdown for number and a dropdown for day/week/month/quarter/year.