Question
How to create a quick-filter slider that filters the view based on a date relative to today’s date.
How to create a quick-filter slider that filters the view based on a date relative to today’s date.
Tableau Desktop
The following steps use the view and data source included in the attached Tableau workbook, relative-date-slider.twbx. Download the workbook to follow along with the steps.
DATEDIFF('month',<date>,Today())
Where <date> is the name of the date field you want to use in the filter.
Using the slider, you can specify the number of months to display in the view, between today and the <date> field.
Tip: You can edit the title of the quick filter to make it more intuitive for your viewers. For example, change it to Months from Today.