Condense text verbatims

Squish multiple responses into one distribution

38d87d9852a66eea29da00ae16511664

Updated at March 6th, 2020

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:


"unique" attribute

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.


Video tutorial

Condense multiple text columns




See related

Transform dialog

Was this article helpful?