Donut in Tableau
Donut chart is not an out of the box visualization in Tableau. Actually, it does not the stringent specification for Tableau data visualization philosophy. However, it is similar to pie chart which divides the a circle in different sectors based on the value of their proportions. But, the difference between Pie and Doughnut chart is that in a doughnut chart there can be more than one data series added as rings to the chart. Learn Tableau A-Z for Data Science.
This blog will detail how to make a donut chart in Tableau using Sample-Superstore data.
To create a donut chart, we first need to know the dimension on which we want to segregate and measure to define the proportion. So, in this case the “Category” can be used as the dimension and “Sales” as the measure.
Following are the steps to create a doughnut chart in Tableau:
1. Connect to Sample-Superstore dataset: Open the Tableau Desktop and select the “Sample-Superstore” dataset
2. Go to Sheet1:
3. In the “Marks” card, select chart type as pie
4. Drag the “Category” field to “Color” and “Sales” measure to “Size” & “Label” marks card
5. Now, drag the “Number of Records” to “Rows” shelf
6. Select the “Number of Records” field in “Rows” shelf and change the default aggregation from “Sum” to “Minimum”
7. Again, drag the “Number of Records” from the measures and put it on “Rows” shelf on right after the 1st “Number of Records”
8. Change the default aggregation from “Sum” to “Minimum” for 2nd copy of “Number of Records” also
9. Do a right-click on 2nd copy of “Number of Records” field and select “Dual Axis” option
10. In the next step, select the “Min(Number of Records) (2)” in “Marks” card and remove the following:
– “Category” from “Color”
– “Sales” from “Size” and “Label”
11. Again, select the “Min(Number of Records) (2)” in “Marks” card, reduce the size of the pie chart and then select the color of the pie chart same as the background color (“white” color in this case)
12. In the last step, do a right-click on each of the axis and de-select “Show-Header”
13. This is how the donut chart will look like.