Aug
21
Creating Date Range Filter with Dynamic End Date = Max Date
Since the version 2020.1, Tableau has a new dynamic parameter feature that solves a long standing problem: Making a date range filter with end date default to the max date in the data source.
Here is how it works:
1.Create a field Max Date = {Max(Order Date)}
2.Create a parameter End Date as follows. Set value when workbook opens to be the above Max Date.
3.Create your regular Start Date parameter and a date range filter
Here we got an example workbook for you to download. It will always open to the last date of the data set as the End Date.
Update: I found an issue when working with data extract on server. The solution is
Create a local copy of the extract.Create Max Date and publish data extract to the server along with the field.Then the dynamic parameter works.
Here is how it works:
1.Create a field Max Date = {Max(Order Date)}
2.Create a parameter End Date as follows. Set value when workbook opens to be the above Max Date.
3.Create your regular Start Date parameter and a date range filter
Here we got an example workbook for you to download. It will always open to the last date of the data set as the End Date.
Update: I found an issue when working with data extract on server. The solution is
Create a local copy of the extract.Create Max Date and publish data extract to the server along with the field.Then the dynamic parameter works.
