Skip to main content

Decipher Support

All the topics, resources needed for Decipher.

FocusVision Knowledge Base

Viewing Crosstabs

Overview

The main body of the Crosstabs reporting tool contains the applied banners, tables and charts. Tables are generated for all questions specified in the "Table Set" and by the segment criteria specified within the crosstab. Let's go over what you can expect to see when your crosstabs are generated.

dec_viewing_crosstabs_001.png

1. All Crosstabs: Go back to the Crosstabs overview, where you can create or select a new crosstab.

2. Actions: View the actions available within Crosstabs.

3. View Options: View the viewing options available within Crosstabs.

4. Exports: View crosstab export methods for both aggregated and raw data.

5. Search:  Search for or jump to any element by selecting it in the drop-down.

6. Quick Split: View the report split by total, a saved crosstab, or other criteria by selecting it in the drop-down.

7. Edit Crosstab: Edit the current crosstab using survey questions, elements, and dates.

8. Save: Save all settings for the current crosstab.

9. Edit Settings: Edit settings for the current crosstab.

10. Settings: View a summary of the crosstab settings.

11. Date Range: Select a date range by which to filter the crosstab data.

12. Additional Filter: Apply another saved crosstab by which to filter the data.

13. Segment Summary: Totals for each segment applied within the current crosstab. Click "Total" for any segment to view its defined logic in a human readable format.

14. Segments: Segments applied to the current crosstab. Hover over a segment title to view its defined logic. Click segment titles to sort table rows in ascending or descending order.

Note: Any rows set to not randomize in the survey will not be randomized when sorting.

15. Totals: Total counts for individual and combined segments. Totals may be marked with following notations:

    Indicates a small sample size - the default is 100.

   ** Indicates a very small sample size - the default is 30.

Note: The default base size can be customized with the rconf command.

16. Favorite: Mark the table as a favorite.

17. Question / Element Title: Each table includes its question or element title and label.

18. Export: View table export methods.

19. Menu: View the available table actions.

20. Total Row: The total count and vertical frequency percentage for the table.

21. Question / Element Rows: The total count and vertical frequency percentage for each table row.

Table Options

Each table contains both "Export" and "Menu" buttons. These buttons provide more control over how you view the data contained in your question and element tables.

Export

Click "Export" to download your question or element table via Excel, Powerpoint, or PDF:

dec_viewing_crosstabs_002.png

Menu

Click "Menu" to view and apply the following table actions:

dec_viewing_crosstabs_003.png

Transpose Table: Flips the data so that the rows are applied as columns and the columns as rows (requires Edit access to Reporting / Crosstabs).

Edit Table: Edit the table. Click here to learn more about editing tables (requires Edit access to Reporting / Crosstabs).

Add/Edit Charts: Add / edit charts using the available menu settings. Click here to learn more about adding and editing charts (requires Edit access to Reporting / Crosstabs).

Pin to Whiteboard: Pin the table to your whiteboard.

Show Question in Survey: View the question as it appears within the survey (requires View access to Survey, and that the question be displayed within the survey).

Note: Automatic Stat-testing is indicated by uppercase letters and lowercase letters signifying confidence levels corresponding to the built-in segment (i.e., column) indicators.

Additional Considerations

Rating/Scale Questions

By default, only "Top" and "Bottom" ranking statistics are applied to rating / scale questions. Additionally statistics will need to be added manually. To add statistics to a rating question, click "Menu" for the desire question table and then select “Edit Table”:

dec_viewing_crosstabs_004.png

Then click “+ Table Row” to bring up the table row editor:

dec_viewing_crosstabs_005.png

From the row editor, you can add statistic rows and apply summary tables as needed. Click here for more information on how to use the table and row editors.

Open-ended Questions

Open-ended responses can be viewed by clicking the count for the question or segment:

dec_viewing_crosstabs_006.png

This will open a new window for both text and number questions, where you have the following viewing options:

dec_viewing_crosstabs_007.png

1. Consolidate Answers: Check to group matching responses together and view a count for the number grouped.

2. Sort Answers: Click the arrows to sort responses by respondent record or alpha-numerically.

3. Split Answers: Select a question or segment by which to split the open-ended data.

View Options

 

Additional view options are available for tables through the "View Options" menu in the report setup section:

dec_viewing_crosstabs_008.png

By default, the Crosstabs “View Options” menu includes the following options:

  • Show/Hide QA codes: Showing will make question and answer labels visible for easier reference and QA codes will display contextually highlighting key programming settings.
  • Show/Hide Tables with No Respondents: Allows you to show or hide any table that has zero completes.
  • Show/Hide Download Data Values: Allows you to display/hide the data values in the crosstabs report.
  • Show/Hide Unweighted Total Count: If you are applying weights, you may choose to show or hide the unweighted total row in your tables.
  • Was this article helpful?