Desktop User Guides > Reporter > Tabulating hierarchical data > Understanding grid tables
 
Understanding grid tables
See Creating tables using grid variables for an introduction to grid tables and step-by-step instructions for creating a grid table. This topic provides more detailed information about grid tables and how they work.
You can create grid tables from any grid or loop that is defined in the metadata as expanded, regardless of whether the data was actually collected using a grid question in the questionnaire.
To see how grid tables work, look at the rating grid question in the Household sample. This grid question is nested inside the vehicle loop and so its full name is vehicle[..].rating (which we can optionally shorten to vehicle.rating). This grid question asks respondents to select a rating category for some of the vehicle's features.
Grid questions can be considered as categorical loops, which are loops in which a category list defines the iterations and the iterations are presented simultaneously in a grid-like format. The category list that defines the iterations is sometimes referred to as the controlling category list. One or more variables inside the loop define the question(s) to ask for each iteration. The rating grid contains one variable (called Column), which has a category list that defines the rating categories.
The following diagram shows how the grid in the Variables pane relates to the grid question when it is presented in a paper questionnaire.
Grid question in Variables pane and in questionnaire
This graphic is described in the surrounding text.
In this example, each iteration of the grid forms a row of the grid question as it is presented in the paper questionnaire. The columns of the grid question are formed from the categories of the Column variable inside the grid. This variable's full name is vehicle[..].rating[..].Column.
To create a grid table for the rating grid, select the grid in the Variables pane and click Add Grid/Loop on the Design tab.
The variable name on the top of the table consists of the full name of the rating grid and the name on the side consists of the full name of the variable (Column) inside the grid.
Grid table specification showing full names of variables
This graphic is described in the surrounding text.
Here is the table:
This graphic is described in the surrounding text.
When you create a grid table using the Add Grid/Loop button, UNICOM Intelligence Reporter orients the grid table according to the default orientation defined for the grid or loop in the metadata. In this grid table, the iterations are displayed as columns because that is how the loop's default orientation is defined in the metadata.
See also
Changing the table orientation
Tabulating hierarchical data