Creating KPIs

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

You can create a KPI visualization on the sheet you are editing.

In a KPI visualization, you can have one or two measures and no dimensions. 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.

When you have created the KPI visualization, you may want to adjust its appearance and other settings in the advanced edit mode properties panel.

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

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

Using conditional colors and symbols

You can set your KPI visualization to display in different colors, and with different symbols, depending on the value of the selected measure. Conditional colors and symbols can be configured in the properties panel.

You can do this by adding multiple range limits to the KPI, creating subsections that indicate performance. For example, you can set your KPI so that it displays in:

• Green with a check mark symbol when performance is strong.

• Yellow with a caution symbol when performance falls below expectations.

• Red with an X symbol when performance is low.

You can also set range limits with expressions, rather than defining a single value.

For more information, see Using conditional colors in KPIs.

Do the following:

1. Select a KPI visualization, and switch to the properties panel in the advanced edit mode.

2. Select Appearance and expand Color.

3. If necessary, turn off Library colors and turn on Conditional colors.

4. Click Add limit to create a new limit. Multiple limits can be added to a single KPI chart.

5. Specify a value for the limit, or enter an expression using the expression editor.

6. On the Value color bar, click the range area of the KPI you would like to modify.

7. Under Colors, select a preset color or use a custom color. Toggle, if needed, to Symbols to choose the symbol displayed when your KPI falls within the specified limit.

Linking to another 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.