Details on Insert Hierarchy

Predefined hierarchies can be set up when two or more columns are somehow related to each other. For example, a hierarchy can add structure to columns containing Country, State and City. The predefined hierarchies allow you to quickly change the level of detail in a visualization by using the hierarchy sliders, or, when you wish to combine two or more filters to a more structured hierarchy filter.

Note: The number of allowed nodes in a hierarchy with more than one level is limited to 100 000. If you try to create a hierarchy with more nodes, you will simply receive a hierarchy with one value, (All). If this should happen, edit the hierarchy and remove the column with too many unique values from the hierarchy.

  1. Select Edit > Column Properties.

  2. Click on the Insert button and select Hierarchy... from the menu.




Data table

Only available when more than one data table is present in the analysis and the dialog has been opened via the main menu. Specifies the data table where the hierarchy will be inserted.

Available columns

Lists all columns that can be used to create a hierarchy.

Add >

Adds the column selected in the Available columns list to the Hierarchy.

< Remove

Removes the selected column from the Hierarchy and sends it back to the Available Columns list.

Move Up

Moves the selected column up in the Hierarchy.

Move Down

Moves the selected column down in the Hierarchy.

Hierarchy (least detailed on top)

Lists the columns that will be part of the new hierarchy. Start with the least granular category and continue to add more and more granular categories to the list.

Hierarchy name

Type a name to define the new hierarchy.

See also:

Column Properties - General

Column Properties - Formatting

Column Properties - Properties

Column Properties - Sort Order