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
Tableau Class Notes: A Use Case for the Self Join It’s no secret that Tableau Prep is a game changer for those looking to clean, explore and connect their data sources together. There ...
I’ll Take Jeopardy! Champions for 500, Please I’m a bit of a Jeopardy! fanatic. Okay, that’s an understatement. I love Jeopardy! and I love trivia. Given the recent airing of the ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

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