Chrism 0 Posted September 15, 2020 Share Posted September 15, 2020 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? Link to post Share on other sites
comment 1,777 Posted September 15, 2020 Share Posted September 15, 2020 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
Chrism 0 Posted September 15, 2020 Author Share Posted September 15, 2020 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
comment 1,777 Posted September 15, 2020 Share Posted September 15, 2020 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
Chrism 0 Posted September 16, 2020 Author Share Posted September 16, 2020 ok thank you, think I can do what i need with a global drop down search / sort script field, thank you Link to post Share on other sites
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now