Pie chart

[#1]

Hi, I want to create a pie chart which gives me the percentage wise analysis of the various reasons . How to create that?

[#2]

please tell how to calculate the percentage of the count of the reasons

[#3 · Accepted solution]

When you have one dimension with the various reasons and one expression to count the reasons, you can check the "relative" checkbox on the right of the expression. This will give you the % of each reason from the total of all reasons.

Sample without the box checked

Same sample with box checked

[wimzjeraar]

Create a chart - choose type Pie Chart

Dimension: Reason
Expression: count (Reason) - check the 'relative' checkbox for this expression
In Tab Number: choose fixed to (number of decimals you want to see) decimals and check the "show in percent (%) checkbox.

That should do the trick

[#5]

Thanx a lot, it works