#WOW2024 | Week 24 | Can you visualise headcount distribution in multiple ways on a single sheet?


For this week’s challenge I want to see if you can provide users with the flexibility to choose how they want to display a particular metric – in this case we’re looking at Headcount data, and how it is distributed across different employee attributes. Depending on the question being asked, a particular layout might provide a better answer.


  • Dashboard 1000 x 600
  • Allow users to select a different chart type from one of Butterfly Chart, Stacked Bar Chart or Side by Side Bar Chart
  • Allow users to select which attribute to breakdown for each row – Age Bracket, Contract Type, Department, Gender, Nationality
    • Contract Type is either Full Time or Part Time. An employee is a full time employee if their FTE (full time equivalent) value is 1
    • Age Brackets are Under 20, 20-29, 30-39, 40-49, 50-50 and Over 60.
    • Age should be calculated in whole years based on the employee’s Birth Date and ‘Today’.
    • For the purposes of this viz (and the data provided), assume ‘Today’ is 01 Dec 2022, so be mindful of how old someone, whose birthday is in December, should be.
  • Allow users to select which attribute to split each row by – Gender or Contract Type or neither
  • Display both actual headcount and % of total (for the row)
  • When displaying a butterfly chart ensure Females / Part Time is displayed on the left side of both charts.
  • Match the positioning of the labels.
  • Match tooltips.
  • Colour as you choose – I used #358ead and #a1d5d2


This challenge uses a custom fabricated data set extended from the HR data available from the Real World Fake Data initiative (#RWFD), and is available from 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



Scroll to Top