QPR ProcessAnalyzer KPI Card: Difference between revisions
Line 15: | Line 15: | ||
# Select the KPI Card as a visualization. | # Select the KPI Card as a visualization. | ||
# Define your KPI as the first measure. | # Define your KPI as the first measure. | ||
# For the measure, select '''Variable for other measures''' in the measure settings. | # For the measure, select '''Variable for other measures''' in the measure's '''Advanced settings'''. | ||
# Select '''Data point colors''' as the second measure, and define the limit values between green-yellow and red-yellow. | # Select '''Data point colors''' as the second measure, and define the limit values between green-yellow and red-yellow. | ||
Revision as of 09:57, 9 September 2020
KPI Card shows a single measure value. In addition to the value, the measure label is shown. Measure value color, title color and background color can be changed. Optionally, the measure can be visualized with an icon shown left side of the measure. The icon type and color can be customized.
KPI Card Functionalities
The KPI card has the following functionalities:
- KPI is able present a single measure value (which is set in the first measure).
- Color of the icon can be set either using the second measure or with the conditional formatting (if both are defined, the second measure is used).
- Color of the shown measure value can be changed using the measure color (in the measure's Advanced Settings).
- Conditional formatting allow to determine measure value color, title color, background color and the icon color (for more information, see Conditional Formatting).
- Appearance of the shown value can be changed in the first measure settings, using settings Round to decimals, Measure unit, Data type and Date format.
- Title of the measure can be changed either by specifying a custom measure label in the measure advanced settings or use the title field in the General tab.
- It's possible to define a dimension, which will show measure values for all those dimension values as a list.
Set Icon Color Using Second Measure
Icon Color can be set either using the seconds measure or the conditional formatting. To use the second measure, follow these steps:
- Select the KPI Card as a visualization.
- Define your KPI as the first measure.
- For the measure, select Variable for other measures in the measure's Advanced settings.
- Select Data point colors as the second measure, and define the limit values between green-yellow and red-yellow.
Now the KPI targets are visualized as a colored icon next to the KPI value.
Conditional Formatting
The following conditional formatting are available:
- backgroundColor: Background color of the KPI Card. Configured similarly than in table conditional formatting.
- textColor: Text color of the KPI Card. By default #0f2975 (dark blue). Configured similarly than in table conditional formatting.
- icon: Icon type that is shown left of the measure value. Configured similarly than in table conditional formatting. If only icon color is defined, the default square icon is used.
- color: Color of the icon. Configured similarly than in table conditional formatting. The icon color can also be set using the second measure (for more information, see Visualize KPI Targets with Colors).
- title: Settings related to the measure title (label). Currently, only the title color can be changed.
- color: Color of the measure title (label). By default #4f5765 (grey).
It's also possible to define a dimension for the KPI Card, which shows a list of measure values for each dimension.
Conditional Formatting Examples
Title color:
{ "title": { "color": { "rules": [ { "value": 100, "comparison": ">", "color": "#36d475" }, { "color": "#EF5254" } ] } } }
Icon and its color:
{ "icon": { "rules": [ { "value": { "type": "measure", "index": 2 }, "comparison": ">", "icon": "arrow_upward" }, { "icon": "arrow_downward" } ], "color": "#069cf0" } }