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:
- Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ folder. If the plugins folder doesn’t exist, create it. After those files have been unzipped there, you may also have to restart the web server.
- In the ElastiCube Manager, 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.
- In the Sisense Web Application, add these duplicated fields created in the previous step as filters, for example, if you are using dates, you can create filters as Year 1 and Year 2. To learn how to create filters, click here.
- Create a pivot table that calculates Revenue per Category and apply the dashboard filters created in the previous step.
- In the Revenue 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.
- Rename the field with a meaningful name (for example: Year 1 Revenue).
- Repeat steps 5-7 for Year 2. Year 1 Revenue column is affected by the Year 1 filter and Year 2 Revenue column is affected by the Year 2 filter.
- To create a Growth calculation, simply use the following syntax: Once you create the Growth measure, you can use it in a numeric indicator and bar chart.
This is a free add-on, click here to get it now.