Tuesday 12 May 2015

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