#WOW2023 | Week 41 | Can you build a flexible tabular display?

Tableau, Workout Wednesday / By

Introduction

So my week has rolled around again, and yet again the inspiration for this week comes from this viz by Sam Parsons – Man! That guy is good!! 

This week I’m asking you all to recreate a tabular display. It’s a common request from users to just ”show me all the numbers”, while we as visualisation developers try to encourage a more visual/summarised view.

In this challenge we’re trying to balance that type of request by providing a flexible display that allows the user to choose between a visual or textual display, and a summarised or detailed view.

Click to open in Tableau Public

Requirements

  • Dashboard size 1300 x 900
  • Build a crosstab displaying the Sales and Profit Ratio for each Category and Sub-Category by Region and Year
    • When the user selects Show as: Bars, display the data in a bar chart
    • When the user selects Show as: Numbers, display the data as text values
    • When the user selects Show Year Details: True, display the total sales and overall profit ratio for each Year, along with the average value of the measures for the Region.
    • When the user selects Show Year Details: False, the columns relating to the Years should disappear.
  • Match formatting and tooltips 
    • I chose a ‘coffee & cream’ colour palette, but feel free to adapt as required. If you want to match my display then
      • Font : #7d4e47
      • Positive Profit Ratio font : #7d4e47
      • Negative Profit Ratio font : #ff6f6a
      • Bars as above but at 35% opacity
      • Background colours: Light #fefaf1, Mid #faf4e7, Dark #f5eddc

If you need help, Sam has a video which talks through how he built the viz.

Dataset

This week uses the latest version of the Superstore data set (v2023.2). You can find it here.

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

Solution

Interactive

Scroll to Top