Banner tables and Cross-tabulation Video
What are Banner Tables?
Banner tables allow you to visualize and view your data relative to a single question. For example, if in your survey, one of the questions is "Where are you from?" - The answer options are:
Banner tables can allow you to visualize how respondents from each of these criteria's responded to all the questions without having to create groups and segments for each option. This question that you segment the rest of the survey is called the Pivot Question.
- West Coast
- Mountain States
- East Coast
How do I use the Banner Table tool?
- Login » Surveys » Reports » Online Tools » Cross-Tabulation » Banner Tables
- Step 1: Choose the Pivot question. This is the question that you want to segment on. In the example above, this would be the question : "Where are you from?" Optionally, you can also choose a Sub-Pivot question from the Secondary Pivot option. This will further sub-segment the data based on a combination of the responses to both the questions.
- Step 2: The Output format options is Excel. Select the charting/display option and click on Create Banner Table button.
As of now, Banner Tables are available in Excel format only. In the future we envision other formats like MS PowerPoint, PDF, HTML etc.
Can I see an example/screenshot of the Excel Report?
Yes. When clicked on Create Banner Table button, you are provided with the Banner report link. You can also download this excel (.xls) report.
Can I have Banner Table for multiple Pivot questions?
Yes. You can have multiple Pivot questions using the Secondary Pivot and/or Nested Pivot option.
The Secondary Pivot allows you to Pivot on more than one question. For example, if you wanted to produce a Banner Table that pivots on Gender AND Race, you can choose Gender as the primary Pivot and Race as a the secondary pivot. The secondary pivot is optional.
The Nested Pivot allows you to Pivot on more than one question combined. For example, if you wanted to produce a Banner Table that pivots on Gender combined with Race, you can choose Gender as the primary Pivot and Race as a the nested pivot.
The values produced in the Data Table can either be absolute frequency numbers i.e. the actual number of users who chose a particular option, or be relative percentage.
The Banner Tables can be generated with or without associated charts. Generating Banner Tables without charts is generally faster and the resulting file is smaller also.
Can I integrate Custom Variables with Banner tables?
Yes. Choose the Custom Variable you want to segment on (in step 1) and the system will automatically create a banner table for every available data point.
Can I produce a report with multiple pivots?
Yes. Please see Advanced Reporting Display Options below.
How about Nested Pivot tables? Can I combine multiple questions (nest) and create a banner table for all possible combinations of two questions?
Yes. Choose the first question as your primary pivot, and then choose your second question as the nested pivot. If you are using nested banner tables, please see the note on limitations below.
Are there any limitations on the number of variables/questions etc?
For simple (non-nested) tabs, there is no limit. Please keep in mind however that if your data-set is large or there are a lot of data-points (questions) in your survey, it may take a longer time for the system to generate out the banner table.
For Nested Pivot Tables, there is a limit of a total of 64 columns. This is there to prevent our system from being over utilized and degrading the service for others. This is a system limitation and no exceptions will be made.
Nested Pivot tables can only be used with Survey Questions and not with Custom Variables.
License & Access Options
This feature/tools described here are available with the following license(s) :
- Corporate Edition - Buy Now - $99/Month
- Unlimited Surveys, Questions, Responses
- Advanced Toolset and Features
- No Long Term Commitment