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: .
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
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...
