Pivot2: "Add Image Indicator To A Pivot Table" Re-Implemented
Introduction
Adding a visual representation to your measures will allow you to read the bigger picture in a glance, recognize trends and have better user engagement to your dashboards.
Comparing data columns or even different values within the same column could be confusing and overwhelming in a table full of numbers, this plugin allows you to see the big differences quickly before you dive into the numbers.
Business Usage
Comparing values in the table to a predefined threshold and to each other helps you to get a clear picture when analysing performance measures.
The Pivot Indicator Plugin works only in pivot tables on numeric values.
Steps
In order to add The Pivot Indicator Plugin to a widget, please follow the listed steps below:
STEP 1 - INSTALL THE PLUGIN
- Download the latest version of the plugin from this link and extract the enclosed folder into the plugins folder:
/opt/sisense/storage/plugins/
STEP 2 - SETUP CONFIGURATION FILE
Define Indicator Parameters value in the configuration file:
/opt/sisense/storage/plugins/Pivot2IndicatorPlugin/config.js
Default Parameters value:
"arrowsThreshold":0,
"rangeThresholdMin": 500,
"rangeThresholdMax": 1000
"rangeThresholdMin": 500,
"rangeThresholdMax": 1000
You can also define a different treshold for each column in the pivot by the dimension.
In order to do so take out the dimentionsThreshold function from remark and change the dimention you'd like to add.
Example 1 - without custom threshold:
defaultThreshold: {
"arrowsThreshold":0,
"rangeThresholdMin": 500,
"rangeThresholdMax": 1000
}
"arrowsThreshold":0,
"rangeThresholdMin": 500,
"rangeThresholdMax": 1000
}
Example 2 - with custom threshold (The example dimensions are taken from the sample ecommerce cube):
defaultThreshold: {
"arrowsThreshold":0,
"rangeThresholdMin": 500,
"rangeThresholdMax": 1000
},
"dimensionsThreshold":{
"[Commerce.Cost]": {
"arrowsThreshold": 200,
"rangeThresholdMin": 300,
"rangeThresholdMax": 2000
},
"[Commerce.Revenue]":{
"arrowsThreshold":0,
"rangeThresholdMin": 50,
"rangeThresholdMax": 200
}}
"arrowsThreshold":0,
"rangeThresholdMin": 500,
"rangeThresholdMax": 1000
},
"dimensionsThreshold":{
"[Commerce.Cost]": {
"arrowsThreshold": 200,
"rangeThresholdMin": 300,
"rangeThresholdMax": 2000
},
"[Commerce.Revenue]":{
"arrowsThreshold":0,
"rangeThresholdMin": 50,
"rangeThresholdMax": 200
}}
Traffic Light
Contains 3 Traffic Lights: red, yellow and green .
Traffic Light Indicator has 2 parameters in configuration: rangeThresholdMin and rangeThresholdMax
Red traffic light: value < rangeThresholdMin
Yellow traffic light: value >= rangeThresholdMin AND rangeThresholdMax => value
Green traffic light: rangeThresholdMax <= value
Arrows
Contains 2 arrows: Up and Down.
The parameter arrowsThreshold defines the arrows threshold.
Arrow up: value > arrowsThreshold
Arrow down: value <= arrowsThreshold
STEP 3 - IMPLEMENT IN PIVOT:
- Edit a Pivot table.
- In edit mode right click on one of the values -> Add Indication and choose the Indication you would like to add.
Notes:
- Export Pivot PDF includes the figures but not the indicators.
Updated 03-02-2023
