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.
- 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.
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!