VizWiz

Launch, grow, and unlock your career in data

March 15, 2017

Workout Wednesday: Full Year Calendar with Month Labels

18 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!

18 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
    Replies
    1. This comment has been removed by the author.

      Delete
  6. I am impressed by this calendar. However, I see a few errors, say for example: I don't find Jan 1st and 2nd of 2011 and Jan, Apr, July stop at 29th in 2016. Why is this happening?

    ReplyDelete
    Replies
    1. It's only showing weekdays because the stock market isn't open on weekends.

      Delete
  7. Thanks for sharing this informative video. I'm relatively new to the software and encountering a problem when developing my own heatmap... I have one created, but when adding a Measure to the Text Mark, with a Measure for Color already established, the chart/calendar then shows a white cell for each of the days with the color scale applied to the text instead of the filled color for each cell. Is there any way to keep the heatmapping or color representation within the cell and just listing the date in plain text? Does any of that make sense?

    Any guidance/troubleshooting would be appreciated! Thanks again.

    ReplyDelete
    Replies
    1. Make the mark a square. If that doesn't work, make it a Gantt bar and put AVG([Number of Records]) on the size shelf.

      Delete
  8. I would like to know if there is a way that I can alter the column number calculated field to display all twelve months across the same row? instead of 3x4?

    ReplyDelete
    Replies
    1. Sure. Instead of using SIZE(), you can probably just enter the number.

      Delete