Introduction
This weeks #WorkoutWednesday is the first of a two part series. My thanks to Neil Lord (again) for the challenge this week. I appreciate our “can Tableau do this?” chats!
This week, for the first part of this viz, you’ll have to create a highlight table that is sortable in every which way. The inspiration from this came for a requirement from a customer that Neil is currently working with. You might not consider it an amazing viz, but it’s something similar to what I’ve been asked for previously in the field. Hopefully it will also boggle your mind for a bit and get you really thinking.
Requirements
This week the requirements are:
- Dashboard size is 450*700 (mobile friendly)
- Create the profit ratio calculation
- Create the highlight table showing profit ratio by ship mode and sub-category.
- The columns should be sorted by the ship mode selected in the drop down first, followed by the remaining ship modes. The remaining ship modes are also sorted descending by their overall profit ratio. For example if you select Same Day in the drop down, Same Day should appear as the left most column, followed by Standard Class (13.1% profit ratio overall), Second Class (12.0% profit ratio overall) and First Class (11.3% profit ratio overall). I’ve put an image below of the Ship Modes profit ratios so you can check.
- The rows – product subcategories – should be sorted ascending or descending (depending on end user selection) of the profit ratios for the selected ship mode.
Dataset
Use the most recent version of Superstore otherwise download the data
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 #WOW2023 in your description to make it searchable!
Share
After you finish your workout, share on Twitter and/or LinkedIn using the hashtag #WOW2023 @Tableau and tag @WorkoutWednsday @EmmaWhyte & @vizwizbi
Solution
Interactive
