Showing posts with label How to create “Donut chart”.. Show all posts
Showing posts with label How to create “Donut chart”.. Show all posts

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