Applies to: CELONIS 4.7
The INDEX_ACTIVITY_TYPE operator returns for every activity in every case, how many times, at a given point in a process this activity has already occurred.
INDEX_ACTIVITY_TYPE ( activity_table.activity_column )activity_column: The activity column of the activity table.
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
Activities in parallel processes will get an activation count with respect to the absolute order, based on the timestamp of the activity.
INDEX_ACTIVITY_TYPE ignores NULL values. If the column contains only NULL values the result will also be a column containing only NULL values. If there are NULL values and non NULL values, it is guaranteed that no non NULL value is similar to the NULL value.
[1] INDEX_ACTIVITY_TYPE over two cases.
|