- 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
- Triggering an automation from a process app
- Viewing Process data
- Creating apps
- Loading data
- Transforming data
- Customizing dashboards
- Publishing Dashboards
- App templates
- Notifications
- Additional resources
Define aggregate metric expressions in Process Mining on Automation Suite by specifying an aggregation type and field to compute a single result value from a set of inputs.
Aggregates are only applicable for use in metric expressions. You can not use aggregates for field expressions.
With Aggregates you can compute a single result value from a set of input values. An aggregate metric expression is defined by the aggregation type and the field used for the aggreagation.
| 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. |
Applying filters to an aggregation
You can add a filter to an aggregation to create a subset of the data that is used for the aggregation, by only selecting the relevant data. Filtering can reduce the amount of data that an aggregate function needs to process, which can speed up the calculation.
Follow these steps to apply filters to an aggregation.
- Select the aggregation for which to you want to apply filters.
- Select Filter icon in the logic block. The Filters panel is displayed.
- Define the filters as desired**.**
The Filter icon indicates that filters are applied for the aggregation.
SUM of
Description
Returns the sum of all values for the selected field.
Syntax
SUM of <Field>
Supported values
Can be used for fields of number, duration, and currency data kinds.
NULL handling
NULL values are ignored. If all field values are NULL, the result is NULL.
Example
SUM of Value
AVERAGE of
Description
Returns the sum of all values for the selected field divided by the number of records in the table of the selected field.
Syntax
AVERAGE of <Field>
Supported values
Can be used for fields of number and duration data kinds.
NULL handling
NULL values are ignored. If all field values are NULL, the result is NULL.
Example
AVERAGE of Discount captured
COUNT of
Description
Returns the number of values for the selected field.
Syntax
COUNT of <Field>
Supported values
Can be used for fields of all data kinds.
NULL handling
Counts all values, whether field value is NULL or not. If all the values are NULL, the result is 0.
Example
COUNT of Invoice ID
MIN of
Description
Returns the smallest value for the selected field.
Syntax
MIN of <Field>
Supported values
Can be used for fields of number, duration, and currency data kinds.
NULL handling
NULL values are ignored. If all field values are NULL, the result is NULL.
Example
MIN of Price
MAX of
Description
Returns the largest value for the selected field.
Syntax
MAX of <Field>
Supported values
Can be used for fields of number, duration, and currency data kinds.
NULL handling
NULL values are ignored. If all field values are NULL, the result is NULL.
Example
MAX of Amount
MEDIAN of
Description
Returns the median of the values for the given field.
Syntax
MEDIAN of <Field>
Supported values
Can be used for fields of number, duration, and currency data kinds.
NULL handling
NULL values are ignored. If all field values are NULL, the result is NULL.
Example
MEDIAN of Value
The MEDIAN of function returns an approximate result, which may differ slightly from the exact median.
PERCENTILE of
Description
Returns the specified percentile of the values for the given field, which is the value below which that percentage of the data falls.
Syntax
PERCENTILE of <Field> <percentile>
Supported values
Can be used for fields of number, duration, and currency data kinds.
NULL handling
NULL values are ignored. If all field values are NULL, the result is NULL.
Example
PERCENTILE of Value 0.05
The PERCENTILE of function returns an approximate result, which may differ slightly from the exact percentile.
- Applying filters to an aggregation
SUM of- Description
- Syntax
- Supported values
- NULL handling
- Example
AVERAGE of- Description
- Syntax
- Supported values
- NULL handling
- Example
COUNT of- Description
- Syntax
- Supported values
- NULL handling
- Example
MIN of- Description
- Syntax
- Supported values
- NULL handling
- Example
MAX of- Description
- Syntax
- Supported values
- NULL handling
- Example
MEDIAN of- Description
- Syntax
- Supported values
- NULL handling
- Example
PERCENTILE of- Description
- Syntax
- Supported values
- NULL handling
- Example