2019 Week 33: 2018 IronViz Finalist Corey Jones’s Table Challenge

This week are excited to continue the community challenge month by welcoming Corey Jones. Based out of Philadelphia, Corey was a 2018 IronViz Finalist and is an avid sports fan.

One of the great things that comes with working with a talented team is that you have the opportunity to learn from and push each other to improve. I am fortunate to work with Garvi, Kizley and (twitterless) Hima. Often we are challenging each other to solve formatting tricks or other problems. Today, I bring you a challenge from our team:

Listen, we all have had to create a table in Tableau. And if you are like me, you’ve probably been asked “Can you shade certain rows?”, or even better, “Can you make some rows bold?” Typically, I say no — because who wants to do that — but today we are going to practice. I hope you like formatting, because this week is all about creative formatting!

Challenge – Intermediate

Click image to view on Tableau Public

Requirements – Advanced

Same rules as above, plus…

• KPI Table:
• Rows appear shaded and bold for sub-categories where the filtered region contributes greater than a user-defined value for % of total sales
• Stacked Bar Chart:
• Labels are on the inner edge and the labels may not be manually positioned
• The entire dashboard should appear as one worksheet with no gaps in row dividers.

   

Dataset

This week uses the superstore dataset for Tableau 2019.1. You can get it here at data.world

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @CoreyJ34, @AnnUJackson, @LukeStanke, @lorna_eden, and @curtisharris_!

Track your progress

Also, don’t forget to track your progress using this Workout Wednesday form.

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.

Solution

 

Requirements – Intermediate

• Dashboard size: 900 x 600
• Dashboard is filtered for orders in 2018.
• You may use up to 3 sheets — no transparent sheets.
• Create a KPI table of Sales, Profit, Profit Ratio and Quantity:
  • Table is filtered for a user selected region
  • Rows appear shaded for sub-categories where the filtered region contributes greater than a user-defined value for % of total sales
  • Row shading must remain when dashboard is filtered for subset of subcategories
• Create a stacked bar chart that highlights the percentage of total sales coming from the selected region
• Color the sales related to region selected — the remaining sales should be outlined
• The title updates dynamically for region and percentage threshold.

 

Challenge – Advanced

Click image to view on Tableau Public

Requirements – Advanced

Same rules as above, plus…

• KPI Table:
• Rows appear shaded and bold for sub-categories where the filtered region contributes greater than a user-defined value for % of total sales
• Stacked Bar Chart:
• Labels are on the inner edge and the labels may not be manually positioned
• The entire dashboard should appear as one worksheet with no gaps in row dividers.

   

Dataset

This week uses the superstore dataset for Tableau 2019.1. You can get it here at data.world

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @CoreyJ34, @AnnUJackson, @LukeStanke, @lorna_eden, and @curtisharris_!

Track your progress

Also, don’t forget to track your progress using this Workout Wednesday form.

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.

Solution