Jump to content

Pie Chart using Customer feedback


Recommended Posts

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?

Screenshot 2020-09-15 at 08.48.35.png

Link to post
Share on other sites

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.

 

Link to post
Share on other sites

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!

Link to post
Share on other sites
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.

 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.