Applies to: CELONIS 4.3 CELONIS 4.4
Description
The ACTIVATION_COUNT operator returns for every activity in every case, how many times, at a given point in a process this activity has already occurred.
Syntax
ACTIVATION_COUNT ( activity_table.activity_column )
- activity_column: The activity column of the activity table.
Result
For every activity in every case a number x, that shows this is the xth occurrence of this particular activity in the case.
Imagine the unfolding of a process into a sequential graph, as shown below, the algorithm increases the number for a special activity every time he encounters said activity on his way from the beginning to the end of the process:
Example of a process graph with annotated activation counts
Parallel Processes
Activities in parallel processes will get an activation count with respect to the absolute order, based on the timestamp of the activity.
Example
ACTIVATION_COUNT over two cases
Query
Column1
ACTIVATION_COUNT("Table1"."ACTIVITY")
Input
Table1
| CASE_ID : STRING | ACTIVITY : STRING | TIMESTAMP : DATE |
|---|---|---|
| '1' | 'A' | Sun Jan 01 2017 13:00:00.000 |
| '1' | 'B' | Sun Jan 01 2017 13:01:00.000 |
| '1' | 'C' | Sun Jan 01 2017 13:02:00.000 |
| '1' | 'A' | Sun Jan 01 2017 13:03:00.000 |
| '1' | 'B' | Sun Jan 01 2017 13:04:00.000 |
| '1' | 'A' | Sun Jan 01 2017 13:05:00.000 |
| '2' | 'A' | Sun Jan 01 2017 13:06:00.000 |
| '2' | 'B' | Sun Jan 01 2017 13:07:00.000 |
Output
Result
| Column1 : INT |
|---|
1 |
1 |
1 |
2 |
2 |
3 |
1 |
1 |