Dashboard viewers can drill down in most widgets to get an in-depth view of a selected value. To make it easier for viewers to select drill-down paths, dashboard designers can add predefined drill hierarchies to their widgets.

As an administrator, you can create a pool of drill hierarchies, from which dashboard designers can select the drill hierarchies they want to include in the widgets they build.

drill_manage

This section describes how to create and manage the drill hierarchies that you want to make available for designers.

To create a drill-down hierarchy:

  1. Click ADMIN in the top-right corner of the Sisense web app. In the left menu, select ELASTICUBES.
  2. Hover over the relevant ElastiCube, and from the menu on the right, select Manage Hierarchies.
    drill select
  3. If this is the first hierarchy you are adding, select Add Hierarchy. If you already have hierarchies, click Add Hierarchy in the top-right corner.
  4. Select the field. This will be the first field in the drill hierarchy, and the same field used in the widget.
  5. Click Add Field to add the next level in the drill hierarchy. Repeat this step for as many levels as you need.

hier1

Additional options include:

Always include with field: Select this checkbox to always include the drill hierarchy in the widget for this field.

Editing the Hierarchy name: To edit the name of the drill hierarchy, click on the pencil icon, and type in the name. Click on the tick icon to confirm the change.

Editing the field name: To edit the name of a field in the hierarchy, hover over the field name and click on the menu > Rename. Type in the name, and click on the tick icon to confirm the change.

hier2

  1. Add as many hierarchies as you need for the ElastiCube. When done, dashboard designers will have access to the hierarchies in the widget designer, and will be able to select and add them to the widget.

drill flow 2

To change a field in a hierarchy:

  • Hover over the field in the hierarchy, and click on the menu that appears. Click Change and select a different field.
    drill change add

To delete a hierarchy:

  • Click on the bin to the right of the hierarchy.