#WOW2024 Week 15: Can you create a (super) dynamic trellis chart?


Continuing with our community month, I decided to invite the OG himself back for a challenge, Andy Kriebel. All I’m going to say about this challenge is, I’m sorry if it’s super hard and don’t be afraid to sneak a peak into the actual workbook to get insight into how Andy’s mind works!


  • 1200×700
  • # of sheets – up to you
  • NO LODs
  • Sort the bands alphabetically
  • Clicking on a point in the trellis automatically deselects
  • Include an option to pick a metric
    • This must also deselect
    • Colour should change to the show which metric is selected
  • Include an option to change the # of months for the moving average
    •  Lines should adjust accordingly 
  • 1 parameter max
  • Match the tooltips
  • Grey line = prior year
  • Coloured line = latest year
  • Lines are coloured by the year over year change
    • Coloured lined must be in front of the grey line
  • Include BANS on the lower left of each block
    • The big number is the total (or average) for the latest year
    • You can only have one field for the big number, but it must be display values differently depending on the metric. e.g., engagement rate is a %
    • The % under the BAN is the YoY change and should match the colour of the line
  • The dashboard title should adjust according to which metric is selected and the number of month selected
  • You will need to do some data preparation due to the structure of the data
  • Likely to need to use the function Last()


This challenge uses a custom fabricated data set 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