cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
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;
        }
    })
})

Rate this article:
Comments
TJT
7 - Data Storage
7 - Data Storage

Is It Possible to hide Drill hierarchy for dates too.

 

TJT_0-1680188544951.png

 

Version history
Last update:
‎03-02-2023 09:19 AM
Updated by:
Contributors