Download: Filter Drill Down
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);
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;
}
})
})
_.each(d.widgets.$$widgets, function(widget){
if(widget.metadata.drillHistory != undefined){
delete widget.metadata.drillHistory;
}
})
})
