Quadrant table

A quadrant table enables the visualization of two different metrics for a given set of elements, most commonly brands. This is accomplished by plotting each element in a two dimensional chart by using each of the metrics to establish the X and Y coordinates. The table is then divided in two along each axis, creating four quadrants. The point of division for each axis defaults to the average value of the data points collected on that axis, but can be modified. The result is a quadrant table.

Creating a quadrant table

To create a quadrant table, a survey must generate two summary tiles which iterate through a common list. To use the common example of brands, this can be either a table which uses the list of brands as rows, or a question within a block that iterates on that list of brands. In either case, the options in each table/looped question will make up one of the two axes of the quadrant, and so should be a scale (e.g., 1-5, 1-7, 0-10, etc.).

setlist: BRANDS
1. BMW
2. Audi
3. Mercedes
4. Jaguar
5. Cadillac

start table: 2
intro: Please rate the following luxury car brands on Quality.
type: radio
desc: Quality
1. 1 - Poor quality
2. 2
3. 3 - Average quality
4. 4
5. 5 - Extremely high quality
rows from: BRANDS
end table

start table: 3
intro: Please rate the following luxury car brands on Innovation.
type: radio
desc: Innovation
1. 1 - Poor innovation
2. 2
3. 3 - Average innovation
4. 4
5. 5 - Extremely innovative 
rows from: BRANDS
end table

The above source code generates two summary tiles.

To create a quadrant table, start working from the tile which contains the data that should appear on the X-axis of the table. Navigate to Gear menu > Analyze > Quadrant Table. This reveals a list of all question tiles that can be used to plot data on the Y-axis. Here, T3 is selected from T2.

The result is plotted as a quadrant table, as shown below. Once a quadrant table has been created, an additional display option of Quadrant Table will appear in the tile's Display As options in the Gear menu.

Configuration options

There are a handful of configuration options per axis. These options are accessible from the quadrant table sub-menu for each axis:

Expressions

Custom expressions for quadrant tables utilize Perl, where $data is a hashref mapping each option ID to its count. For example:

There is also a predefined function: nps_avg. This is used when the given axis is a 0 to 10 NPS scale. The nps_avg function transforms the NPS values into -1, 0 ,1 detractor/promoter NPS scores. To use nps_avg, pass in $data:

Format

The Format text box allows users to create different numbers formats for the data labels on each axis. Some helpful examples: