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

    Help with grade distribution chart

    gartmorris

      I have a table with the following fields:

      IDnum

      coursename

      coursedept

      teachername

      studentname

      gender

      ethnicity

      level

      Lettergrade

       

      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
          erolst

          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
            erolst

            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
              gartmorris

              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.