In this blog, I am going to show you how to make the radial column chart and demonstrate this using the sample Super Store data set

**Data Densification**

Data densification is a way to increase the number of observations in the dataset. For example, you need to perform data densification if you want to show any curved path, like flight paths on a map, Sankey diagrams, radial charts, etc. In this blog, I will create a densification table and link it back to the orders table by the relationship to achieve data densification. The data model setup as below:

**Making the Radial Column Chart**

**Step 1**: Create three calculated fields named “ Order Date(Month)” and “Order Date(Year) and Index.

(1) Order Date(Month):

DATETRUNC(‘month’,[Order Date])

(2) Order Date(Year):

YEAR([Order Date])

(3)Index:

INDEX()-1

**Step2**: Create the following calculated fields

(1) X:

IF MAX([Path])=1

THEN SIN(RADIANS([Index]))

ELSE SIN(RADIANS([Index]))*2

END

(2) Y:

IF MAX([Path])=1

THEN COS(RADIANS([Index]))

ELSE COS(RADIANS([Index]))*2

END

(3) TC_Year

WINDOW_MAX(MAX([Order Date(Year)]))

**Step3**: I’ll drag X into the column and take Y in the row after creating the above-calculated field. Also, add Order Date(Month) into the detail mask, and make sure that Order Date(Month) is in a discreet place

**Step 4**: Change the chart to a line chart and drag the Path field into the Path mask. As you can see, a line has been drawn based on the position. Right-click on X and Y, then go to “Compute Using” and select Date of “Order (Month)”

**Step 5**: Now, I will drag the TC_Year into the Color mask, and you can see the basis of the data visualization

** **

**Step 6**: I will apply the sales data to the visualization by constructing the following calculated fields:

(1)TC_Sales:

WINDOW_SUM(SUM([Sales]))

(2)TC_Total Sales:

WINDOW_SUM(SUM([Sales]))

(3)TC_Total Sales:

WINDOW_SUM(SUM([Sales]))

** **

**Step 7**: Let’s modify X, Y again by multiplying TC_Distance

Modify X:

IF MAX([Path])=1

THEN SIN(RADIANS([Index]))

ELSE SIN(RADIANS([Index]))* (1+[TC_Distance])

END

Modify Y:

IF MAX([Path])=1

THEN COS(RADIANS([Index]))

ELSE COS(RADIANS([Index]))* (1+[TC_Distance])

END

**Step8: **To plot the sales data in the chart, I need to make the following changes to the X and Y table calculations:

**Step9:** The final step is to add space between the lines to make up the whole circle. Then, I’ll make a calculated field called “TC Space” and modify the X and Y values again.

TC_Space:

(360-(360/WINDOW_MAX([Index])))/WINDOW_MAX([Index])

Modify X:

IF MAX([Path])=1

THEN SIN(RADIANS([Index] *[TC_Space]))

ELSE SIN(RADIANS([Index] *[TC_Space]))*(1+[TC_Distance])

END

Modify Y:

IF MAX([Path])=1

THEN COS(RADIANS([Index] *[TC_Space]))

ELSE COS(RADIANS([Index] *[TC_Space]))*(1+[TC_Distance])

END

Ok, you’ve now learned how to create a radial column chart. I hope you can make your own by following the above steps.

Tableau Public link: