Transform to condense is most commonly applied to text open-ends. This functions allows you to condense multiple text columns into a single distribution.
For example, the survey below elicits multiple reasons. For analysis we'd like to combine these three open-ends into one single list.
To condense the values, place the elements in a group (e.g. qV) as above. Press the edit icon for the group and select "Transform..." from the context menu to bring up the transform dialog:
The text responses are now condensed into a single distribution.
This is a multi-value element, so percentages may sum to more than 100%. Below selecting people who chose "Experience" shows they also entered other reasons:
For a squished group, in the JSON editor you can add an attribute "unique". Below, Q22 has "unique" : false and the clone Q22_copy has "unique" : true. Filtering the view for one respondent (e.g. 50625), you can see that when "unique" is set to false each value is counted separately. N size will be the number of response values. When "unique" is set to true, Protobi will recognize the multiple responses are from one respondent and N size will only count unique respondents.
Remove the transform
To undo a transform, go to the group's context menu and select "Expand/collapse." Then, bring up the transform dialog and select "None." The group should return to its original state.
Condense multiple text columns