Select Page

Do you think of visualizing calendar dates in a circular view? If not, I will show you how to make a Calendar Circle Chart achieve it. The approach is to make all the dates in a year in seven-layer circles with the dates grouped by months.

I will demonstrate it by using the default Sample Super Store data set in Tableau. Let’s open the data set and start to make it.

Step 1: Create two control parameters, the first parameter is called “Depth”  and a second parameter named “Distance”(Both Integer Type); The “Depth” indicate how may layer do you have.

Step2: Create the following calculated fields

(1) Index:
INDEX()-1

(2)  TC_Date Item:
INT([Index]/[Depth])

(3)  X:

(4)  Y:

Step3: Drag Order Date into Filters and also drag Region and X into  the column, take Y in row and Order Date in detail as below figure show

Step 4: right-click X and Y to enable table calculation and computing using “ Order date”

Step 5: Now, as you can see, it is almost there, it looks stack together; Let fix it by creating a  calculated field Spacing(360/53) and  modify the X and Y to give this additional space between the circle point by multiply Spacing

```Spacing:
360/53
Modify X:

Modify Y:

Step 6: Create a distance calculation as each circle point has 7 points indicates the days in a specific week. We want them to be pushed out away from the center.

```TC_Distance:
([Index]%[Depth])+[Distance]```

Step 7: Let modify X, Y  again by multiply TC_Distance

```Modify X:

Modify Y:
```Tableau link: