2019 Week 11: Profit: Where? and What?

This weeks Workout Wednesday, has lots of hidden tricks and tips inside. But I want you to mainly focus on a specific part. Sorting in Tableau can be a bit of a pain, it has gotten much better with nested sorting. But this challenge allows you to sort A – Z, Z – A, Profit Asc and Profit Desc, now how do you do that? I also still love Viz in Tooltips, the novelty certainly hasn’t worn off. So this week I focused on a heavily formatted Viz in Tooltip.

Challenge

Click to view on Tableau Public

Requirements

    • Size 600 x 1000 px, 5 sheets.
    • Create a Map which shows Profit by state and Cities sized and coloured by profit
    • Create a City, Abbreviated State (Calc below) by profit.
    • Create a parameter that allows you to sort City, State by A – Z, Z – A, Profit Asc, Profit Desc.
    • Create a Viz in Tooltip
      • City, State and Profit
      • Sub-Category Profit
      • Match all Formatting
    • Use the map to filter by STATE
    • Match all formatting, titles, text and colours.

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, and @curtisharris_!

Track your progress

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

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.

Abbreviation Calculation

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

1 thought on “2019 Week 11: Profit: Where? and What?”

Leave a Comment

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

Scroll to Top