Last week I had the honor of attending Tapestry Conference in Miami. While I was there Jon Schwabish gave a quick 6 minute talk that connected every chart to every other chart. This along with some of Elijah Meek’s keynote mentioning that data viz is getting more custom and funky got me curious about some neglected chart types. Combine this with a recent interest in how clustering works in Tableau and you’ve arrived at the genesis for this week’s challenge. Your goal is to create a Parallel Coordinates chart (click the link if you’re not sure what it is).
This chart is perfect for multivariate analysis and seeing relationships among more than 2 measures (in this case 3). It can also be useful for finding commonalities among things. Traditionally I think most people may shy away from implementing this in Tableau because quite often different measures have different scales, so as part of the challenge, you’ll have to figure out how to overcome that obstacle to present a parallel coordinate chart with 3 measures of different magnitudes.
Also to help reinforce some recent challenges using table calculations – you are not allowed to use LODs and must only use table calculations and regular calcs.
- Dashboard size: 1200 x 850; you choose # of sheets
- Create a parallel coordinate chart that shows Sales, Profit Ratio, and # Customers (CountD Customer Name) per sub-category
- Do not use LODs, use table calculations (and normal calculated fields)
- Each sub-category should be positioned based on its value, but all measures should be on one sheet
- Ensure there is a dark gray vertical line for each measure
- Label the top and bottom of each vertical line with the measure name and respective minimum or maximum
- Color the lines based on which measure the sub-categories have the highest value in
- Colors are based off of the Viridis color palette, which I encourage you to paste into your .TPS file
- Create a color legend that has a hover action based on the newly defined colors (high sales, high profit ratio, high customers)
- Match formatting & tooltips
This week uses the superstore dataset for Tableau 2018.3. You can get it here at data.world
When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.
After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2018 and tag @AnnUJackson, @LukeStanke, @lorna_eden, @curtisharris_, @RodyZakovich, and @VizWizBI!
Track your progress
Also, don’t forget to track your progress using this Workout Wednesday form.
5 thoughts on “Week 49: Where Do Sub-Categories Succeed?”
How did you get the labels to show up on the graph too, when you hover over HIGH SALES, HIGH PROFIT RATIO OR HIGH CUSTOMERS?
You may want to check out Curtis’ video walkthrough – he talks about how he solved it (using ATTR) here: https://www.youtube.com/watch?v=BmiHTce3JlY
Are the solutions to these tasks posted somewhere?
You can find the solutions to all the challenges by using the links to our Tableau Public profiles. You’ll be able to download each of the workbooks and see how we engineered each solution.
first of all, Merry Christmas!!
I found this one quite challenging – i figured out almost everything but i had to watch your workbook for the damned axis lmin/max labelling.
It has been very interesting – thank you
Here’s my shot