If you are new to Tableau, you may not have heard of Workout Wednesday Challenges. What are they? They are weekly challenges to expand your mind with different applications! Tableau is just one of them! Some of the first challenges were posted by Andy Kriebel in his VizWiz site from 2017!
How it works: First they post the challenge (on a Wednesday)and then they post the solution (on a Friday typically). You can recreate the challenge using Tableau Public and you can tag the week in your dashboard title! Example: #WOW2024|Week40
Tableau Essentials - Link
If you are new to Tableau I recommend checking out all of the challenges in the above link. The administrators of this site curated all of the challenges that have the basics for beginner users!
Multiple Select Parameters - Link
Can you select multiple filters based on selections that you click? Tableau has Cascading Filters which will allow you to hide selections that are not pertinent to a main (or Parent) filter; However, this method can slow down your dashboard. Is there a visual alternative? Yes, follow the solution in this Workout Wednesday Challenge!
This topic is a question I've received multiple times, so I created a Tableau public dashboard for this using the Real World Fake Data (or #RWFD by Mark Bradbourne) Hospitality data set here. The issue with the solution they used is that you really needed a third option in the calculated field. With their solution, if all were selected, they were all green. If none were selected, they were all green...so I modified the calculation in mine to display white if none were selected. If all were selected, they are blue. You can download my workbook if you wish to see the calculated field for this. I also changed my selections to check boxes instead of using the bar/button method.
Here is a video of what I am referring to in this dashboard!
One thing I could do with this dashboard to take it a step further is to add a reset or clear filter for the selections. I talk about how to do this in a past blog post here.
Brush Filter - Link
I thought this challenge was interesting. I've seen charts on google where you can select two points on a line graph and the data will change. In this challenge you select two points on the bar chart and the rest of the dashboard is filtered by the date range or bars selected! Fellow Tableau Social Ambassador Will Perkins has a dashboard example here (as shown below). It's from an older challenge but the dashboard is similar to the solution.
Comments