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

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 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.

Screenshot

Yes. When clicked on Create Banner Table button, you are provided with the Banner report link. You can also download this excel (.xls) report.

Screenshot

Yes. You can have multiple Pivot questions using the Secondary Pivot and/or Nested Pivot option.

Screenshot

1. Secondary Pivot

   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.

2. Nested Pivot

   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.

3. Data Table

   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.

4. Display Options

   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.

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

Yes. Please see Advanced Reporting Display Options below.

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.

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.

• Corporate Edition - Buy Now - $99/Month
  • Unlimited Surveys, Questions, Responses
  • Advanced Toolset and Features
  • No Long Term Commitment