Crosstab reports (r9)

A Crosstab (cross-tabulation) report lets users analyze data by subgroups and create frequency tables, revealing relationships between one or more question-rows and the selected columns.

To access the Crosstabs applet, go to Analyze > Reports > Crosstabs in the left navigation menu.

Overview

• The Crosstabs applet works with published data only. 
• Use the right pointing chevrons to expand and collapse tables.
• Expand the actions menu at the parent table level to add and edit nets and metrics or to download a single table.
• To download all tables, use the download button for a single sheet, or use the main toolbar's actions menu for multi-sheet downloads.
• Saved reports are accessible via the Deliverables applet for future use. You can also copy the saved report URL from the actions menu.
• A saved Crosstab report is accessible by a survey Maker or users from the same organization. See User access for reports for more information.

Creating a Crosstab

Crosstab reports are created and edited using the Crosstabs Editor, a modified version of the Report Builder found in all reporting applets. Use the various fields and filters to create a report focused on the specific data you need.

A brief overview video of how to create and edit Crosstab reports can be found here.

Columns and Rows

When selecting columns, any closed-ended survey field plus any comparison group that has been created will be available. When selecting rows, both closed-ended and open-ended survey fields will be available. 

Configurations

In addition to the respondent status filters, the following options are available to modify the report's format and data:

Display: Data can be displayed as Percents only, Counts only, or both Percents and counts.

Weights: Weights that have been uploaded in the Weights applet can be applied to the data. When weights are applied, both the weighted and unweighted base sizes will be displayed in the report.

Sig Testing: Crosstab reports can be set to Show sig tests to highlight statistically significant differences between column values. Confidence levels are explained below.

Show child tables

A table is collapsed to show only the question text by default. Click this toggle to expand all tables to show the Total Answering row, all question options, nets, and metrics.

Filters

Date/time, respondent ID, and data cut filters can be applied to all tables to refine which respondents are included in the Crosstab report.

• Pre-Built: Selects a single field and value (e.g., Q2, option 1) or a previously defined data cut.
• Build: Opens the Expression Builder to help you create simple or complex data cuts.

Statistical significance tests

Sig testing highlights statistically significant differences between column values. Columns are labeled with letters (A for the first column, B for the second, and so on).

Significance testing is performed at both 90% and 95% confidence intervals. Significant results are displayed by letters.

• A lowercase letter means the value is statistically different from the value in the comparison column at a 90% confidence interval.
• An uppercase letter indicates a statistically significant difference at a 95% confidence interval. 

In the example below, column Blue (C) shows statistically significant differences from columns D, G, and H among those who answered "Very Satisfied." The confidence interval for columns D and G is 95%, while the confidence interval for column H is 90%.

Editing a saved report

Editing a saved report is similar to creating a new one. If the saved report is not open, find it in the Deliverables applet and double-click to open it. Make your necessary changes in the Crosstabs Editor.

Once the changes have been applied, the Save button will become active again and include a dropdown menu. You can either overwrite the previous report by selecting Save Changes or create a new report by selecting Save As New.