What is a doughnut chart?
Doughnut charts add an interesting feature to any dashboard design. Essentially doughnut charts allow high-level analysis or overview of data dimensions and their members’ contributions as a whole. And the centre of the doughnut allows top-level aggregation of the underlying pie chart. However, they aren’t in built-in tableau, so you will need to create them manually. Fortunately, it isn’t difficult to do, you will just need a lot of practice.

When to use Donut Charts?
-an overview of % or share of total
-minimal dimensions
-When you want to show Big Numbers

When to avoid Donut Charts?
-% or Share of total does not equate to 100%
-When there are many members in the group
-Does the data presented contribute to the overall dashboard

Step 1: Create Dummy Variables
In the column pane, sim
ply type “1” twice and it will automatically create SUM(1).

Step 2: In the marks pane, change to “All” into a pie chart.
This will now turn the bar charts into two circles.



Step 3: Allow dual axis for the dummy variables.
Right-click on the 2nd SUM(1) and select dual axis. This will then transpose the two pie charts into a single chart.

 


Step 4: Change the 2nd SUM(1) into a circle
This will allow the rings to be made. By changing the size, we can now customise the ring size. 

Step 5: Add measures values into the chart.
For our example, we have used the number of orders and a calculation that looks at the inverse. You will need to place them in the 1st SUM(1) under the angle.

Step 6: Add in a dimension for the charts to be analysed.
Right now, the pie charts will be 100% allocated to count orders as there are no dimensions. So for my example, I’ve added Regions into columns. 

Before regions were added.

After regions were added.

Step 7: Format Accordingly
Right now we would have made the basis of the doughnut charts. We can further format these charts, by removing the headers, touching up the tooltips and adding detail to the charts. To add in details in the centre of the doughnut, place CNT(Orders) and Region in the 2nd SUM(1) as labels.

 

Anthony Wong
Author: Anthony Wong