-
jhadley999Asked 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
-
jhadley999Replied 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 ManagerReplied 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.
-
jhadley999Replied 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 ManagerReplied 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.
-
jhadley999Replied on August 2, 2019 at 2:30 PM
Thanks, that was my work around plan.