MARKETPLACE
Filtered Measure
By Sisense
- Widgets
This add-on is pre-installed on Sisense in Linux environments and its version could be different. The download link is for Sisense on Windows.
By default, filter selections in Sisense can be defined on the dashboard or widget level. The Filtered Measure add-on makes it possible to create additional selection states. This means that you’re able to show two (or more) different sets of selections in a single widget.
This feature is useful when you want to perform comparative analysis. For example, an eCommerce agency needs to create a dashboard that provides sales analysis across years. One of the main purposes of the dashboard is to compare sales of their categories in different years. To provide side-by-side comparisons that analysts can change dynamically, you can create two different filters: Year 1, and Year 2. These filters will represent two different year selections that can be changed by the user.
To install the Filtered Measures add-on:
- If you’re running Sisense on Windows:
- Download the attachment
- For windows: xtract the .zip folder into the plugins folder. If the folder does not exist, create it prior to extracting the .zip file.
For V7.1 and earlier: C:Program FilesSisensePrismWebplugins
For V7.2 and later: C:Program FilesSisenseappplugins - After those files have been unzipped there, you may also have to restart the web server.
- If you’re running Sisense on Linux, this add-on is pre-installed, so you can just enable it in the Admin – Add-ons section.
- Open your data model in the Data tab and duplicate the field that you want to perform a comparative analysis on. For example, duplicate the Date field within the ElastiCube to compare values for two years. Name the new field Date2
- Add two dashboard filters for the fields created in the previous step
- Create a pivot table that calculates Total Cost per Category and apply the dashboard filters created in the previous step. Duplicate a Total Cost measure. You should have something similar to this
- In the Total Cost formula editor, add the Years in Date field to the formula.
- Change the name of the field to the name of the required filter (that is, the one you want to affect the value) and add ‘@’ symbol before it. In our case it will be “@Year 1”
- Rename the field with a meaningful name (for example: Year1 Cost).
- Repeat the steps 6-8 for the second measure item – Total Cost (1) but for the Date2 field filter
- Now the “Year1 Cost” column is affected by the “Year 1” filter and “Year2 Cost” column is affected by the “Year 2” filter.
This is a free add-on. Click here to download.