Grid KPI

Introduction

A KPI Expression (a new calculated column) can be generated to show how a value deviates from a target.

To create a KPI, navigate under section Column Settings near the list of KPI Expressions and click the + icon :

In the KPI Column Configuration dialog that appears, you can configure the KPI :

Actual Value : the column that contains the value you want to track
Target Value : the column to which you want to compare the Actual Value
Value Type : what type of calculation is made to show the deviation
Result : should we consider higher values as a good thing (green) or not (red)
Visual : do we want to visualize the value as a number or a bar graph
Delta Background : do we want to apply conditional color to the numbers or to the cell background

Click to select a Value Type : what type of calculation is made to show the deviation :

Shows as a single value the difference between the Value and the Target.

Calculation = Value - Target

Shows as a single value the Actual Value itself

Calculation = Value

Shows as a single value the % of variation to target.

Calculation = 100 * (Value - Target) / Target

Shows as a single value the % of value to target.

Calculation = 100 * Value / Target

Shows 2 values in the cell :

The font and symbol of the KPI has a color :

You can define high values as being “good” or “bad” using the Result configuration :

By default, the good/bad color is applied to the font, and the cell is white.

This can be configured as the opposite, for better visibility. Check Delta Background :

Instead of showing the value as a number, the Actual Value calculation can be displayed as a Bar chart by selecting the appropriate Visual :

Last modified: Sep 13, 2021