*This plugin is officially supported by Sisense. You can find the latest version of this plugin on the Sisense Add-Ons page.
By default, filter selections in Sisense can be defined on the Dashboard OR Widget level. The “parameters” plugin is a functionality that 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 very handy when you want to perform comparative analysis. With the use of this plugin, two selections can be shown in a single view – which makes it easier for us to compare the two.
This functionality should be used with caution as it can cause great confusion with end-users as there is no automatic on-screen indication that fields or values are in. It is up to the Sisense contributor to provide this information to the consumer adding informative description to the widget.
An eCommerce agency needs to create a dashboard that provides sales analysis across years. One of the main purposes of this dashboard will be to compare sales of their categories in different years. In order to provide side-by-side comparisons that the analysts can change dynamically, we will need to create two different filers: Year 1, and Year 2. These filters will represent two different year selections that can easily be changed by the user.
Step 1 - Download the Filered Measures plugin here and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ (Sisense 7.1.3 and below) or C:\Program Files\Sisense\app\plugins (Sisense 7.2+). If the plugins folder doesn't exist, just create it.
Step 2 - Create a duplication of the Date field within the ElastiCube
Step 3 - Use the 2 date fields you’ve created and create Year 1 and Year 2 filters within the dashboards:
Step 4 - Create a pivot table that calculates Revenue per Category, make sure it's connected to Dashboard filters:
Step 5 - Go the the Revenue formula editor and add the “Years in Date” field to the formula:
Step 6 - Change the name of the field to the name of the required filter (=the one you want to affect the value) and add ‘@’ symbol before:
Step 7 - Rename the field to meaningful name (for example: Year 1 Revenue)
Step 8 - Repeat steps 5-7 for “Year 2”:
Step 9 - Now “Year 1 Revenue” if affected by "Year 1" filter and “Year 2 Revenue” if affected by “Year 2” filter
Step 10 - In order to create Growth calculation, simply use the following syntax:
Step 11 - Once you create the Growth measure, you can use it in a numeric indicator and bar chart (ecdata and dash file can be found here filteredMeasure_Example.zip)
March 12th - updated the plugin to support version 7.0.1, including:
- Auto Sync of all filters for a specific measure using the measure menu button and clicking the option "Sync Measure with filters" - automatically adds all filters to the measure and adds a prefix of '@'
- Auto Sync of all filters with all measures in the widget using the widget menu button (editor page) and clicking the option "Sync dashboard filters with measures" - automatically adds all filters to all measures and adds a prefix of '@'
- Support in Prev Year/s, Just rename the field (in the formula) to '@.PREV.[filter name]' or to '@.PREV.[number].[filter name]' to get results of the previous [number] of years
- Support for cascading filters
Please sign in to leave a comment.