Grids contain a group of axes or questions that have common answers. They make analysis easier, helping you by bringing common items together in one place.
In this article
- Grid Items
- Drag and Drop a Grid Item
- Add Totals to a Nested Grid
- Nest into a Split Grid (Coming Soon)
1. Grid Items
Grids group standard axes with a common element list. A common example is a series of image statements that are asked for a set of brands. Each image statement is an axis while the brands are the elements. During the project creation, these items are combined into a grid.
In this example, two image statements have been asked across three brands. The element list appears once and applies to all statements.
2. Drag and Drop a Grid Item
When dragging a grid into the analysis area with no other variables included, two options are available in the down and across drop zones:
- Split separates the axis into one drop zone and the elements into the other, creating a crosstab.
- Nest adds the grid into the selected drop zone with the axes nested over the elements.
Split
When dragging in a grid and using the Split option, the following behaviour is displayed:
- Down - dragging the grid item into the down drop zone places the axis labels into the down drop zone and the element labels into the across drop zone.
- Across - dragging the grid item into the across drop zone places the axis labels into the across drop zone and the element labels into the down drop zone.
- A selection of axes from a grid can be analyzed by dragging the required axes into the analysis. All elements relevant to the selected axes are included in the analysis. If you select one axis from a grid, you do not see the split option and the analysis layout is like a standard axis.
- A single element or a selection of elements within a grid can be analyzed by dragging the required elements into the analysis. All axes relevant to the selected element(s) are included in the analysis.
- Drag a grid item and select Split to create a crosstab
- Split in the down drop zone puts the axes into the down drop zone as rows
- Split in the across drop zone puts the axes into the across drop zone as columns
- Drag a selection of grid axes to the down, they appear in the down
- Drag an element to the down, it appears in the down
Nest
When dragging a grid and using the Nest option, axes and elements both display in the same drop zone with one item nested over the other.
- Down - Dragging the grid item into the down drop zone nests the axes over the elements in the down drop zone.
- Across - Dragging the grid name into the down drop zone nests the axes over the elements in the down drop zone.
- A selection of axes from a grid can be analyzed by dragging the required axes into the analysis. All elements relevant to the selected axes are included in the analysis. Note that if you select one axis from a grid, you will not see the nest option and the analysis layout is like a standard axis.
- A single element or a selection of elements within a grid can be analyzed by dragging the required elements into the analysis. The element is nested first with all relevant axes nested second.
- Drag a grid item and select Nest to create a nested analysis
- Nest in the down drop zone nests the axes over the elements in the down drop zone
- Nest in the across drop zone nests the axes over the elements in the across drop zone
- Drag a selection of grid axes to the down, they appear in the down, nested first - axes over elements
- Drag an element to the down, it appears in the down, nested first - elements over axes
With an axis or measure already in one drop zone, Harmoni automatically nests the grid when you drag it to the other drop zone. The option to Split or Nest is not available.
If you create a split grid and drag a axis or measure into one of the drop zones using Replace, Harmoni automatically nests the grid in the other drop zone.
example gif here
- Drag an axis to the across drop zone
- Drag a grid to the down drop to nest it
- Drag a grid in and use Split
- Drag an axis to either drop zone using Replace and the grid is nested
3. Add Totals to a Nested Grid
The total for the grid is automatically hidden when it is nested into an analysis. It can be useful to unhide the total when you have values in a rating scale, as you can then view the averages for each item in the total row.
To include the total, you have two options:
- Use the Selector and add the total to the required item
- Use the Total toggle to switch the Totals on
Selector
With the grid nested, select the Elements label in the interactive title and add the Total. This method works with or without a crosstab axis included in the analysis. Without a crosstab, you will need to manually add the averages.
- Drag an axis to the across, and a grid item to the down dimension
- Click on Elements in the interactive title to add the Total
- The total row is added showing average values for the down axis
Total Toggle
When the grid is nested and there is an axis in the other dimension, the Totals ON/OFF options is ON because the single axis has the total displayed. To switch the totals on for both dimensions, click Totals OFF, which turns the total off for the single axis, and then click ON, which turns both totals on.
- Create a nested grid with a single axis in the other drop zone
- Totals are only displayed for the single axis
- Toggle totals OFF and then ON to display totals for both dimensions
- The average displays in the total row for each axis in the grid
4. Nest into a Split Grid (Coming Soon)
When you create a split grid, you are currently not able to nest in another item. Soon, you will be able to nest an axis directly into the grid.
- Drag in the grid and use Split
- Drag in the item and drop it on Nest
- Create a split grid
- Drag an axis and use Nest to nest it into the grid
Where to from here?
Learn more about analysis