Adding a new KPI to a KPI chart
A single KPI chart can display several KPIs. Which performance values that are displayed in the KPI tiles can differ from KPI to KPI. When adding a new KPI to a KPI chart, you define which values to monitor in the tiles, and for which categories.
The values of a KPI are displayed in tiles, where each tile represents a certain category (New York in this example) .
- display a primary value, which shows the most recent measure of a certain factor (a). What is measured is displayed beneath the value.
- display a comparative value, to which the primary value is compared or evaluated (b). Examples are comparisons of the actual value to a target, or to a corresponding value for another time period. What is measured is displayed also here also.
- use colors of the tile backgrounds to indicate the current performance level (c). Rules for the coloring can be set up. They can, for example, contain threshold values against which the current primary value is valuated. Depending on the results of the evaluation, the tile backgrounds are colored differently.
- display a sparkline that shows the primary value over time (d). The dot ending a sparkline indicates the current value. The sparklines can be supplemented with a scale showing the vertical range.
Right-click a KPI in the KPI chart, and select
Properties in the opened menu.
The Properties pop-over for the selected KPI is displayed. In the side panel, the current KPI is highlighted.
At the bottom of the side panel, click
Add new KPI.
The new KPI is added to the chart. In the side panel, the new KPI is highlighted.
In the pop-over, select
The Values section is shown.
Value (y-axis), specify what to be calculated and displayed as the primary value in the tiles. You can
The result of the calculation for the most recent time period is displayed as the primary value in the tiles. For time period, see the Time setting in the next step.
- select a column and an aggregation in the column selector.
- right-click the column selector and click Custom expression. This opens a dialog where you can type your own expression.
Time (x-axis), select the column or hierarchy to use for defining the time periods.
The displayed primary value is the result for the most recent time period of the periods you have defined.Tip: To show the time period in the tile, select the Show time in tile check box beneath the Time axis. To indicate the development of the primary value over all the time periods, sparklines are used.
Tile by, select the column that specifies which categories the tiles should represent.
The categories are displayed at the upper left of the tiles.
Comparative value, use any of the options described in
Step 4 to specify what the primary values should be compared to.
The result for the most recent time period is displayed as the comparative value in the tiles.
If you want to use colors for indicating performance, select
Colors in the pop-over.
The Colors section is shown. The default colors of the tile backgrounds reflect the primary values, and a gradient color transition is used.
- On Color by, use any of the options described in Step 4 to specify what calculation the coloring of the tile backgrounds should be based on.
To let background colors of the tiles indicate performance levels in a different way, click
Add color rule.
The Add color rule dialog is displayed.
- In the dialog, add color rules that control how visualization items should be colored.