In this article
Advanced Reporting dynamically generates crosstabs based on items dimensions, demographics. Customize data display, apply significance tests, save workbooks.
1: About Advanced Reporting
Advanced Reporting provides the ability to dynamically generate crosstab views of results based on items, dimensions, demographics, or permissioned work units. Based on the selections made for columns and rows, users can select dimensions or other data display options. Results are limited to the work units and demographics that users are permissioned to access.
A Crosstab is a dynamic interface that enables flexible data analysis through a range of options:
All of this culminates in a custom Crosstab table.
2: Advanced Reporting Ribbon
1 Calculations - Apply different calculation types, ranging from categorical, numeric and weighting and configure decimal precision control. See Calculations in Advanced Reporting for more information.
2 Base settings - Your organization has applied a base size suppression rule to your dashboard. The base size suppression rule protects respondent confidentiality by hiding results that are based on a minimal number of responses. See Base Settings in Advanced Reporting for more information.
3 Split settings - Nest splits for hierarchical organization, remove empty columns for clarity, toggle variable labels on or off, and manage how totals are displayed within your table. See Split Settings in Advanced Reporting for more information.
4 Significance Test - Enable or disable the application of significance testing on your data and choose between T-test and Z-test for your analysis. See Significance Testing in Advanced Reporting for more information.
5 Use Hierarchy as Split - Switch the table view in your Crosstab to use hierarchical data as the splitting criteria, organizing the displayed information according to the selected hierarchy structure. See Hierarchies in Advanced Reporting for more information.
6 Transpose - Switch the rows and columns in the table. This means if your data is currently displayed with questions as rows and splits as columns, clicking this will reverse that, displaying splits as rows and questions as columns, or vice versa. Demographics cannot be added to whichever box (rows or columns) is designated as displaying questions.
7 Clear - Clear the entire Crosstab of all variables/hierarchies.
8 Clear Individual Elements - Click the ellipsis to individually clear questions, splits, filters and the reporting period. Clear splits is not available when you are in “Hierarchy as Split mode” as splits are not supported in that mode.
3: Advanced Reporting Sidebar
1 Search - Search for specific variables within your dataset.
2 Show code - Show or hide the variable codes.
3 Variable List - A list of the variables available from your dataset that can be used to configure your Crosstab.
4 Sheet Management - Click the ellipsis icon to manage the current sheet or insert a new sheet. See Sheets in Advanced Reporting for more information.
5 Add Sheet - Use this to add a new sheet to your current workbook.
4: Advanced Reporting Dashboard
1 Reporting Period Filter - Click "Include all data" to open a menu that allows you to select the range of dates for the data you wish to analyze. You can choose to include all data or specify a particular range. Additionally, you can select which date variable to use for filtering your data.
2 Filter Area - Drag and drop variables into this area to filter the data that will be displayed in the Crosstab.
3 Rows (Questions) Area - Drag and drop variables to use as rows in your Crosstab. Demographics cannot be dropped into the Questions Area.
4 Columns (Splits) Area - Drag and drop variables to use as columns in your Crosstab. This defines how data is split.
5 Generate Table - After configuring your variables and splits, click the Generate Table button to generate the Crosstab table. See Generating the Table for more information.