Define a Hierarchy Field for Your Source

After you have created your source, define a hierarchy field for your source. Once you've defined a hierarchy field, you can create a table visual or pivot table visual that uses your hierarchical data.

Add a Hierarchy Field

1. Open the Fields tab of your hierarchical source.

2. Select Add Hierarchy Field. The Add Hierarchy Field work area opens.

   

3. Select a Parent Field, a Child Field, and optionally select a Label Field if applicable. If you do not select a Label Field, the value selected for Child Field is used.

   • A parent field references another row from the same table using a unique identifier or unique name. This establishes the parent-child relationship. The parent and child fields must be the same field type, either an attribute or number.

   • A child field contains a unique identifier or unique name of an element in the hierarchical tree, unique within the scope of the table. The parent and child fields must be the same field type, either an attribute or number.

   • A label field contains a user friendly name of a hierarchy element. This optional field is visible on the visual if configured. This field does not need to be unique.

4. Select Save to save your new hierarchy field.

   

5. Optionally, disable the Time Bar on the General Settings tab, and select Save Settings to save your changes.

After you've defined a hierarchical field, you can:

• Create a table visual or pivot table using the hierarchical data referenced by this hierarchy field.

• Filter data using this hierarchical field in a filter or filter snippet.