#WorkoutWednesday – Week 6: Regional Sales Across the Product Hierarchy

This week you will need to use your formatting skills and your knowledge with formatting color. You’ll also be using using the rarely-utilized hierarchy on this dashboard and you’ll need to utilize the “+” and “-” to drill in and out of the hierarchy.

Below are images and check out the version on Tableau Public

Requirements

  • The dashboard size is 600px by 800px
  • You must use Category and Sub-Category in your product hierarchy.
  • Right-align each member in the hierarchy.
  • Sort each level in the hierarchy descending by sum of sales.
  • Match the color on Region using a palette. You may not custom assign, you must assign a palette that comes with Tableau.
  • Show “lines” going from the region with the lowest value in a member of the hierarchy to the highest level.
  • Make sure the min/max “lines” also sits between a horizontal grid line.
  • Make the “lines” between min/max values appear as a thin black line.
  • Use Segment as a filter.

This week utilizes the Superstore dataset. You can get it here at Data.World

As you complete this example, feel free to share on Twitter using the #WorkoutWednesday hashtag. Don’t forget to tag @VizWizBI, @RodyZakovich, and @LukeStanke. We really want to see your work.

Also, if you want your efforts throughout 2018 tracked, feel free to fill out this Google Form.

Good luck!

Spoilers

  • Seriously, there is a palette that if you assign colors will give you exactly what you see.
  • Add a white border to your black bar to make it appear to be a thin line.

7 Comments

  1. Anu February 8, 2018 at 6:22 pm

    Hi Luke,
    I completed most part of the wednesday workout challenge except for the line joining the min sales to the max sales for each sub-category. I tried creating it using the reference band with no success.
    Could you please help me with some tips.
    Thanks!

    Reply
    1. Luke Stanke - Site Author February 12, 2018 at 12:18 am

      Try using a line instead of a reference line.

      Reply
      1. Anu February 12, 2018 at 5:50 pm

        Thanks so much!

        Reply
  2. Aaron March 14, 2018 at 7:09 pm

    Are the solutions for these posted somewhere? I know this one is old but I’ve been working through them to help me learn. I can do everything except the line connecting the min/max points. I feel like I’m missing something obvious.

    Reply
    1. Luke Stanke - Site Author March 20, 2018 at 2:54 am

      We’re hoping to post them for every week. You can always download the workbooks. Most calculations have labels that are step-by-step.

      Reply

Leave A Comment

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