#WOW2022 Week 41: Can you do YoY comparisons?

Introduction

Welcome to week 2 of #WOW2022 community month! I’m excited to have Liam Huffman joining me for this week’s challenge. Liam is a fellow colleague at Evolytics and is a great member of the #datafam! With that – here’s Liam

Hey everyone! I’m excited to be here sharing my challenge dashboard. This one focuses on how to analyze performance over time for a few different questions in the same dashboard. A lot of the clients that I work with really to see previous years performance compared to the current year. Additionally, we’ve had a number of clients that want to compare weekday to weekday rather than week date to week date. And then other clients want the option. 

So that’s what this challenge is focused on. Be sure to reach out on Twitter or find me on LinkedIn if you have any questions. 

Requirements

  • 1150 x 600 Dashboard size

  • Only two sheets

  • Custom Date Range,

    • defaulted to start of this calendar year thru yesterday

  • Change date granularity between day, week, month

  • Every year of data should show stacked

    • (weekday to weekday for day/week, weekdate to weekdate for month)

  • Include directional arrows to represent positive/negative change YoY in bar chart label (↑ | ↓)

  • Hovering on a date in the trend filters the bar chart

  • Hovering on a year in the bar chart highlights the year in the trend

Dataset

This week uses Superstore 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 @LiamDoesTableau @LukeStanke, @_Lorna_Brown, @HipsterVizNinja, @_hughej, and @YetterDataViz

Solution

Interactive

Scroll to Top