Pie Chart using Customer feedback

[Chrism 0]

We have a table with lots of Customer Feedback fields

They are fixed fields and contain fixed rating items, Either Excellent, Very Good, Good etc

I would like to create a Pie chart which splits it by the Rating, and maybe shows a percentage , so 80% Excellent, 10% Very Good, 5% Good, 5% other 

Is this possible in Filemaker with the pictured data?

[comment 1,777]

To chart the responses in the Rating field, define a summary field as Count of [ Rating ] or any other field that cannot be empty. Then define the Chart to show category labels from the Ratings field and slice data from the summary field. In the Data Source tab, select 'Current Found Set' and 'Summarized groups of records'.

In the Chart tab you will find an option to show the data as percentages.

Make sure your records are sorted by the Rating field before displaying the chart.

Not sure what is the relevance of the other fields you show.

 

[Chrism 0]

Thank you.

The Other fields are rating for specific things, like support rating, response rating etc

Could I have multiple pie charts on 1 x layout of the different rating tyopes?

Thanks!

[comment 1,777]

16 minutes ago, Chrism said:

Could I have multiple pie charts on 1 x layout of the different rating tyopes?

Yes, but not as easily because you cannot apply two conflicting sorts at the same time. You would have to gather the chart data into variables, using either ExecuteSQL() or a technique like Fast Summaries by Mikhail Edoshin.

 

[Chrism 0]

ok thank you, think I can do what i need with a global drop down search / sort script field, thank you