1406.0.55.005 - TableBuilder, User Guide  
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 15/12/2016   
   Page tools: Print Print Page Print all pages in this productPrint All RSS Feed RSS Bookmark and Share Search this Product

WORKING 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.
Image: Showing option to select at different levels in a hierarchical variable


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.
Image: Selecting SA4 in all States in a hierarchical variable

Click on the > next to one of the State level categories. Selecting SA4 here selects all SA4s in that State only.
Image: Selecting SA4 in one state only in a hierarchical variable

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.
Image: Selecting SA4 in one GCCSA only in a hierarchical variable


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.
Image: Underlined variable that you can drill down into for a hierachical variable

Display of next level down for New South Wales.
Image: Results of drilling down in a hierachical variable

Collapse back up to the State level by clicking on the double arrow. This will display all variables for the higher level.
Image: Double arrow to return to the higher level for a hirarchical variable


DRAG AND DROP WITH HIERARCHIES

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.
Image: Drag and drop with a hierarchical variable

Image: Table displaying the selected category

Dragging from the Choose a level to select all > button adds the category levels below the category New South Wales to the table.
Image: Adding the variable's children to the table

Image: Variable children added to the table