cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member

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
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

    }
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

    }}
 
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:

  1. Export Pivot PDF includes the figures but not the indicators.
Rate this article:
Comments
JSobkowiak
7 - Data Storage
7 - Data Storage

Is it possible to configure the figures and indicators to appear on PDF either in the config file or script in the widget?

Version history
Last update:
‎03-02-2023 09:06 AM
Updated by:
Contributors