Filtered Measure

To install the Filtered Measures add-on:

1. If you’re running Sisense on Windows:
   1. Download the attachment 
   2. 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
   3. After those files have been unzipped there, you may also have to restart the web server.
2. 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.
3. 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
4. Add two dashboard filters for the fields created in the previous step
5. 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
   
6. In the Total Cost formula editor, add the Years in Date field to the formula.
   
7. 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”
   
8. Rename the field with a meaningful name (for example: Year1 Cost).
   
9. Repeat the steps 6-8 for the second measure item – Total Cost (1) but for the Date2 field filter
   
   
10. 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.