Instead of using a date filter to show all the dates previous to today, a calculated field similar to the following can be used:
Then, place this on the filter shelf and select True. Right click on the calculation on the filter shelf and select Add to Context. Then, if the date slider is still desired, the date field can be put on the filter. Right click on it's quick filter menu and select All Values in Context. The slider will not necessarily update to the most recent date, however, the user will not be able to move the slider beyond the most recent date.
Hope this helps!
This is a good idea, but it is not exactly what I am looking for. My data source only contains historical data, so I am not worried about the user selecting a "wrong" date. However, because my data source is quite large, I would like to extract to update every day to show the most recent data by default, while allowing the user to look at old data if he wants to.
Right now, my only solution is to have a separate worksheet with no end-point for the date slider.
This would be a good one to add to the Ideas section, as I know several people have requested it in the past. The date slider will keep whatever is published, as Tableau doesn't know that the user might want the most recent date, since it was set to a different date previously.
Did you try option in quick filter - "Special" and then select "all date".
Slider will always pick max and min date from database on every refresh.
Just ensure when you close quick filter window, Special tab is selected, not date range.
Used Version - 10.1
Connection type - Live