#WOW2022 | Week 35 | Conditional Table Formatting with Dynamic Headers

Introduction

This week’s challenge is brought to you by a guest coach, my colleague Valerija Kirjackaja, who came across this problem at work and created a beautiful solution for it.

How often do you get asked to re-create Excel tables in Tableau? On a scale from 1 to ‘I am never doing this again’ – how frustrated do you get when it comes to formatting?  This challenge does not necessarily offer an easy workaround but should hopefully be useful for the next time you have to build a conditionally-formatted MoM table for your Finance department.

This week’s task is to create a table showing the last three months of Sales/Profit/Avg. Days to Ship values and evaluate the change in the latest month compared to the previous one. 

Requirements

·         Dashboard Size: 1000 x 600 px

·         1 Sheet

·         User should be able to select the Latest Month they want to see from the dropdown (make sure months in the dropdown are sorted with most recent on the top).

·         Table headers should update dynamically based on the selected latest month.

·         User should be able to choose from 3 metrics: Sales, Profit, or Average Days to Ship

·         Colour Latest Month Growth column: blue (#a3cce9) if we did better in the latest month than in the previous month, orange if we did worse (#ffbc79). Note that unlike for Sales and Profit, for Average Days to Ship change is ‘better’ if the numbers decrease.

·         Show values with no decimal points in the table but include 2 decimal point in the tooltips.

·         Match the formatting.

Dataset

This week uses Sample Superstore 2021 data. You can find it here on 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 #WOW2022 in your description to make it searchable!

Share

After you finish your workout, share on Twitter using the hashtag #WOW2022 and tag @LukeStanke, @_Lorna_Brown, @HipsterVizNinja, @_hughej, and @YetterDataViz

Solution

Interactive

1 thought on “#WOW2022 | Week 35 | Conditional Table Formatting with Dynamic Headers”

Comments are closed.

Scroll to Top