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

Creating a KPI

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

Grid KPI add

Configuring a KPI

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

Grid KPI configuration
  • 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

Value Types

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

Grid KPI Type

Actual Variation

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

Calculation = Value - Target

Actual Value

Shows as a single value the Actual Value itself

Calculation = Value

Percentage of Variation

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

Calculation = 100 * (Value - Target) / Target

Percentage of Target

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

Calculation = 100 * Value / Target

Value and Percentage

Shows 2 values in the cell :

  • Actual Variation
  • Percentage of Variation

Result interpretation

The font and symbol of the KPI has a color :

  • green for “good”
  • red for “bad”

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

Grid KPI direction

Style : background

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 :

Grid KPI Delta Background

Style : Bar chart

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

Grid KPI Bar

Grid KPI Bar runtime
Last modified: Sep 13, 2021


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment