Adding Drill Hierarchies to Widgets

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 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.
    Note: 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: