Hierarchy fields help separate the details on different levels, keeping the dimensions in an organized manner as well as revealing additional details as you drill-down the data.

Wyn Dashboards automatically creates the date hierarchies by arranging the date in hierarchical order (Year > Month > Week > Day) when a dataset is added to any scenario.

You can create custom hierarchies for dimensions to arrange the dimensions on different levels of details. For example, you can define a 'Product hierarchy' as Product line > Product type > Product, as shown below.

Create a Hierarchy Field

1. In the Data Binding tab , navigate to the dimension for which you want to create the hierarchy.

Note that you can create hierarchy for the dimensions only, and not for measures.

2. Go to the dimension's Settings and select Create Hierarchy Field...

   

3. In the Create Hierarchy Field dialog, drag the dimensions from the left pane to the right pane in the order of the hierarchy. You can rearrange the dimensions in a hierarchy by dragging them upward or downward.

   

   You can also change the hierarchy name as required. By default, the Hierarchy Name is Hierarchy_parentfieldname.

   Observe that a new hierarchy field is created alongside other dimensions.

   

4. Preview the Dashboard.

5. The scenario using the hierarchy fields show Expand Group (+) and Collapse Group (-) options. Click the Expand Group (+) and Collapse Group (-) to drill-down or drill-up into or from the hierarchy as shown.

   

The preview shows 'Product line' along the X-axis of the Column Chart scenario. As you drill-down the hierarchy by one level, you see additional details on the 'Product type', and on further drill-down, you see the details on the 'Product'.