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?
-
As suggested in the post, I want to apply this from the dashboard level so it is automatically applied to all widgets. The link in the post does not work though. this is what I've got in my dashboard script but it's not working
_.each(prism.activeDashboard.widgets.$$widgets, function(widget){
var fieldsToRemove = ['[timesheet details.Revenue]', '[timesheet details.Net Savings]'];
var fieldsToKeep = [];prism.FilterDrillDownFieldsPerWidget(widget, fieldsToKeep, fieldsToRemove);
});It works fine on an individual widget though but some dashboards have 8 widgets on them
Please sign in to leave a comment.
Comments
6 comments