Filter Drill Down Fields Per Widget

Introduction

We will introduce how to filter, drill down fields on a widget basis.

Steps:

Step 1:

Download the attached plugin and place in .../PrismWeb/plugins, if plugins folder does not exist please create it. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder.

Step 2:

Go to the widget script of the widget you want to apply the filtering on and add the following script, describing which fields you want to remove or keep:

var fieldsToKeep = ['[Annual Performance.OrderYear]', '[Orders.CustomerID]', '[Products.ProductName]'];
var fieldsToRemove = [];
prism.FilterDrillDownFieldsPerWidget(widget, fieldsToKeep, fieldsToRemove);

step 3:

refresh the page

Example:

To remove the drill history for good (it will never appear) we can use dashboard script:

dashboard.on('domready', function(d,e){
_.each(d.widgets.$$widgets, function(widget){
if(widget.metadata.drillHistory != undefined){
delete widget.metadata.drillHistory;
}
})
})