AnsweredAssumed Answered

Create Pie Chart from Case function Data Field

Question asked by andrewclaiborne on Jun 12, 2016
Latest reply on Jun 14, 2016 by andrewclaiborne

I have a field that looks up the values of students marks using the Case function which returns a value, A, B, C, or F. The field is called 'Total Grade Sem1 Lookup'.


What I want to do is create a pie chart with the the labels of A, B, C, or F with the pie chart indicating those students that have an A, B etc. as a percentage.  Unfortunately, when I create the chart, it shows all the students individually, e.g. if there are 25 students, it indicates 25 equal slices and the label repeats the grades of As, Bs etc. to the total number of students.


I have tried the tick box in Data Source, 'summarized groups of records' and 'individual record groups', but this does not alter the pie chart.


I am using FileMaker Pro Advanced, versions 12, 14 & 15.


Can anyone assist?


Thank you