8 Replies Latest reply on Mar 9, 2016 5:29 PM by Tableau kumar

How to Dynamically Restrict Date Parameters?

Adina Markowz Mar 9, 2016 2:15 AM

Hi everybody,

I am new to this forum, but after hours of fruitless searching, I wanted to see if anybody here can help me.

Background:

- I am using 2 date parameters to filter (because I have two data sources on the dashboard), StartDate and EndDate

Problem:

- When I select a start date that lies behind the end date, (obviousely) no data is shown

- I want to make it impossible to select "overlapping" start and end dates

- The max value of the start date should be the end date, and the min value of the end date should be the start date (dynamically!)

A few years ago, someone already posed this question here: https://community.tableau.com/thread/111060#comment-35408.

However, there seemed to be no solution:

“> to be able to restrict the available dates of one parameters according to the other

Not currently possible, another very nice idea for a feature request.”

Hopefully, by now there is a way!

Thank you very much in advance for your help!

--- Please take into account that I am (almost) a total Tableau Newbie ---

Best,

Adina

Date Range with Parameters.twbx 1.5 MB

1. Re: How to Dynamically Restrict Date Parameters?

Shinichiro Murakami Feb 24, 2016 9:04 AM (in response to Adina Markowz)

Could you attach your packaged workbook, please.
Attaching a Packaged Workbook

Shin
Like Show 0 Likes(0)

Actions
2. Re: How to Dynamically Restrict Date Parameters?

Tharashasank Davuluru Mar 9, 2016 1:08 AM (in response to Adina Markowz)

Hi Adina,
we need to use cascading parameters to achieve that.
Like Show 0 Likes(0)

Actions
3. Re: How to Dynamically Restrict Date Parameters?

Adina Markowz Mar 9, 2016 1:30 AM (in response to Tharashasank Davuluru)

Hi Tharashasank,

Thank you for your quick response.
Can you go a little bit more into detail what I have to do?

But good to know that there might be a way to solve the issue.
Like Show 0 Likes(0)

Actions
4. Re: How to Dynamically Restrict Date Parameters?

Tharashasank Davuluru Mar 9, 2016 1:41 AM (in response to Adina Markowz)

Hi Adina,
Please look into this blog. The Vizioneer: Clickable Drillable Cascading Dynamic Parameters in Tableau
Like Show 0 Likes(0)

Actions
5. Re: How to Dynamically Restrict Date Parameters?

Giridhar Nandigam Mar 9, 2016 1:58 AM (in response to Adina Markowz)

Hi Adina,

you can leverage custom sql technique

select distinct a.*, ifnull(a.date1,a.date2) as enhanced_filter
from table1 a
join (select max(date2) as max_date,min(date1) as min_date from table1) b
on (a.date1 between min_date and max_date) or (a.date2 between min_date and max_date)

now use the enhanced_filter as a regular date filter where start and to date can be given...
Like Show 0 Likes(0)

Actions
6. Re: How to Dynamically Restrict Date Parameters?

Adina Markowz Mar 9, 2016 2:26 AM (in response to Giridhar Nandigam)

Hi Giridhar,

Thank you! I still don't really know how to do it.
Do you think you could attach the workbook where you have solved the problem?

My problem is, that I am not yet very familiar with the terms and functions that you referred to.

And Tharashasank Davuluru, I had already looked at this "How To". But because it is now about date parameters, I didn't manage to transfer it to my problem.
Like Show 0 Likes(0)

Actions
7. Re: How to Dynamically Restrict Date Parameters?

Giridhar Nandigam Mar 9, 2016 4:21 PM (in response to Adina Markowz)
Hi Adina,

Attached is the workbook, essentially i have combined the distinct values
of start and end dates of 2 different columns in to one custom column and
used that as a filter so that start and end date can be used.

On Wed, Mar 9, 2016 at 2:26 AM, Adina Markowz <tableaucommunity@tableau.com>

Dynamic Date Parameters.twbx 1.2 MB
Like Show 0 Likes(0)

Actions
8. Re: How to Dynamically Restrict Date Parameters?

Tableau kumar Mar 9, 2016 5:29 PM (in response to Adina Markowz)

Tableau BI: How to get the sales for specified period, it means from specified date to specified date.
The above link helps how to get the data for specified period, you can enhance that logic for your requirement.
(Fixed :max(From parameter))

I am replying from Android, there is no curely parenthesis option so follow exact syntax.
Like Show 0 Likes(0)

Actions