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 may be:
Banner tables can allow you to visualize how respondents from each of these answer options responded to all of the questions without having to create groups and segments for each option. The question that you used to segment the rest of the survey is referred to as the Pivot Question.
How can I create banner/pivot tables?
Can I see an example of the Excel Report?
Below is an example of the banner table selected with the display option Data Table + Charts. You can see that the survey questions are listed in the first two columns, showing the answer options and the overall responses. The pivot question answer options are then displayed across the next set of columns. The percentages shown are the percentages of those who answered both the survey question listed AND the pivot question. For example, from the example below, we see that 21.43% of those who were from the North-West were male, and 78.57% of those from the North-West were female.
Can I have a banner table for multiple pivot questions?
Yes. You can have multiple Pivot questions using the Secondary Pivot and/or Nested Pivot option.
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.
Are there limitations I should be aware of when creating banner tables?
For simple (non-nested) tables, there is no limit to the number of columns that can be used in the tables. This includes tables with a primary pivot question and a secondary pivot question. Please keep in mind, however, that if your data set is large or if there are a lot of data points (questions) in your survey, it may take a longer time for the system to generate the banner table.
For Nested Pivot Tables, there is a limit of a total of 64 columns. This is to prevent our system from being over utilized and slowing the service for others. This is a system limitation and no exceptions will be made.
Custom Variables cannot be included as either the original Pivot Question or the Nested Pivot.
License & Access Options
This feature/tools described here are available with the following license(s) :