#WOW2022 | Week 50 | Interactive Proportional Brushing

Introduction

This is my last challenge of the year and what better way to round things off than with everyone’s favourite chart – the bar chart – but let’s make it “sexy”.

Bar charts may be simple but when you combine them with some interactive highlighting and sorting you can create something quite dynamic which can surface a range of insights.

Let’s build a bar chart which highlights the proportion of Sales within each Sub-Category which can be attributed to the Top N products sold.

Happy holidays everyone!

Requirements

  • Dashboard Size: 1100 x 800px
  • 1 sheet
  • Create a Bar chart of Sales by Sub-category
  • For each Sub-category, highlight how much the Top N products contributed towards the Sub-category’s total sales
  • Display this Top N Sales quantity as a percentage of the Sub-category total
  • Allow the user to Sort the bars by Total Sub-Category Sales or by the Percentage covered by the Top N Products (ie: the value calculated above)
      • When the bars are Sorted by Total Sub-Category Sales, display the total value at the end of the bars
      • When the bars are Sorted by Percentage, display the bars as a Percent-of-Total stacked bar chart.

(I recommend interacting with the Viz to understand these two points better)

  • Match tooltips and formatting (choose your own colours =D )

Dataset

This week uses Sample Superstore data (v2022.2). You can find it here on Data.World.
Note: If you use older versions of Superstore your values may appear slightly different.

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 #WOW2022 in your description to make it searchable!

Share

After you finish your workout, share on Twitter using the hashtag #WOW2022 and tag @LukeStanke, @_Lorna_Brown, @HipsterVizNinja, @_hughej, and @YetterDataViz

Solution

Interactive

Scroll to Top