Add Image Indicator to a Pivot Table

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

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:

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.

PivotIndicator.dash

Updates:

05/06/2018 : Added menu item and fixed issues with multiple indicators

Lucas Soo Hoo September 14, 2015 20:58

I am not finding a PivotIndicator folder to download. Also, once those thresholds are set in the default, can they be changed for individual widgets, or do they have to stay with whatever is set on the default for all of them?

Inbal March 08, 2016 13:03

Dear Lucas,

The plugin has just been updated and now you can choose different treshold for each column.

Please delete the old plugin from the plugin folder and download the new one.

Best Regards,

Inbal

Adi Hecht September 28, 2017 19:23

Is there a way to add indications based on a formula, specifically based on rank? for example a gold medal for to agent by sales, silver medal for 2nd agent, bronze for 3rd, and no medal for the rest?

OJ Chakrabarti August 13, 2018 09:51

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

Jim Thomas October 24, 2018 18:05

I agree it would be great to be able to do indications based on a formula.

Regards, Jim

Sean Coughlan April 01, 2019 10:28

It would be great also to have the ability to change the colour of the arrow indicators.

David Rogers June 03, 2019 15:49

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.