- 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 dashboards
- Publishing process apps
- App templates
- Notifications
- Additional resources
Process Mining
Description
Calculates the sum of two values.
Syntax
<Numeric field or Expression> + <Numeric field or Expression>
Supported values
|
Supported value |
Result |
numeric + numeric |
|
duration + duration |
|
currency + currency |
|
percentage + percentage |
|
timestamp + duration |
|
NULL, the result is NULL.
Example
Case value + 1000
Description
Calculates the difference of two values.
The second value is subtracted from the first value.
Syntax
<Numeric field or Expression> - <Numeric field or Expression>
Supported values
|
Supported values |
Result |
numeric - numeric |
|
duration - duration |
|
currency - currency |
|
percentage - percentage |
|
timestamp - duration |
|
timestamp - timestamp | duration |
NULL handling
NULL, the result is NULL.
Example
Case end - Case start
Description
Calculates the product of two values.
Syntax
<Numeric field or Expression> * <Numeric field or Expression>
Supported values
|
Supported values |
Result |
numeric * numeric |
|
duration * numeric |
|
currency * numeric |
|
percentage * numeric |
|
percentage * percentage |
|
numeric * percentage |
|
duration * percentage |
|
currency * percentage |
|
NULL handling
NULL, the result is NULL.
Example
Number of events * 365
Description
Calculates the quotient of two values.
The first value is divided by the second value.
Syntax
<Numeric field or Expression> / <Numeric field or Expression>
Supported values
|
Supported values | Result |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
NULL handling
X / 0 will return NULL.
NULL / X will return NULL.
X / NULL will return NULL.
Example
Throughput time / Number of events
Description
Calculates the percentage of two values.
The first value is divided by the second value and the result is multiplied by 100.
Syntax
% of <Numeric field or Expression> in <Numeric field or Expression>
Supported values
|
Supported values | Result |
|
|
|
|
|
|
|
|
|
NULL handling
NULL, the result is NULL.
Example
% Number of events in Variants
