Filter Measure

[intapiuser]

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"]});

FilterMeasurePost.dash