Drag to crosstab one or many elements


Updated at January 24th, 2020

Create crosstabs in Protobi by dragging the title of one element on to another:

Crosstab elements individually

To create a crosstab you drag one element (e.g., q1) to the heading of another (e.g., q2). The element you drag will define the columns (or "banner"), and the other will define the rows (or "stub"). 

To clear the crosstab, drag q1 out of the crosstab, and q2 returns to a simple marginal distribution.

Taking a closer look, we see two elements, "Generally how would you say things are these day in your life" and "How would you rate your own health in general these days?" It's set up so that the happiness responses appear as a crosstab versus the health responses.

The grey and blue highlights significant differences from the overall marginal. The stats tests intelligently account for the fact that each column comprises a part of the overall marginal.

It is often effective to drag from the element tree on the left. You can use crosstab variables that are not on the same tab.

Crosstab elements globally

Drag an element title to the the "Crosstab"  button in the toolbar to define a global banner.  Any elements and charts that can take a banner variable will be crosstabbed.

To remove, click on the cross tab button, and select "clear."

Crosstab with two banner variables

Drag one element (e.g., S1) to the heading of another (e.g., Q1). Then start to drag the second element (e.g., Region). Hold down the SHIFT key before dropping the second element. This will allow you to add two banner variables when cross-tabbing. 

Note: This will not work if you hold down SHIFT before you start dragging the element. 

You can apply this method globally as well. Instead of dropping into an element, drop into the "Crosstab" button. 

When you create a global crosstab with two banner variables, an option to "swap" will appear. Below, the project is crosstabbed by specialty (S1) first, then Region. Press swap to crosstab by Region first, then specialty.  

Video Tutorial

Was this article helpful?