Download: Percent Rank
Introduction
The following article describes steps needed in order to add a 'Percent Rank' functionality to a numeric field in a chart widget.
Purpose/Benefits
The percent rank function can be used to evaluate the relative standing of a value within a data set.
The percent rank formula:
Exmple:
Steps
The following steps will walk through the process of adding the 'percent rank' functionality.
STEP 1 - ADD THE PLUGIN
Download the attachment and unzip the contents into your C:\Program Files\Sisense\plugins\ folder. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder.
If the plugins folder doesn't exist, just create it. After those files have been unzipped there, you may also have to restart the web server.
STEP 2 - USE PERCENT RANK FUNCTION
Hover and click on the menu icon of an numeric field in the data panel of the chart widget designer. For an aggregated value, select 'Quick Functions'->'Percent Rank' from the menu. For non-aggregated value, select 'Percent Rank'.
For aggregated values:
for non-aggregated values
Note: After choosing the 'Percent Rank' function, the format number will automatically change to 'Percent'.
Note: The 'Percent Rank' function is available only for widgets of types: 'Line Chart', 'Column Chart', 'Area Chart', 'Bar Chart', 'Pie Chart', 'Polar Chart' and 'Scatter Chart'.
