Sign in
x
☰

Count checkbox selections

Updated at 2020-05-12 19:16:00 UTC

With "Check all that apply" questions, it may be helpful to count how many options respondents checked "Yes" for. Below, we have have a question S10v1 and child elements representing different products. A simple way to count the number of products selected is to use Protobi's Transform. 

Protobi interface showing S10v1 checkbox question 'Which of these products have you heard of?' with child elements listed: Apple iPhone, Samsung Galaxy, LG, Motorola, HTC, Nokia, and Other. Each child shows as collapsed element with icon and label.

Transform to sum

Say the underlying values in S10v1 are "0" or "1", representing "No" or "Yes" respectively. You can Transform to "sum" to count the number of options that were selected.

Below is the distribution after S10v1 was transformed to sum, and child elements were hidden. 

Protobi chart showing S10v1 transformed to sum. Horizontal bar chart displays distribution of counts: 0 (12%, n=12), 1 (23%, n=23), 2 (17%, n=17), 3 (23%, n=23), 4 (13%, n=13), 5 (8%, n=8), 6 (4%, n=4). Question 'Which of these products have you heard of?' shown above chart.

Exclude an option from the count

Using S10v1 as an example, you may want to exclude certain options from the count. Say you do not want to include "Yes" values from Other in the count. From S10v1's context menu, choose "More properties..." and remove the child element.