2020 Week 45: Can you show the top 10 products for each state?

Introduction

Hey friends! We all know that Tableau has so many amazing capabilities where nearly anything is possible. Have you ever thought about what you can do out-of-the-box? I’m talking no hacks, no LODs, no table calculations, no actions, just load up a dataset build something amazing.

That’s what this challenge is all about. With the one exception, you’ll need one calculation…and I’ll give it to you. Have a great week.

Requirements

  • Dashboard Size: 100px by 800 px
  • # of Sheets – 3
  • Create a map displaying Profit by color
    • Create an easy-to-interact vertical for the smaller northeastern seaboard states
      • Vermont
      • New Hampshire
      • Massachusetts 
      • Connecticut 
      • Rhode Island
      • New Jersey
      • Delaware
      • Maryland
      • District of Columbia
  • Create a tooltip that shows a table of the top 10 products by sales for each state and for each, show
    • # of orders
    • total sales
    • total profit
    • *Only total profit should be colored
    • Add grand totals
  • Match all other formatting

Here is the State abbreviation calculation for the state mark labels:
CASE [State]
WHEN “Alabama” THEN “AL”
WHEN “Alaska” THEN “AK”
WHEN “Arkansas” THEN “AR”
WHEN “Arizona” THEN “AZ”
WHEN “California” THEN “CA”
WHEN “Colorado” THEN “CO”
WHEN “Connecticut” THEN “CT”
WHEN “Delaware” THEN “DE”
WHEN “District of Columbia” THEN “DC”
WHEN “Florida” THEN “FL”
WHEN “Georgia” THEN “GA”
WHEN “Idaho” THEN “ID”
WHEN “Illinois” THEN “IL”
WHEN “Indiana” THEN “IN”
WHEN “Iowa” THEN “IA”
WHEN “Kansas” THEN “KS”
WHEN “Kentucky” THEN “KY”
WHEN “Louisiana” THEN “LA”
WHEN “Maine” THEN “ME”
WHEN “Maryland” THEN “MD”
WHEN “Massachusetts” THEN “MA”
WHEN “Michigan” THEN “MI”
WHEN “Minnesota” THEN “MN”
WHEN “Mississippi” THEN “MS”
WHEN “Missouri” THEN “MO”
WHEN “Montana” THEN “MT”
WHEN “Nebraska” THEN “NE”
WHEN “Nevada” THEN “NV”
WHEN “New Hampshire” THEN “NH”
WHEN “New Jersey” THEN “NJ”
WHEN “New Mexico” THEN “NM”
WHEN “New York” THEN “NY”
WHEN “North Carolina” THEN “NC”
WHEN “North Dakota” THEN “ND”
WHEN “Ohio” THEN “OH”
WHEN “Oklahoma” THEN “OK”
WHEN “Oregon” THEN “OR”
WHEN “Pennsylvania” THEN “PA”
WHEN “Rhode Island” THEN “RI”
WHEN “South Carolina” THEN “SC”
WHEN “South Dakota” THEN “SD”
WHEN “Tennessee” THEN “TN”
WHEN “Texas” THEN “TX”
WHEN “Utah” THEN “UT”
WHEN “Vermont” THEN “VT”
WHEN “Virginia” THEN “VA”
WHEN “Washington” THEN “WA”
WHEN “West Virginia” THEN “WV”
WHEN “Wisconsin” THEN “WI”
WHEN “Wyoming” THEN “WY”
END

 

Dataset

This week uses the superstore dataset for Tableau 2019.4. 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 @AnnUJackson@LukeStanke, @_Lorna_Brown and @HipsterVizNinja

Solution

Interactive

1 thought on “2020 Week 45: Can you show the top 10 products for each state?”

Leave a Comment

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

Scroll to Top