2019 Week 8: What percentage of products make up 80% of sales?

For this week’s workout, we look at one of my favorite chart types, the pareto. I love the pareto chart as a data exploration resource, and also as a powerful analytic resource. If you aren’t familiar with the pareto, the purpose is to see what % of x, makes up what % of y, with the common assumption that 20% of the x makes up 80% of the y. This week’s workout takes this chart a couple steps further by identifying the point where the % of x crosses 80% of the y. We will also give our users the power to drill into the actual values of any subset of the x. A key piece of this challenge is using Tableau’s built in functionality to your advantage, try and build this viz with two or less written calculated fields!

Have fun!

Requirements

• Dashboard size is 1200×500 – 2 sheets
• Place a circle on the mark where the % of Total Products crosses the 80% of Total Sales threshold
• Place a reference line at 80% of Total Sales and 20% of Total Products
• Use Tableau’s out of the box features – only two written calculated fields allowed
• Dynamically show/hide selected products from the pareto chart
• Make sure there is 15px of inner padding on all sides of your worksheets, and the left and right sides of your title and line separator
• Match colors, tooltips, fonts, and formatting

Dataset

This week uses the superstore dataset for Tableau 2018.3.  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.

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.