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:
- North-West
- West Coast
- Mountain States
- Mid-West
- South
- East Coast
- North-East
Banner tables can allow you to visualize how respondents from each of these criterias 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.
How do I use the Banner Table tool?
Goto
- 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. This will further subsegment the data based on a combination of the responses to both the questions.
If you choose one of the Custom Variables, then a banner table will be produced for each distinct item for that custom variable. For example, if you are capturing sales region as one of the custom variables, choosing that custom variable will automatically segment your data based on every distinct region in your dataset.
If you choose Custom Data Segment, you then need to provide the data-segements (Groups) that you want the banner table for. For an explanation on how to create customized data segments, please refer to the Grouping/Segmentation Tool.
| Screenshot |
 |
Step 2:
Next choose the charting/output options
In the future we envision other formats like MS PowerPoint, PDF, HTML etc. As of now, Banner Tables are available in Excel format only.
Can I see an example/screenshot of the Excel Report?
| Screenshot |
 |
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.
| Screenshot |
 |
Can I produce a report with multiple pivots?
Yes. Please see Advanced Reporting Display Options below.
Does the system also automatically calculate significance tests (Chi-Square etc.) for the different tabs?
As of now - No. This will be added in a future release.
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 overutilized 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 Restrictions
This feature/tools described here are available with the following license(s) :
| 
