-
1. Re: How to Dynamically Restrict Date Parameters?
Shinichiro MurakamiFeb 24, 2016 9:04 AM (in response to Adina Markowz)
-
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.
-
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.
-
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
-
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...
-
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.
-
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
-
-
8. Re: How to Dynamically Restrict Date Parameters?
Tableau kumar Mar 9, 2016 5:29 PM (in response to Adina Markowz)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.