WORKING WITH HIERARCHIES
DRAG AND DROP WITH HIERARCHIES
Datasets may include variables that are represented as hierarchies. This is where there are different levels of a variable that can be displayed. Geographic variables are often available as hierarchical variables. For example, the Greater Capital City Statistical Areas (GCCSA) variable contains a hierarchy of several levels, with STATE at the top level, GCCSA at the next level, and Statistical Area 4 (SA4) at the lowest level.
This section includes:
Using 'Choose a level to select all' with hierarchies
Navigating the hierarchy within a table
Drag and drop with hierarchies
USING 'CHOOSE A LEVEL TO SELECT ALL' WITH HIERARCHIES
Use the Choose a level to select all option with hierarchies to select all categories at a particular level in a hierarchical variable. The highest level of the hierarchical variable is always displayed first in the list, the next level is displayed second, and so on.
Click on the > next to the top level variable. Selecting SA4 here selects all SA4s in all States.
Click on the > next to one of the State level categories. Selecting SA4 here selects all SA4s in that State only.
Click on the > next to one of the Greater Capital City Statistical Area (GCCSA) level categories. Selecting SA4 here selects all SA4s in that GCCSA only.
NAVIGATING THE HIERARCHY WITHIN A TABLE
For hierarchical variables, drill down within the table. By clicking on the underlined category name, the next level down of the variable will display. For example, clicking on New South Wales will display the next level down: Greater Sydney, Rest of NSW, etc.
Display of next level down for New South Wales.
Collapse back up to the State level by clicking on the double arrow. This will display all variables for the higher level.
When you use drag and drop with a hierarchical variable, choose whether to add the category you are dragging or one of the levels below. This will depend on where you click to start dragging.
- If you start dragging from anywhere else on the category name, then TableBuilder will add the category you are dragging.
- If you start dragging from the Choose a level to select all > button, then TableBuilder will add the lower category levels to the table.
For example, dragging from the name of the category New South Wales
adds New South Wales
to the table.
Dragging from the Choose a level to select all >
button adds the category levels below
the category New South Wales
to the table.