Introduction
This article will explain how to disregard a widget from a certain filter + the ability to define a specific measure to be affected by this filter
Business Case
Having only a specific measure to be affected by a filter can be useful in cases such as:
- Comparison between dimensions (Time, Agent, Product, Etc..)
- Keeping fields with no values in a widget when filtering the dashboard
Steps
STEP 1 - DOWNLOAD AND EXTRACT THE ENCLOSED FOLDER IN THE PLUGINS FOLDER:
C:\Program Files\Sisense\PrismWeb\plugins\filterMeasure, if the "plugins" folder is not there, 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 - CREATE THE WIDGET IN WHICH YOU WISH APPLY THE FILTER MEASURE
Step 3 - Go to the widget’s script and copy paste the following code
prism.filterMeasure({
widget: widget,
filters: ["<Filter Name>"],
measures: ["<Measure Name>"]});
- in filter, place the filters you wish to exclude from affecting the widget (filters names as they appear in the dashboard)
- In measures, place the measures you do want to be affected (measures names as they appear in the widget)
Step 4 - Save the script, refresh the widget and click “apply”
Example - Comparing between two date ranges
- Create an additional date field (custom field)
- Place the to date fields as filters in the dashboard
- Create two revenue measures (in a widget), and name them differently
- Apply the following script (modify the filters & measures)
prism.filterMeasure({
widget: widget,
filters: ["Date1"],
measures: ["Revenue in Date1"]});
prism.filterMeasure({
widget: widget,
filters: ["Date2"],
measures: ["Revenue in Date2"]});
