Toan Hoang

Tableau QT: Calendar Table

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.

If all goes well, you should see the following:

Now, we will adjust the cosmetics:

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.

If you like our work, do consider supporting us on Patreon, and for supporting us, we will give you early access to tutorials, exclusive videos, as well as access to current and future courses on Udemy:

Also, do be sure to check out our various courses:

Exit mobile version