cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
Download: Filter Measure
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:
  1. Comparison between dimensions (Time, Agent, Product, Etc..)
  2. 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"]});
Version history
Last update:
‎03-02-2023 09:25 AM
Updated by:
Contributors
Community Toolbox

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

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: