#WOW2024 | Week 16 | Can you create a sales dashboard by effectively utilizing headers?


This week’s challenge comes from Chasoso (Hideaki Yamamoto), who is an active participant in WorkoutWednesday and was the runner-up in last year’s Viz contest at the Japan Tableau User Group (JTUG) annual meeting.

# Introduction(EN)
I’m very happy to join Workout Wednesday as a guest coach.
Because I’ve been encountering interesting vizzes every week, I admire the coaches who create these visses.
So, I’ve done my best to create an interesting challenge that is no less worthy of such a fantastic team of coaches.

This week’s challenge is a sales dashboard.
If you have created dashboards as a part of your job, you may frequently see dashboards like this.
However, I thought up an idea to make the dashboard more interactive, smarter, cooler and cuter.

While I have seen various dashboards, both business-related and otherwise, I’ve noticed a lack of effective utilization of headers in many of them.
So, let’s learn how to utilize Tableau’s headers to expand your range of visualization!
Have fun!

# Introduction(JP)




# Requirements(EN)
【Common to Levels 1-3】
・Dashboard size: 1200px x 700px
・1 sheet
・FY (fiscal year) starts in April and ends in March (Many Japanese companies adopt a FY starting in April)
【Level 1】
・Latest FY’s comulative sales and previous FY’s comulative sales are displayed by region in line graphs
・Latest FY’s monthly sales values by region are displayed in bar graphs
・Previous FY’s monthly sales shown as reference lines
・Match formatting & tooltips
【Level 2】
・Clicking on region name headers drills down to display subcategories for the clicked region only
・Clicking the same region name again drills back up
・The mark (circle) for the latest FY month on line graphs is displayed larger than those for other months/years
・Meets all Level 1 requirements
【Level 3】
・Can select which FY to display
・FY in sheet title also changes accordingly
・FY parameter should not be hard-coded, and the latest year should always be initially displayed
・Area below line graphs is filled with semi-transparent color
・Meets all Level 2 requirements

# Requirements(JP)
・ダッシュボードサイズ:1200px x 700px
【Level 1】
【Level 2】
・Level 1の要件をすべて満たしていること
【Level 3】
・Level 2の要件をすべて満たしていること


This week uses Superstore data set. You can download it form here.


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 #WOW2024 in your description to make it searchable!


After you finish your workout, share on Twitter and/or LinkedIn using the hashtag #WOW2024 #Tableau and tag @WorkoutWednsday and @_Chasoso




Scroll to Top