Sign in
x
☰

Transform to condense

Updated at 2020-03-06 14:11:17 UTC

"Transform group" dialog with blue header showing options to calculate parent group values from children: None, Sum, Mean, Median, Min, Max, Std Dev, Condense ("squish" arrow) selected with red border, and Compact ("squish" bracket). Blue "Hide children" checkbox is checked at bottom. Gray "Cancel" and blue "Ok" buttons at bottom-right.

Protobi's "Condense" transform allows you to transform the responses from a group of elements into a single distribution.

The most common uses are:

Example

Due to skip patterns, you might ask certain respondents the same question at different points in a survey. Below, ten respondents answered Q12 and three respondents answered Q22. During the course of analysis, we might wish to see the responses grouped into a single distribution. 

Side-by-side display of Q12 (left) asking "Are you aware of which services are included in the premium package?" showing No (50.0%), Yes (50.0%), N=10, and Q22 (right) with same question showing No (66.7%), Yes (33.3%), N=3. Both use blue circle icons and blue horizontal bars.

To use the transform function, we must first create a group with these two elements. We select Q12 and Q22 and choose "Group" from the Advanced button. We name the group Q12_Q22.

Condensed question group "Q12_Q22" with blue square icon showing both Q12 and Q22 as subheadings with blue circle icons. Single question text "Are you aware of which services are included in the premium package?" followed by Q12 responses (No 50.0%, Yes 50.0%, N=10) and Q22 responses (No 66.7%, Yes 33.3%, N=3) displayed side-by-side with blue bars.

Transform to condense

Press the group's (e.g. Q12_Q22) square edit icon and choose "Transform..." from the context menu.  This will bring up the dialog you see at the top of this tutorial.   

Select "Condense (squish)" from the dialog and select "Hide children", then Press "Ok". 

The element will now appear as a single distribution with all responses. Notice that N=13 for the group, which is the total of the N sizes in Q12 and Q22. 

Question group "Q12_Q22" with blue square icon displaying single question "Are you aware of which services are included in the premium package?" with gray italic text "Transform to squish". Shows combined responses: No (53.8%), Yes (46.2%), N=13, with blue horizontal bars representing the aggregated data from both Q12 and Q22.

Remove the transform

To return to the original state, bring up the Transform dialog again, select "None" and **de-**select "Hide children".