LEARN TABLEAU TOOL

How to create “Donut chart”.

Donut charts offer a quick, high-level view of data dimensions that have few members, and together, contribute to a whole. Essentially, it's a pie chart with a hole. It is quick and informative. The extra level introduced by the donut hole allows for a top-level aggregation of the members of the underlying pie chart.

Here donut charts representing the percentage of top customers by profit across product categories.

Step 1: First we need to configure a connection to source data.

Step 2: Create a Calculated field “zero” with value 0.

Step 3: Create a calculated fieldname as“% of Profit Top customers” “Top customers by Profit” Sets is used with measure “Profit”.

Step 4: Drag the dimension “Category” and measure “zero” (calculated field we just created) to the column shelf.

Step 5: Drag “Top customers by Profit” sets as COLOR mark and select “PIE chart” under the drop down.

Step 6: Drag SUM (Profit) in the angle marks.

Step 7: Drag “zero” measure (calculated field) to the column shelf

again to the column shelf.

Step 8: Remove all the marks from the SUM (Zero) (2) Marks selection.

Step 9: Reduce the size of the marks in SUM (Zero) (2).

Step10: Add “% of Profit top customers” as label.

Step 11: Right Click on the second Sum(zero)(2) and select dual axis.

Step 12: Format the colors accordingly and remove the headers.

Donut chart