- Release notes
- Before you begin
- Managing access
- 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
- Process simulation
- 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
- Transforming data
- Structure of transformations
- Tips for writing SQL
- Exporting and importing transformations
- Viewing the data run logs
- Merging event logs
- Configuring Tags
- Configuring Due dates
- Configuring fields for Automation potential
- Activity Configuration: Defining activity order
- Making the transformations available in dashboards
- Data models
- Adding and editing processes
- Customizing process apps
- Publishing process apps
- App templates
- Notifications
- Additional resources
Process Mining
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. |
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.
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
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
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
NULL or not. If all the values are NULL, the result is 0.
Example
COUNT of Invoice ID
Description
Returns the smallest value for the selected field.
Syntax
MINIMUM 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
MINIMUM of Price
Description
Returns the number of unique (distinct) values for the selected field.
Syntax
DISTINCT COUNT of <Field>
Supported values
Can be used for fields of all data kinds.
NULL handling
NULL values are ignored. Only distinct, non-NULL values are counted. If all field values are NULL, the result is 0.
Example
DISTINCT COUNT of Invoice ID
Description
TRUE.
Syntax
PERCENTAGE of <Field>
Supported values
Can be used for boolean fields.
NULL handling
NULL values. If all values are NULL, the result is NULLExample
PERCENTAGE of Is Automated
Description
Returns the largest value for the selected field.
Syntax
MAXIMUM 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
MAXIMUM of Amount
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
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
PERCENTILE of function uses an approximate version, which may result in a small deviation from the actual percentile.
Description
TRUE if at least one value in the selected field evaluates to TRUE. Otherwise, returns FALSE.
Syntax
ANY of <Field> is TRUE
Supported values
Only boolean fields can be used.
NULL handling
NULL values are ignored. If all field values are NULL, the result is FALSE.
Example
ANY of On time is TRUE
Description
TRUE if all values in the selected field evaluate to TRUE. Otherwise, returns FALSE.
Syntax
ALL of <Field> are TRUE
Supported values
Only boolean fields can be used.
NULL handling
NULL values are ignored. If all field values are NULL, the result is TRUE. If at least one value is FALSE, the result is FALSE.
Example
ALL of On time are TRUE
Description
Groups the field values or expression results by the values of the specified field. Each unique value (or combination of values) forms a group.
COUNT of, SUM of, AVERAGE of, MINIMUM of, MAXIMUM of.
Syntax
<Expression> GROUPED by <groupings>
Supported values
Can be used for fields of all data kinds.
- The field specified in
GROUPED bymust be the primary key of the Target table and is automatically filled in. - The
GROUPED byfunction cannot be nested inside anotherGROUPED byexpression. However, it can be used as part of other expressions, and does not necessarily need to appear at the beginning of the expression.
NULL handling
NULL values in the grouping field are treated as a separate group.
Examples
(COUNT of Event ID) GROUPED by Case ID- Events grouped by Case ID, with a count of Event IDs per case.(COUNT of Event ID)- Counts the number ofEvent IDs.GROUPED by Case IDdefines that the counting is done separately for each uniqueCase ID.
(ALL of Automated are TRUE) GROUPED by Case ID- checks all the values of theAutomatedfield within eachCase IDgroup.(ALL of Automated are TRUE)checks whether every event in the group hasAutomated = TRUE.GROUPED by Case IDdefines that the check is performed separately for each uniqueCase ID.
(COUNT of (IF Activity = Final check of invoice THEN Process event ID)) GROUPED by Case ID(IF Activity = Final check of invoice THEN Process event ID)checks theActivityfield for each record. If the has the valueFinal check of invoicethe correspodingProcess event IDis returned.COUNT ofthen counts the number of returnedProcess event IDs— which is the number of times the activityFinal check of invoiceoccurred.GROUPED by Case IDdefines that the checks are performed separately for each uniqueCase ID.
