2020 Week 30: Can you create a drill down using set actions?

Introduction

Hey #WOW2020, Emma Whyte here. It’s been a blast being back building a Workout Wednesday! It’s been about 2 years 7 months since my last WOW with Andy Kriebel when we kicked off this project in 2017. It’s been fun, and a little bit stressful, getting back into the mindset of setting a weekly challenge.
 
I took a trip back through our WOW’s from 2017 and stumbled across a drill down challenge from week 41. I wondered if any of the newer features in Tableau made this challenge any easier? Answer was pretty much NO!

Requirements

Your challenge this week is to create a scatterplot drill down. 
  • The scatterplot should start at state level and by clicking a state should drill down to city level for the state you’ve selected
  • Clicking a city mark should drill you back up to state level
  • Create the drill down with set actions. No dashboard filter actions, etc.
  • Create the title and make sure it changes depending on what has been selected
  • Marks are coloured red if they are unprofitable and blue if they are profitable
  • Match the tooltips and formatting
  • Dashboard size 800*700

Dataset

This week uses a sample of the superstore dataset. You can get it here at data.world

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.  Also include the hashtag #WOW2020 in your description to make it searchable!

Share

After you finish your workout, share on Twitter using the hashtag #WOW2020 and tag @EmmaWhyte, @AnnUJackson@LukeStanke , @_Lorna_Brown and @HipsterVizNinja

Solution

Interactive

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top