#WorkoutWednesday week 32: Continuous Dates are Tricky

Working with continuous dates can be tricky in Tableau depending on how you want to display them. This weeks #WorkoutWednesday is inspired by a challenge from Data School superstar Neil Lord.

For this weeks #WorkoutWednesday challenge you'll need to:
  • Show a running total of sales at a daily level, but split by year of order date
  • Each line for each year should be a different colour. The latest year in the data set should be dark, but the previous years should be transparent. (Note that there is a way to do this without creating a custom palette in Tableau)
  • Make sure your title matches mine. (If I were to add sales data for 2016 my title would also auto update)
  • Make sure your tooltips match
  • Make sure all your axis labels match too
You'll also need to download the data so your results match mine.

Remember, once you've completed the challenge to tweet a picture of your final result to @EmmaWhyte and @VizWizBI

Good luck!



  1. Great challenge Emma and indeed tricky stuff with those continous dates and handling the leap year. 29 Feb 2012 just does not display that easily.
    I ended up using a beautiful solution offered by Kettan (BTW thanks to Andy for pointing in the right direction):
    DATE(DATEADD('year', 2000 - YEAR([Order Date]), [Order Date]))

    Unfortunately, I cannot figure out how to get the date axis to eliminate the second 'January' - so it would be interesting to hear if anyone has a good take on that. Can see you guys have the same issue...

    My version:

  2. I came close, but not sure how exactly you added the transparency (light colors) to the lines and legend. I used the eyedropper in my workbook to take the colors off of yours on public.



to top