2021 Week 13 | Tableau: What percentage of sub-orders are profitable?

Introduction

The goal is a modified mekko chart. My guess is you will need LODs to solve but it is 100% possible with table calculations.

Requirements

  • Dashboard Size: 800px by 400 px
  • Set the bar height to be percent profitable. The level of analysis should be at the sub-category and order level.
  • The lower bar should be one minus the percent profitable.
  • Set the bar width to be percent of total sales (I’ll be watching your axes to tell me if you’ve done this!)
  • Order the bars by the percent profitable metric then on the percent of total sales.
  • Add labels and format.
  • Add animation.

Dataset

This week uses the superstore dataset for Tableau 2020.4. 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.  Also include the hashtag #WOW2021 in your description to make it searchable!

Share

After you finish your workout, share on Twitter using the hashtag #WOW2021 and tag @AnnUJackson, @ItsCandraM, @LukeStanke, @_Lorna_Brown and @HipsterVizNinja

Solution

3 thoughts on “2021 Week 13 | Tableau: What percentage of sub-orders are profitable?”

  1. Hey folks, hope you’re well.. I noticed that #wow2021 under the share title, opens twitter with the search of #WorkoutWednesday2019 🙂

  2. I really like how every Zen Master appears to have his specific area of extraordinary expertise.
    Luke for me will always be the TC Master whereas for example Rosario Gauna is the Queen of Drilldowns.

    Guess I got a solution but as you figured, Luke, I needed LODs. Am really looking forward to how you did it.
    Also, my sorting works but seems overdone somehow. Finally. I can’t get my zero lines to show properly. Guess the way I approached the solution somehow wasn’t optimal

Leave a Reply to Fi Gordon Cancel Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top