process-mining
2024.10
true
UiPath logo, featuring letters U and I in white

Process Mining

Last updated Apr 28, 2025

Aggregates

Attention:

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 aggregationThe 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.

  1. Select the aggregation for which to you want to apply filters.

  2. Select Filter icon in the logic block. The Filters panel is displayed.

  3. 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 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

PERCENTILE of

Description

Returns the specified percentile of the values for the given field.

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

Note:
The PERCENTILE of function uses an approximate version, which may result in a small deviation from the actual percentile.

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2025 UiPath. All rights reserved.