KPI

The KPI visualization can show one or two measure values, and is used to track performance.

Default settings for a KPI visualization

The following settings are used by default in a KPI visualization:

• Centered alignment.
• Black text color.
• Medium font size.
• No titles.
• Measure label displayed.
• Conditional colors and symbols are turned off.
• No link to sheet.

Conditional colors and symbols

When you use conditional colors for your KPI visualization, you have the option to use symbols to be displayed next to your measure value. Additionally, you can use the following options:

• Set range limits.
• Add limits to create subsections with different colors to indicate performance, for example, good (green), below expectations (yellow), or critical (red).
• Add symbols to the values.
• Use gradient coloring between color sections.

You can use expressions to set the limits. All these settings are done in the properties panel that is displayed on the right-hand side of the window when editing a sheet.

Measures and dimensions

In a KPI visualization, you can have one or two measures and no dimensions.

You can add a second measure value either by dragging it from Fields or Master items in the assets panel, or by clicking Add measure in the properties panel. With two measures, the second value automatically becomes a complementary value and is shown with a smaller font size. You can easily switch their order by dragging the measures in the properties panel under Measures.

Link to sheet

You can link from the KPI visualization to a sheet in the app. When making data analysis and clicking the visualization, you can click a second time to go to a predefined sheet. The sheet is opened in a new tab. When hovering over ], the name of the sheet is displayed. The icon is only displayed when Show title is selected, under Presentation.