4 Replies Latest reply on Jul 11, 2018 6:52 PM by ArseneXie

    Educational Brain Teaser: Create Calendar with Minimum Data

    Alexander Mou

      Just find Michael Hesser posted a brain teaser not so long ago.

      Here is another one from me.

       

      How minimum? Here it means 2 rows of date (the first and last dates of the year)

      2018-04-06 14_10_07-Microsoft Excel - Tableau Best Practices.xlsx.png

      Then create this yearly calendar of 2018. Note that the view is 4x3:

      • Jan, Feb, Mar, Apr
      • May, Jun, Jul, Aug
      • Sept, Oct, Nov, Dec

      Cal_2018.png

      Optional with public holidays (data in extra table that you need to create by yourself)

      Cal_w_Holidays.png

      I also wrote a post:

      Vizible Difference: #TableauBrainTeaser: Creating Calendar with Minimum Data

      And post it on twitter:

      https://twitter.com/aleksoft/status/982405669612498944

       

      The actual viz is here: (not downloadable)

      Workbook: Calendar with Minimum Data

       

      Have fun!