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.