Data Viz Done Right

March 15, 2017

Workout Wednesday: Full Year Calendar with Month Labels

11 comments
Last week, Kevin Taylor of Tableau wrote a great blog post on the use cases and the how to for heatmap calendars. Kevin ends the blog post with this question/challenge:

I’ve still yet to come across a really good, scalable solution for adding in the month names.
Kevin sent this to me several weeks ago and I came up with this solution, which is your challenge for this week. Create a heatmap calendar that includes month names. Download the data for this challenge here. You must match everything: the titles, the colors, the fonts, the filter, all of it. The final dashboard size is 600x800.

TIP: You could start by downloading Kevin's workbook. This will give you the LOD that he used for the weeks. Good luck!

11 comments :

  1. LOVE IT! Very Elegant solution! not sure how much you want me to say on here so I'll PM my love for the way you went about it!

    ReplyDelete
    Replies
    1. Cheers Kevin! It was fun to take what you did and add to it for Workout Wednesday. Thanks for collaborating with me!!

      Delete
  2. Hi, is this workbook available on the Tableau site anywhere? My company won't allow downloads from other sites and I really 'need' this solution. Alternatively, could you explain how you got the month names in such a way? I've done a few of these calendars now (and they are getting high praise) but having the month names (without an annotation that moves when you change a filter) would be ideal?

    ReplyDelete
    Replies
    1. It's OK I found it on Tableau Public, sorry to bother you.

      Delete
    2. You can download it from Tableau Public here - http://public.tableau.com/views/HeatmapCalendars_0/After Note that I created this in 10.2.

      Delete
    3. Thanks, unfortunately we use 9.0 so I can't download :-( any chance of a 'how to'?

      Delete
  3. Sorry I forgot to say a really big thank you for the work on this guys - much appreciated!

    ReplyDelete
    Replies
    1. If you can wait until Tuesday, I'm going to do a video. Otherwise, you could always download and install Tableau Public 10.2 to open it in.

      Delete
  4. Hello Andy. I follow your page and it really helped me a lot in creating my visualization. I am new to Tableau and have a query. If you could just help me. Is there a way we can create dynamically changing axis( From year to month to week). I know how to change the view from year to month to week but the axis remains same (whatever I have pulled in the column shelf). Please assist.

    ReplyDelete
  5. Video for how to create the calendar with the months can be found here - http://www.vizwiz.com/2017/03/how-to-heatmap-calendar.html

    ReplyDelete