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

Asked on July 26, 2019 at 03: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

Answered on July 26, 2019 at 03: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.

• BDAVID
Answered on July 26, 2019 at 04: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.

Answered on July 29, 2019 at 12:23 PM

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.

• BDAVID
Answered on July 29, 2019 at 01: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.