Select Page

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:

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

END

(2)  Y:

IF MAX([Path])=1

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

END

Modify Y:

IF MAX([Path])=1

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

END

Modify Y:

IF MAX([Path])=1