3 Replies Latest reply on Dec 20, 2016 9:57 AM by gartmorris

    Help with grade distribution chart


      I have a table with the following fields:











      The table contained roughly 49000 records (each student has 6 classes/grades).  I am attempting to create a chart that would show the letter grade (A,B, C, D, F) distribution (percentage and total number) based on the found records.  I have tried several things and end up with a pie chart showing equal distribution.  I can't imagine this is that complicated but I am obviously missing something.  I am well versed with Filemaker but new to the charting aspect.  Ideas?  Thanks in advanced.

        • 1. Re: Help with grade distribution chart

          Simplest way would be to use a found set with a summary field (absolute number in group) and a calculation (absolute number in group / absolute number total)**; then you can draw the values to chart using the Data Source option "Current Found Set: Summarized groups of records".


          Don't forget that for the summary field (and your chart) to work, you must sort your records by grade.


          Which several things have you tried so far?


          **EDIT: the Chart tool can display percentages as an option, so there's no extra field required.

          • 2. Re: Help with grade distribution chart

            And here's a very basic sample file attached.


            Screen Shot 2016-12-20 at 18.22.19.png


            Note that if you only want to display the chart, you don't need a body or sub-summary part; the layout doesn't even have to be in List view.


            The only things you really need are a summary field and a sorted found set (and the correct Data Source setting in the Chart tool).

            1 of 1 people found this helpful
            • 3. Re: Help with grade distribution chart

              That worked but I am not sure why mine didn't as I did exactly that with the summary field.  I will go back and see where I broke down.  Anyways thank you for the clarification and the file.  Much appreciated.