Defining a hierarchy using the Add hierarchy dialog
You can define a hierarchy for use in many visualizations or to obtain a hierarchy filter using the Add hierarchy dialog.
Procedure
-
Select
Data > Add hierarchy on the menu bar to
open the Add hierarchy dialog.
There are more ways to reach the Add hierarchy dialog:
- From the Data canvas: Click the plus sign on the final data table node, and select Add hierarchy.
- From the
Data in analysis flyout: Hover with the
mouse pointer over any column and click the Show filter button
. Right-click the opened filter, and select Add hierarchy.
- If more than one data table is available in the analysis, specify which Data table to work on.
- Select the columns you want to include in your hierarchy from the Available columns list, and click Add > to show the columns in the Hierarchy list
-
Select a column in the Hierarchy list, and use the
Move up and
Move down buttons to position it correctly in
the hierarchy.
Tip: The least granular category should be placed at the top of the list, for example, Continent should be placed above Country, and Country should be placed above City.
- Enter a name for the new hierarchy in the Hierarchy name field.
-
Click
OK.