This is a Quick Tip on how to build a Rounded Doughnut Chart in Tableau, so less reading and more jumping in. We are going to spend 5 minutes or less building our Rounded Doughnut Chart in Tableau.

Note: As always never choose a data visualisation type and try to fit your data into it, instead, understand your data and choose the best visualization for your data consumers.

## Data

Load the following data into Tableau Desktop / Public.

 Category Path Value A 1 500 A 101 500 B 1 300 B 101 300 C 1 200 C 101 200

## Calculated Fields

We will start by creating the following calculated fields.

Path (bin)

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

Index

``INDEX()-1``

TC_Value

``WINDOW_MAX(MAX([Value]))``

TC_Total Value

``WINDOW_SUM(MAX([Value]))/2``

TC_Percentage

``[TC_Value]/[TC_Total Value]``

TC_Starting Point

``(RUNNING_SUM([TC_Percentage])-[TC_Percentage])*360``

X

``SIN(RADIANS((([Index]*[TC_Percentage]*3.6))+[TC_Starting Point]))``

Y

``COS(RADIANS((([Index]*[TC_Percentage]*3.6))+[TC_Starting Point]))``

Now that we have created our Calculated Fields, we will build our Worksheet.

## Worksheet

Now that we have our Calculated Fields and Bin object, let us create our Worksheet:

• Change the Mark Type to Line.
• Drag Path (bin) onto Columns.
• Right-click on the object and ensure that Show Missing Values is checked.
• Drag this object onto the Path Mark.
• Drag Category onto the Color Mark.
• Drag X onto Columns.
• Right-click on the object, go to Compute Using and select Path (Bin).
• Drax Y onto Rows.
• Right-click on the object, go to Compute Using and select Path (Bin).

If all goes well, you should see the following:

We will now add a little bit of magic by editing our Table Calculation for Y.

• Right-click on X and select Edit Table Calculations.
• In Nested Calculations select TC_Start Point.
• In Compute Using, select Specific Dimensions and ensure that Path (bin) and Category is checked.
• Ensure that Path (bin) is on top.
• In Nested Calculations select TC_Total Value.
• In Compute Using, select Specific Dimensions and ensure that Path (bin) and Category is checked.
• Ensure that Path (bin) is on top.
• Right-click on Y and select Edit Table Calculations.
• In Nested Calculations select TC_Start Point.
• In Compute Using, select Specific Dimensions and ensure that Path (bin) and Category is checked.
• Ensure that Path (bin) is on top.
• In Nested Calculations select TC_Total Value.
• In Compute Using, select Specific Dimensions and ensure that Path (bin) and Category is checked.
• Ensure that Path (bin) is on top.

If all goes well, you should now see the following:

• Set the Zero Lines to None.
• Set the Grid Lines to None.
• Set the Axis Ruler to None.
• Set the Row Divider Pane to None.
• Set the Column Divider Pane to None.
• Double click on the X-Axis and Fix the range to be from -6 to 6.
• Update the Tooltip.
• Control-Drag Y from the Rows and onto Color. Control-Drag copies the object with all settings.

You should now have the following:

and boom, yes, this has been trickier than normal Quick Tip, but hey, it is all good. You can find my Rounded Doughnut Chart on Tableau Public at https://public.tableau.com/profile/toan.hoang#!/vizhome/RoundedDoughnutCharts/RoundedDoughnutCharts

If you want to have some fun, you can drag TC_Value onto the Size Mark and adjust:

## 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.

A prolific blogger, contributor and freelancer in the Tableau community. A technology enthusiast with a passion for business intelligence, data visualizations and data management. Also, I love debating and talking tech to the early hours, so get in touch.