This is a Quick Tip on how to build Calendar Table in Tableau, so less reading and more jumping in. We are going to spend 5 minutes or less building our Calendar Table in Tableau.

Data

Let us start by loading Orders from the Superstore data set, if you have Tableau Public you can download the dataset here:

Calculations

We only require a single Calculated Field:

Week of Month

DATEPART('week', [Order Date]) - DATEPART('week',DATETRUNC('month',[Order Date]))

Worksheet

Now that we have created our Calculated Field, we will build our Worksheet.

  • Drag Order Date onto Columns.
    • Right-click on this object and select Discrete Month.
  • Drag Order Date onto Columns.
    • Right-click on this object and select Discrete Weekday.
  • Drag Order Date onto Rows.
    • Right-click on this object and select Discrete Year.
  • Drag Week of Month onto Rows.

If all goes well, you should see the following:

Now, we will adjust the cosmetics:

  • Change the Mark Type to Square.
  • Drag Sales onto Colour.
  • Hide the Week of Month Header.
  • Hide the Field Label for Rows.
  • Right-click on Year and select Rotate Label.
  • Hide the Weekday Header.
  • Adjust the Tooltips.

You should now have the following:

and boom, we are done. We have created a Calendar Tableau in Tableau. You can find my data visualisation Tableau Public at https://public.tableau.com/profile/toan.hoang#!/vizhome/CalendarTable/CalendarTable

Summary

I hope you all enjoyed this article as much as I enjoyed writing it. Do let me know if you experienced any issues recreating this Visualisation, and as always, please leave a comment below or reach out to me on Twitter @Tableau_Magic.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.