Drilling and Filters interaction

Download: Drilling and Filters Interaction

Introduction

In Sisense, we have a drilling functionality which lets the user jump from one dimension to another base on his selection. He can mark several or specific values and drill into another dimension.

The out of the box drilling functionality filters internally the widget based on the selected values and doesn't update the last level in the breadcrumbs with the selected values. i.e -

This plugin lets the user drill into selected items and while drilling, affects the dashboard filters and vice versa - when changing a filter's values, it will be reflected inside the breadcrumbs - even on the last level.

Implementation:

Step 1:

Download the attached .rar file.

Extract the .rar file to the following path: "[Sisense installation path]\PrismWeb\Plugins". If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. If the plugins folder does not exist, please create it.

Step 2:

Create a widget that allows the drilling option (column chart for example) and choose dimensions and measures.

Now, try to drill into specific items by clicking/marking the column/s and choose the dimension to drill into. You should see the chosen dimension as a dashboard filter with the selection you have made.

If the dashboard already has a filter on the selected dimension, it will be updated with your new selection. Otherwise, a new filter will be created with your selection.

Example:

The below screenshots describes a flow of using this functionality:

1.2.