Week 1: Can you sort dimensions with a single click?

Introduction

We’re back in 2020 with a whole new set of challenges. This month you’ll see challenges from Lorna, Ann, Sean, and myself. I’m starting this year off with a bar chart/data table because in our day-to-day we are always looking for a way to spice up our charts. 

To spice up these charts we will work on sorting. We’d normally include a header or footer to sort on but because we have a table with bars and text we might find ourselves hiding the axes and labels. Plus this one includes specific practice we should all learn. You’ll likely need a newer version of Tableau: 2019.3 or newer. 

Challenge

Requirements

  • Two sheets
  • Dashboard Size: 700px-by-900px
  • Create a sheet that acts as a header that allows you sort the table below.
    • This should be 50 px tall.
    • The selected sort column should be a color of #1B1B1B.
    • Text that is not selected should be #6E6E6E
    • Place the text center middle.
    • When a sort column is selected make sure an arrow shows below
  • Create a sheet that acts as a table. This table should:
    • Turn off sort controls.
    • Include text for a Sales per order metric that is right-aligned with the header text. This will require some custom formatting.
    • Include a bar chart for profit ratio.
    • Color the bars Ruby Red (#D81159) if the sub-category has a profit ratio that is negative and gray if it is positive.
    • Include a zero line for the profit ratio bars but not for sales.
    • Use Tableau Light, Size 10 with a color of #1B1B1B
  • Include padding of 50px to the left and right.
  • Include a 4px red band above the table that is the same Ruby Red color.
  • Set the dashboard color to #FFFFFF.
  • Set the table color to #EBEBEB.
  •  No Tooltips.
  • Match all other formatting.

Dataset

This week uses the superstore dataset for Tableau 2019.1. 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 #WOW2020 in your description to make it searchable!

Share

After you finish your workout, share on Twitter using the hashtag #WOW2020 and tag @AnnUJackson@LukeStanke, and @lorna_eden.

Solution

3 thoughts on “Week 1: Can you sort dimensions with a single click?”

  1. could you edit the video or provide detailed directions on how you created the sort parameter? I am spending a lot of time on it and can’t figure it out.

Leave a Comment

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

Scroll to Top