Tableau QT: Rounded Doughnut Chart

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

Note: we require path and duplicate lines for densification. See our tutorial on Data Densification for more information. Click here

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 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 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 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:

Now adjust the visuals cosmetics:

• 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.
• Hide all Column Headers.
• Update the Tooltip.
• Adjust the Size.
• 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.

If you like our work, do consider supporting us on Patreon, and for supporting us, we will give you early access to tutorials, exclusive videos, as well as access to current and future courses on Udemy:

• Patreon: https://www.patreon.com/tableaumagic

Also, do be sure to check out our various courses:

• Creating Bespoke Data Visualizations (Udemy)
• Introduction to Tableau (Online Instructor-Led)
• Advanced Calculations (Online Instructor-Led)
• Creating Bespoke Data Visualizations (Online Instructor-Led)