Tally a group of responses

43
1
09-05-2019 01:42 PM
Highlighted
New Contributor III

I have a survey with a series of 10 questions, each question has 2 choices. The choices are specific to the question, but are related in a fashion - 1 response is related to group 1 the other related to group 2. I need to tally the number of responses that relate to each group and display the values (i.e., group 1 = 4, group 2 = 6).

Any help would be most appreciated.

Highlighted
Frequent Contributor II

Are they 10 questions or one question in a repeat?

If 10 questions it will be some work.

Add 2 hidden fields with a calculation of if(group1value,1,0) then make sure to set the bind:type column to int.  Second one is if(group2value,1,0)

Then make a final field to add all 10 of the above fields up.  So q1count+q2count+etc  bind this to int also.

If you are using a repeat then its easier.

Add 2 hidden fields with a calculation of if(group1value,1,0) then make sure to set the bind:type column to int.  Second one is if(group2value,1,0)

Then make a final field to add all 10 of the above fields up.   But not all you need is sum(q1count) and sum(q2count).  bind this to int also.