Can u create a average from 1-10 scale in a matrix? Would like to display average score to compare schools

  • dmelton49
    Asked on March 4, 2016 at 5:02 PM
  • Chriistian Jotform Support
    Replied on March 4, 2016 at 10:25 PM

    You can add a Form Calculation widget to average the matrix on a scale of 1 to 10 for each school. 

    http://widgets.jotform.com/widget/calculation

    1. Add the calculation widget

    Can u create a average from 1 10 scale in a matrix?  Would like to display average score to compare schools  Image 1 Screenshot 80

    2. Click the Add Field button and select one of the matrix fields.

    Can u create a average from 1 10 scale in a matrix?  Would like to display average score to compare schools  Image 2 Screenshot 91

    3. Check all the fields that you want to average.

    Can u create a average from 1 10 scale in a matrix?  Would like to display average score to compare schools  Image 3 Screenshot 102

    4. Then click the ... button and select avg()

    Can u create a average from 1 10 scale in a matrix?  Would like to display average score to compare schools  Image 4 Screenshot 113

    Can u create a average from 1 10 scale in a matrix?  Would like to display average score to compare schools  Image 5 Screenshot 124

    4. Modify the formula so that the calculation should look like this after. Click Finish to save.

    Can u create a average from 1 10 scale in a matrix?  Would like to display average score to compare schools  Image 6 Screenshot 135

    5. Do the same to the rest of the fields and this is how the result would appear.

    Can u create a average from 1 10 scale in a matrix?  Would like to display average score to compare schools  Image 7 Screenshot 146

    Here's a demo so you can see it in action: https://form.jotform.com/60638847256971

    To clone the form to your account, simply follow this guide: How to Clone an Existing Form from a URL

  • dmelton49
    Replied on March 5, 2016 at 2:45 PM


    Very nice thank you. Widget is an effective tool.
    Sent from my Verizon Wireless 4G LTE smartphone
    ...