Add Image Indicator to a Pivot Table
Download: Image Indicator
Introduction
Adding Visual images improves dashboard visuality and comprehension.
Pivot tables could be hard to read in large scales and the Pivot Indicator Plugin assists in the table comprehension.
Business Usage
A great use of this plugin is when there is a need to differentiate between values in the same column or between data columns.
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:
Download and extract the enclosed folder into the plugins folder:
C:\Program Files\Sisense\PrismWeb\plugins\PivotIndicator, if the "plugins" folder does not exist, please create it. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder.
Step 2:
Default Parameters value:
"arrowsThreshold":0,
"rangeThresholdMin": 500,
"rangeThresholdMax": 1000
Define Indicator Parameters value in the configuration file:
C:\Program Files\Sisense\PrismWeb\plugins\PivotIndicator\config.js
Right click on the file and edit with notepad++
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 treshold:
defaultThreshold: {
"arrowsThreshold":0,
"rangeThresholdMin": 500,
"rangeThresholdMax": 1000
}
};
Example 2 - with custom treshold (The example dimetions are taken from the sample ecommerce cube):
defaultThreshold: {
"arrowsThreshold":0,
"rangeThresholdMin": 500,
"rangeThresholdMax": 1000
},
"dimensionsThreshold":{"[Commerce.Cost]": {
"arrowsThreshold": 200,
"rangeThresholdMin": 50,
"rangeThresholdMax": 500
},"[Commerce.Revenue]":{
"arrowsThreshold":200,
"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
Arrows - contains 2 arrows Up and Down.
The parameter arrowsThreshold defines the arrows threshold.
Step 3:
Edit Pivot table.
In edit mode right click on one of the values -> Add Indication and choose the Indication you would like to add.
Example
In the Image above (example .dash file attached) the parameter configuration is the default configuration:
"arrowsThreshold":0,
"rangeThresholdMin": 500,
"rangeThresholdMax": 1000
The Pivot presents the Total Cost and Total Revenue by Brand.
The Total Cost has a Red-Yellow-Green Indicator. Value below 500 receive Red Light, values between 500 and 1000 (include those values) receive Yellow Light and values above 1000 receive a Green Light.
The Total Cost has an Arrows Indicator. Values equal or lower than 0 received a red arrow and values above 0 receive blue arrow.
Updates:
05/06/2018 : Added menu item and fixed issues with multiple indicators
-
Hi
These are great but is it possible to have an indicator to show if the two values have decreased or increased?
There is one for the indicator widget as you know the two values
// Define threshold var threshold = 0; // Get the indicator's value var value = e.widget.queryResult.value.data;
Would be great to be able to the same in the pivot if you can define the two columns to compare?
Thanks
Lisa
-
It would also be useful to have the indicator reflect the value of another field. For example, We have a Turnover field, and a set of Turnover thresholds. We want to display the Turnover value and display the indicator based on the value relative to the thresholds e.g. Gold if Turnover < 7% (the top threshold value for Turnover). The thresholds are different for each field.
Please sign in to leave a comment.
Comments
9 comments