Celonis Product Documentation

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.

  ACTIVATION_COUNT ( activity_table.column )
 

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.

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