Creating Custom Tables in Crosstabs
Overview
Users have the ability to create custom tables to view and sort data using predefined configurations directly within Crosstabs.
Custom tables will only apply to respondent data from previous survey questions. These tables appear only within reports and cannot be used to build survey logic.
Creating a Custom Table
There are two ways to create a custom table in Crosstabs. You can use the logic from an existing banner to build one out, or you can create a table from scratch using the Custom Table Editor.
From a Banner
To create a custom table from a banner, first build a crosstab with the desired segments. Then save and run the crosstab, or run without saving.
In the Actions menu, select "Create Table from Banner":
Once the table has been created, you can use the search to locate your table in the report. Look for the "vctq..." question label.
Notes:
- "Create Table from Banner" is disabled if a table already exists for the configuration.
- Modifying a saved crosstab does not modify the table. The table itself must also be edited to reflect any changes.
- Groups in the crosstab create nets in the table referencing the grouped segments.
From Scratch
To create a custom table from scratch, select "Create Custom Table" from the Actions menu in Crosstabs:
The Custom Table Editor will appear, allowing you to configure your custom table. The following options are available within the Custom Table Editor:
1. Table Title: Enter a title for your custom table. The title will help you identify your table in the report and make it searchable within Crosstabs.
2. View Datamap: Click to view the Direct to Browser version of your survey datamap in a new tab.
3. + Table Row: Custom tables are created with one row by default. Click to create an additional row in your table.
Note: While you can clear the row title and condition information for the default table row, the row itself cannot be removed.
4. Row Title: Click into the boxes here to enter row titles.
Attempting to save a table with an untitled row will generate an error message; to resolve the issue, verify that your row includes a title.
5. Condition: Click into the boxes here to enter the condition logic for each row. Row conditions will accept most report XML, excepting the ALL and ALL_IN_GROUP attributes. All conditions should reference question and answer labels (not altlabels).
Click here for more information on writing condition logic.
Note: Entering invalid logic will generate an error message; to resolve the issue, verify that your logic is referencing the correct question and response labels.
6. Delete Row: Click to delete the row.
7. Move Row: Click and hold to drag the row to a new location in the editor.
8. Add a Filter: Check to add a pre-specified filter to further define your table base. Filters listed here are automatically populated from any saved crosstabs you have access to.
8. Save: Click to save the table and add it to the report.
Configuring Your Table
To configure your custom table, click into each text-box and enter the associated information. For example, to enter a name for for your custom table, click into the "Table Title" box in the editor:
Similarly, click into the text-boxes under "Row Title" and "Condition" to add the necessary details for each row:
To add a new rows, click "+ Table Row" at the top right once for each additional row you need:
Then, enter the title and condition information for each new row you have created:
Applying Your Table to the Report
Once you are satisfied with your custom table, click "Save" to apply it to the report. Crosstabs will automatically refresh and you will be redirected to view the full report.
From here, scroll down or click into the search box to locate and view your table:
Once applied to the report, custom tables are permanent and can not be removed. Be sure to verify that all of your table rows and information is correct before clicking "Save" in the editor.
Editing a Custom Table
Once a custom table has been applied to the report, it can be edited at any time using the Custom Table Editor. To access the Custom Table Editor for an existing custom table, click "Menu" and select "Edit Logic":
Note: Changes made to a banner after a table has been created from it will not affect the table. The table itself must also be edited to reflect those changes.