Filter drill down fields per widget

Follow

Eli

February 23, 2015 10:38

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

0

• 

  shilpa March 03, 2015 19:00

  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?

   

   

  0

  Comment actions Permalink
• 

  Tony Fonager March 06, 2018 16:13

  Seems like this is not in 6.7.1.15016

  Any updated versions of the script ?

  0

  Comment actions Permalink
• 

  support cessoftware March 21, 2018 12:03

  This plugin does not work with version 7.0.2.11001, when trying to use the field selector during editing of widgets, the field selector box does not populate.

  0

  Comment actions Permalink
• 

  Graeme Davidson May 22, 2018 08:13

  Hi, I can't get it to work, but I may be doing something wrong.  Also, I don't want to permanently remove the filters.  just remove them now, so that the next time they use them it will be the correct filters.

   

  

  0

  Comment actions Permalink
• 

  Samuel Mendu March 19, 2019 18:42 (Edited March 19, 2019 19:01)

  Plug In is not working for date-time fields

  0

  Comment actions Permalink

Please sign in to leave a comment.