- Release notes
- Before you begin
- Getting started
- Integrations
- Working with process apps
- Working with dashboards and charts
- Working with process graphs
- Working with Discover process models and Import BPMN models
- Showing or hiding the menu
- Context information
- Export
- Filters
- Sending automation ideas to UiPath® Automation Hub
- Tags
- Due dates
- Compare
- Conformance checking
- Root cause analysis
- Simulating automation potential
- Starting a Task Mining project from Process Mining
- Triggering an automation from a process app
- Viewing Process data
- Creating apps
- Loading data
- Customizing process apps
- Publishing process apps
- App templates
- Additional resources
Metrics
Metrics are used to define a calculation once and reuse it in the entire app. For example, you can make a metric to calculate the number of invoices , or a metric to calculate the average amount. You can further reuse these metrics in different charts.
You cannot preview or publish the app when adding or editing metrics.
Follow these steps to edit a metric.
- In the Data Manager panel, locate the metric you want to edit and select the Edit icon.
The Edit KPI window is displayed.
-
Edit the display name for the metric in the Metric name field and/or configure the rules for the metric.
-
If applicable, add or change context metrics.
- Select Save.
If the metric you want to use is not available by default, you can create new metrics that can be used in your dashboards.
Follow these steps to add a new metric.
-
In the Data Manager panel, select +New metric.
The Create KPI dialog is displayed.
-
Enter a descriptive name for the new metric in the Metric name field.
Tip:It is a good practice to refer to the type of function you use to calculate the metric.
-
Configure the rules that define the metric.
Tip:A preview of the metric calculation is displayed in the Create KPI panel.
-
If applicable, select one or more context metrics.
-
Select Save.
The metric is added to the list of metrics in the Data Manager.
You can add context metrics to provide a better understanding of the main metric displayed on the chart. Context metrics are displayed as tooltips on charts.
Average amount
, useful context is Number of cases
for which the average amount is calculated. This also applies when you main metric is defined as Total amount
. In this case, also Number of cases
for which the sum is calculated is a useful context.
Cases with tag (%)
, useful contexts can be Number of cases with tag
and Total number of cases
.
The following table shows some examples of main metrics with relevant context metrics.
Main metric |
Context metric 1 |
Context metric 2 | |
---|---|---|---|
Count |
Number of cases
|
- |
- |
Average |
Average amount
|
Cases
|
- |
Sum |
Total amount
|
Cases
|
- |
Percentage |
Cases with tag %
|
Cases with tag
|
Total cases
|
Below is a description of the elements a rule.
Element |
Description |
---|---|
Aggregation type | The type of the function that is used to calculate the metric. For example, SUM is used to calculate a Total value, AVERAGE is used to calculate an Average value.
|
Field used for aggregation | The field that is used to calculate the metric. |
Aggregation type
Below is an overview of the aggregation types available for configuring a rule.
Aggregation type |
Returns |
Field types allowed |
|
N/A |
all |
|
a constant |
number, currency, percentage |
Distinct count | the number of unique values for the selected field |
all |
| the number of values for the selected field |
all |
| the sum of all values for selected field divided by the number of cases | number, duration
, currency |
| the sum of all values for selected field divided by the number of records in the table of the selected field |
number, duration |
| the smallest value for the selected field | number, duration
, currency |
| the largest value for the selected field | number, duration
, currency |
| the percentage of TRUE values for the selected field
|
boolean |
Sum | the sum of all values for the selected field | number, duration
, currency |
| the k-th percentile of the values for the given field
| number, duration
, currency |
| the median of the values for the given field. | number, duration
, currency |
Using static values
In stead of an aggregation type, you can select to use a constant value to calculate the metric. If you select the Input value option from the list of aggregations, you can enter a value and select the field type.
Follow these steps to configure a rule.
-
Select the function that you want to use to calculate the metric from the Aggregation types list.
Tip:You can start typing the aggregation type and select Enter. - Select the field that you want to use to calculate the metric from the Field used for aggregation drop-down list.
Note:
The Field used for aggregation drop-down list only contains fields that are applicable for the selected aggregation type.
-
If desired, apply filters to the values that should be considered for the evaluation of the aggregation used for the metric.
-
Select Save in the Create KPI panel.
Repeat these steps if you want to add another aggregation for the rule.
You can add up to two aggregations to define the rule. If you define two aggregations for the rule these will be evaluated as a division. In this case, you can select to display the results as a percentage value.
Using multiple aggregations in a rule
You can add up to two aggregations to define the rule. If you define two aggregations for the rule, you can select the operator to be used to evaluate the rule. Below is an overview of the available operators.
Operator |
Description |
+ |
addition |
- |
subtraction |
x |
multiplication |
/ |
division* |
The result type of the rule depends on the type of the input aggregations. Below is an overview of the supported input formats for the operators.
Operator |
Rule |
Result type |
Addition | numeric + numeric |
|
duration + duration |
| |
currency + currency |
| |
percentage + percentage |
| |
timestamp + duration |
| |
Subtraction | numeric - numeric |
|
duration - duration |
| |
currency - currency |
| |
percentage - percentage |
| |
timestamp - duration |
| |
timestamp - timestamp | duration | |
Multiplication | numeric x numeric |
|
duration x numeric |
| |
currency x numeric |
| |
percentage x numeric |
| |
percentage x percentage |
| |
numeric x percentage |
| |
duration x percentage |
| |
currency x percentage |
| |
Division |
|
|
|
| |
|
| |
|
| |
|
| |
|
| |
Percentage |
|
|
|
| |
|
|
Grouping aggregations
In stead of a single aggregation type, you can select to use a Group aggregation to calculate the metric. This allows you to define the sequence of operations. Select the Group option from the list of aggregations, to create a group comprising two aggregations.
Given that a Group aggregation can contain two aggregations, and you are allowed to add up to two aggregations, you can create a rule that incorporates a total of four aggregations.
Null handling
X / 0
will return null
null / X
will return null
X / null
will return null
Applying filters to an aggregation
Follow these steps to apply filters to an aggregation.
-
Select the aggregation for which to you want to apply filters.
-
Select Add filter in the Create KPI panel.
-
Define the filters as desired.
The icon is displayed next to the aggregation indicating that filters are applied for the aggregation.
You can select the icon to see a preview of the applied filters.
Removing an aggregation
Follow this step to remove an aggregation from a rule.
-
Locate the aggregation you want to remove and select the icon.
The aggregation is removed without any notification.
To keep your process app clean, you can delete metrics that are not used anymore. Follow these steps to delete a metric.
- In the Data Manager panel, locate the metric you want to delete.
-
Hover over the metric name and select the Delete metric icon.
A confirmation message is displayed.
-
Select Delete.
See the illustration below.
Note: You can only delete user-created metrics. Metrics that are used in charts can not be deleted.