Dashboard viewers have the option to drill down in a widget, 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 a designer, you can add predefined drill hierarchies to widgets.

Note: Your Sisense administrator must first create the drill hierarchies before you can select and add them in the widget designer. Click here to learn more.

To enable drill hierarchies in a widget:

  1. In the Widget Designer, click on the menu of the value (dimension), and select Hierarchies…
  2. Select the checkboxes next to the drill hierarchies that you want to make available to dashboard viewers.
    Note: Hierarchies with a lock icon will always appear in the widget. To unlock this option, please contact your Sisense administrator.

drill flow 2

Disabling the Drill to Anywhere Option

As a designer, 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.

disable drill