Is there a count function (of number of responses in a submission)?

  • jhadley999
    Asked on July 26, 2019 at 3:19 PM

    I wish to calculate the average of all coded responses (all are either -1, 0 or 1).

    Because the total number of responses will vary between respondents, is there a function of the number of responses for a given submission (to use as the denominator in the calculation)?

    Jeff

  • jhadley999
    Replied on July 26, 2019 at 3:24 PM

    Hmmm, never mind... adding up all in this situation will give me the mean.

    For future reference, or I change scoring, still interested in an answer to question anyway.

  • David JotForm Support Manager
    Replied on July 26, 2019 at 4:37 PM

    So, you want to create like a report that that tells you how many times an option has been selected? That is possible through the Visual Report, please check this guide: https://www.jotform.com/help/187-How-to-Create-a-Visual-Report-with-Your-Form-Submissions

    Let us know if you need more help.

  • jhadley999
    Replied on July 29, 2019 at 12:23 PM

    That is not what I was asking about.

    Is there a function that counts the number of questions answered... so have a denominator to calculate the mean of all responses... in a form calculation field?

    That number will vary from one person to the next, thus the challenge.

  • David JotForm Support Manager
    Replied on July 29, 2019 at 1:38 PM

    So, you would like to know how many questions were answered in a submission? In other words, to add up all the filled questions, then divide by how many fields there are in the form?

    I assume that you would like to apply that on this form: https://www.jotform.us/form/90828484648169, since it has conditions to show or hide specific questions, so not all of the questions will be answered.

    If that is what you want, unfortunately, we don't have a specific option for that. The only way would be through conditions and the Form Calculation widget. You would need to:

    1) Add a Form Calculation widget below each question, and hide it through its properties.

    2) Then create a condition for each field, where it will insert 1 as a value into the corresponding calculation field if the field in question is filled: https://www.jotform.com/help/268-How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic

    3) Finally, you will need to add up all these Form Calculations widget into another one, to calculate the mean: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    Hope this helps.

  • jhadley999
    Replied on August 2, 2019 at 2:30 PM

    Thanks, that was my work around plan.