We’re back for 2019. We’re using the hashtag #WorkoutWednesday2019. The challenge this week involves building a dynamic drill-down table. This one is slightly more difficult than average so be sure to check the spoilers at the very bottom if need be.

Challenge

 


 

Click to view on Tableau Public

Requirements

  • Dashboard size is 500px wide by 600px tall.
  • Create a table that shows sales for category and year. When you click on a category show the sales by sub-category below it.
  • Use the right arrow “►” and the down arrow “▼” to indicate when details are showing. This makes it look like an accordion.
  • Match row borders and row shading to highlight these values.

Dataset

This week uses the superstore dataset for Tableau 2018.3.  You can get it here at data.world

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @AnnUJackson, @LukeStanke, @lorna_eden, @curtisharris_, and @VizWizBI!

Track your progress

Also, don’t forget to track your progress using this Workout Wednesday form.

Spoilers

  • Union the data to itself one time.
  • One part of the union will create the summary for category and the other will create the summary for sub-category.

5 Comments

    1. Alfie Smith February 12, 2019 at 4:12 am

      Still trying to figure out dynamic drill-down and the “arrows”.
      Tableau Newbie here

      Reply
    2. Syed February 12, 2019 at 5:02 am

      How did you get the arrows to change?

      Haven’t figured that out yet

      Reply
  1. G.Chandra Reddy February 14, 2019 at 10:54 am

    Awesome …

    Reply

Leave A Comment

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