Filter drill down fields per widget
Download: Filter Drill Down
Introduction
We will introduce how to filter, drill down fields on 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 apply it on dashboard basis you can have a look at this: https://support.sisense.com/entries/52397100-Filter-drill-down-fields
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;
}
})
})
Good Luck!
The plugin was updated to work on version 6.5
-
Tried this . Got the Plug-in but did not work.
//Script to disable "Drill-into" functionality on a specific widget
//This will work only if there is no script related to Drill-into at the Dashboard level
prism.disableDrillDown(widget);
*/
var fieldsToKeep = [];
var fieldsToRemove = ['[Revenue_Detail.ProjectNumber]'];
prism.FilterDrillDownFieldsPerWidget(widget, fieldsToKeep, fieldsToRemove);I have 8 tables in the elasticube. How do I not show 7 tables and display certain columns in one table?
Please sign in to leave a comment.
Comments
5 comments