Crosstab reports

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 create Crosstab reports, go to Analyze > Reports > Crosstabs in the survey navigation menu.

Overview

Crosstabs works with published data only. 

• Copy tables: To copy a single table, open the three-dot actions menu on that table's header. To copy a all or a portion of a table, use your keyboard shortcuts.
• Nets and metrics: Add or edit nets and metrics from the actions menu. Nets and metrics added in Crosstabs also appear in Frequency, and vice versa. Nets and metrics added through the source code automatically display in the relevant table rows.
• Saving reports: All saved reports are accessible in Deliverables. They're available to survey Makers and users from the same organization. See User access for reports for more information.
• Exporting tables: To export a single table, open the actions menu at the parent table level. To download a Crosstab report (multiple tables in one sheet), use the download button. To export multiple tables to individual sheets, use the actions menu in the main toolbar.

Creating a Crosstab report

Crosstab reports are created and edited in Settings. Use the various fields and filters to create a report focused on the specific data you need.

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 numeric open-ended survey fields will be available.

Reorder columns by dragging and dropping fields into a new position. To reorganize rows, click the icon, then use the handle to move the fields as needed.

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 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 further 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

You can optionally set parameters to include specific respondents in the chart. Click None in the Filters dropdown to launch the Filters menu. Previously made data cuts appear in Pre-Built. Otherwise, click Build to create a new one.

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 Male (B) reveals statistically significant differences from column Other (D) in two rows, Red and Orange. The confidence interval for "Red" is 95%, while the confidence interval for "Orange" is 90%.

When Show sig tests is toggled on, you can download an Excel file with the sig tests in rows or columns. The example above places the sig tests within the rows. The same data can be displayed in columns, as shown below.

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 Deliverables and double-click to open it. Make your necessary changes in Settings.

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.