cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
Version: 1.1
Introduction
As an Admin or a Data designer you might ran into cases where you would like to limit the data if there is a small enough sample size to where it could impact compliance or confidentiality.
An example could be a use case for patient confidentiality in HR platforms. So being able to look at your entire employee base and the their health conditions but not filters the criteria to too small of a data set so that you could in essence guess at who the person with the conditions would be.
 
Purpose/Benefits
Using this plugin you can easily limit the data for a specific Elasticube\Table\Column as defined in the configuration file on a System level.
The below example will limit the data behind the Column Chart to only cities that sold more then 20 products.
How to Install and Configure the Extension

Step 1 - Add The Plugin
Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ folder. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. If the plugins folder doesn't exist, just create it. After those files have been unzipped there, you may also have to restart the web server.
Step 2 – Configure the Plugin
Open up the config.js file, and edit the prism. queryFilter object. This object contains one or more Elasticubes to be affected by the plugin, and each Elasticube has an array of fields to be filtered.
  • table - will define the table name
  • column - column name to act as a filter
  • agg - aggregation type (can be count,countduplicates, sum, min, max, avg, median)
  • filter - set the threshold condition 
For the below use case, we are limiting the count of "ProductID (1)" field to a result set of less then 25 
Step 3 – Create Your Dashboard
Create your dashboard widget and include the measure that is being filtered. The plugin will automatically filter the data before it reached the widget.
References/Notes
  • This plugin is setup to only be applied when using the Elasticubes, Tables, and Fields defined within the configuration file.  If you change the name of the Elasticube or Table(s), you will need to update the config.js file.
Version history
Last update:
‎03-02-2023 09:50 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy