 I love drawing data visualisations with Tableau and in this tutorial, we are going to build Radial Bar Chart. For my data set, I am going to use the #MakeoverMonday’s American Biggest Bandwidth Hogs data set.

Note: This information can be displayed using Bar Charts and many would argue that it would be more efficient, but let us put that aside for a moment and use this as an opportunity to explore how this can be done.

## Calculated Fields

With our data set loaded into Tableau, we are going to create the following Calculated Fields and Bins:

Path (bin)

• Right click on Path, go to Create and select Bins…
• In the Edit Bins dialogue window:
• Set New field name to Path (bin)
• Set Size of bins to 1
• Click Ok

Note: The Path (bin) will allow us to use a table calculation to create additional data points between 1 and 270.

Index

`INDEX()-1`

TC_Value

`WINDOW_MAX(SUM([Value]))`

TC_Max Value

`WINDOW_MAX(SUM([Value]))`

TC_Step Size

`[TC_Value]/[TC_Max Value]`

TC_Rank

`RANK_UNIQUE([TC_Value],'asc')`

X

`SIN([Index]*PI()/180*[TC_Step Size])*[TC_Rank]`

Let us spend a little time here explaining how we are using our other Calculated Fields:

• Using our Path (Bins) we are going to use densification to get additional points
• We need to convert percentages to Radians by multiplying by PI() and then dividing by 180.

Y

`COS([Index]*PI()/180*[TC_Step Size])*[TC_Rank]`

So now that we have created a lot of Calculated fields, we will now put this together into a Worksheet.

## Worksheet

We will now build our worksheet:

• Drag Name onto the Color Mark
• Drag Path (Bin) onto the Columns
• Right click on Path (Bin) and check Show Missing Values
• Drag Path (Bin) onto the Detail Mark
• Change the Mark Type to Line
• Drag X onto Rows
• Right click on X, go to Compute Using, select Path (Bin)
• Drag Y onto Columns
• Right click on Y, go to Compute Using, select Path (Bin)

You should see the following:

We will now edit the calculated fields to complete the Visualisation:

• Right click on X and select Edit Table Calculations
• In Nested Calculation select TC_Max Value
• Click on Specific Dimensions and select Path (Bin) and Name
• Ensure Name is on top
• In Nested Calculation select TC_Rank
• Click on Specific Dimensions and select Path (Bin) and Name
• Ensure Name is on top
• In At the Level select Name
• Right click on Y and select Edit Table Calculations
• In Nested Calculation select TC_Max Value
• Click on Specific Dimensions and select Path (Bin) and Name
• Ensure Name is on top
• In Nested Calculation select TC_Rank
• Click on Specific Dimensions and select Path (Bin) and Name
• Ensure Name is on top
• In At the Level select Name

You should now see the following visualisation:

We will now do the following to get the look that we require:

• Remove all Grid Lines
• Drag Name onto Label
• Drag TC_Value onto Label
• Click on Label, select Line Ends and untick Label end of line
• End the Label Text
• Edit the colors
• Edit the Tooltips
• Increase the size of the lines

After which you should have the following:

and boom, we are done, nice quick and easy…