What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Get the average of selected sub-fields in an Input Table field

    Asked by Brother2Brother on July 04, 2017 at 04:33 PM

    Hi, I am having difficulty with the form calculation for a satisfaction survey where V. Satisfied=4, Satisfied=3, Neutral=0, Dissatisfied=2 and V. Dissatisfied=1. Also, what would be the best way to display this data (i.e., pie, chart, etc) I'd like to see the number of responses for each question.

    Please help. Thanks.



    This is a re-post of a comment on Form Calculation - Math Function Reference

  • Profile Image
    JotForm Support

    Answered by BDAVID on July 04, 2017 at 06:01 PM

    You simply need to create a Visual Report: https://www.jotform.com/help/187-How-to-Create-a-Visual-Report-with-Your-Form-Submissions 

    For the calculation, you need to assign the values to each option, please check this guide: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value 

    Then perform the calculations: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget 

    Let us know if you need more help.

  • Profile Image

    Answered by Brother2Brother on July 09, 2017 at 09:37 AM

    Hi BDAVID,

    I've added the calculation block to my form but it is not adding up correctly.  Not sure what I'm doing incorrectly.  Also it shows the person who completes the form the calculations as well.  Is it supposed to do that?  I want the report to show me the number of satisfied for all the respondents, the number of very satisfied, etc.  Will it do that or do I have to download all the calculations and add them manually?

     

    Very Satisfied=5, Satisfied=4,  Neutral=3, Dissatisfied=2 and Very Dissatisfied=1

    I have 2 rating questionnaires.  I am sharing just 1 with you.  I am also sharing the calculations page as well.  

  • Profile Image
    JotForm Support

    Answered by Mike_G on July 09, 2017 at 11:19 AM

    If I'm understanding your concern correctly, I believe what you need is the instructions in this guide — How-to-Perform-Form-Calculation-in-the-Matrix-Field

    I see that you have already set calculation values for each sub-fields in the Input Table (Matrix field).

    However, as for getting the average, here's what you can do:

    Step 1 — add the sub-fields of the Input Table in the calculation.

    Step 2 — Move the cursor the at the beginning and add the avg () math function.

    Step 3 — Move the closing round bracket of the avg () after the last sub-field of the Input Table.

    Step 4 — Separate each sub-field with a comma and save the calculation widget.

    Note: Commas are typed manually.

    Outcome:

    I hope this helps. If you have other questions or concerns, please feel free to contact us again anytime.