5 Replies Latest reply on Jun 27, 2016 1:27 PM by Saurabh Siroya

date range filter slider

Alexis Jensen Mar 31, 2016 12:16 AM

Hi,

I have a couple of years of data and I need to be able to set a quick filter (preferably a slider) that can have a start and end date, as opposed to a single date slider. eg: 04 Aug15 to 11 Feb 16. Is this possible? I don't see it as a filter type on the menu list. I don't really want to have to use the checkbox list with so many data points.

Help is appreciated.

Regards,

Alexis

1. Re: date range filter slider

Andrew Watson Mar 31, 2016 1:07 AM (in response to Alexis Jensen)

Try using Parameters instead - create a start date and end date parameter. Then use the results of the parameter selections in a calculated field. For example:

If [Date]>=Parameter.StartDate and [Date]<Parameter.EndDate then 'show' else 'hide' end

Put that calculated field on the filter shelf and set to 'show'.
Like Show 0 Likes(0)

Actions
2. Re: date range filter slider

Łukasz Majewski Mar 31, 2016 1:14 AM (in response to Alexis Jensen)

Yes, but make sure your pill is continuous (green):

I do not recommend parameters unless really necessary.

Cheers,
Łukasz
Like Show 0 Likes(0)

Actions
3. Re: date range filter slider

Alexis Jensen Mar 31, 2016 10:28 PM (in response to Łukasz Majewski)

Thanks Lukasz.

Works perfectly
Like Show 0 Likes(0)

Actions
4. Re: date range filter slider

Saurabh Siroya Jun 27, 2016 1:27 PM (in response to Alexis Jensen)

Hello,

I have a business requirement where I want to use the relative filter but the current date should be a user input and based on that I should be able to select Weekly, Monthly and Quarterly view. Or is there a way to create a date as an input for the user and based on that I will have a list from which I can select weekly, Monthly or a Quarterly view.

Please help.

Regards:
Saurabh Siroya
Like Show 0 Likes(0)

Actions
5. Re: date range filter slider

Saurabh Siroya Jun 27, 2016 1:27 PM (in response to Łukasz Majewski)

Hello,

I have a business requirement where I want to use the relative filter but the current date should be a user input and based on that I should be able to select Weekly, Monthly and Quarterly view. Or is there a way to create a date as an input for the user and based on that I will have a list from which I can select weekly, Monthly or a Quarterly view.

Please help.

Regards:
Saurabh Siroya
Like Show 0 Likes(0)

Actions