Tableau Class Notes: Filtering with a Date Slider

Data

Tableau Class Notes: Filtering with a Date Slider

This question comes from my student Christie. She wanted a quick way to create a date slider that started after a certain point in her data. The issue is, if you set your Range of dates or Starting Date filter to begin at a certain date, your user can still adjust it to go back to the beginning of your data:

filtering with a date slider in Tableau

filtering with a date slider in Tableau

So what’s the solution here? Just create a quick calculation. Since we want our slider to only start after a certain date (in our case, 12/31/2011), we can create a calculated field that will return only dates after our desired start date:

filtering with a date slider in Tableau

This calculation looks at everything after whatever our starting date should be and returns an Order Date. If it’s not after 12/31/2011, then we can just discard it as a Null! We can then place this calculated field on our filters card since the resulting data type is a date. When you show that filter, allowing your users to choose their own date range, the data will now only start at 2012. Just what we wanted!

filtering with a date slider in Tableau

That’s all there is to it—a quick fix to what can be a very frustrating issue with filters. Thanks for reading, and see you in class!

More About the Author

Liz Jensen

Analytics Consultant
Alter Your Analysis: Unofficial Holidays We know what dates Halloween, Christmas, and US Independence Day are on. But what about National Dogs in Politics Day or National ...
Alter Your Analysis: Women’s World Cup Match Wins In this second installment of Alter Your Analysis, I am tackling Alteryx’s Weekly Challenge 169: “Using the values in the attached file ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Love our blog? You should see our emails. Sign up for our newsletter!