Calculate/Transform dialog

Updated at September 23rd, 2022

Protobi allows you to calculate a value for a group based on its children elements by defining a Transform.

"Transform..." is different from "Compact to..." in that it calculates a new aggregate value for the parent group rather than showing summary statistics for each child element.

Transform to sum

Your survey might have a question where you ask respondents to enter multiple percentages that sum to 100. Each individual percentage is its own question and has its own distribution. The results might appear as follows:

In reference to the example above, you may want to make sure that the percentages really do sum to 100. You can calculate that sum within Protobi. Press the square edit icon for the group and select "Transform..."

This will bring a dialog showing a number of options to combine the element values into one aggregate value:

Below is the distribution for the resulting sum.

Surprise! Not all of the percentages actually sum to 100. Some are below and many way above. Better talk to the survey programmer...

When you select a Transform, you have the option to hide the distributions for the child elements. To hide those distributions, in the transform dialog check the square box next to "Hide children."

Checkbox example

Your survey might have a set of "Check all that apply" questions. Say the underlying values are "0" or "1", representing "No" or "Yes" respectively. You may want to know how many options respondents checked "Yes" for. You can use Protobi's 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. 

Undo transform

To return to the original state, bring up the "Transform..." dialog and select "None."

See related

For more complicated transform options that are not covered in this tutorial see:

Was this article helpful?