Download: Limited Data Return Widget

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.