Adding Drill Hierarchies to Widgets

Dashboard Viewers have the option to Adding Drill Hierarchies to Widgets, and get an in-depth view of a selected value.

While Viewers can select a drill-down path from the complete list of fields, it’s easier to select a commonly needed drill hierarchy from a short list. This is especially true when there is a lot of data, and the Viewer needs to remember specific fields, and select them each time.

As an Administrator, you can add predefined drill hierarchies to widgets.

For a short video overview of drill hierarchies, see below:

To enable drill hierarchies in a widget:

  1. In the Widget Designer, click on the Categories menu, and select Hierarchies…

  2. Select the checkboxes next to the drill hierarchies that you want to make available to dashboard viewers.


    Hierarchies with a lock icon will always appear in the widget. To unlock this option, please contact your Sisense Administrator.

Disabling the Drill to Anywhere Option

As an Administrator, you can restrict viewers to predefined hierarchies only, by disabling the option to drill down freely to any field.

The drill-to-anywhere option is enabled by default for all users and widgets. You can disable the drill-to-anywhere option in the Sisense web app per widget (see below), or by user role in the REST API.

To disable the drill-to-anywhere option:

  • In the widget menu, deselect the Enable Drill to Anywhere option.

As a result, the Choose Another… option is removed from the widget’s Drill options.

The left image below displays the widget with the option to drill to anywhere. The image on the right displays the widget with only predefined drill hierarchies.