INDEX_ACTIVITY_ORDER_REVERSE
Description
INDEX_ACTIVITY_ORDER_REVERSE returns the reverse position of each activity within a case. Only not null activities are counted.
Syntax
INDEX_ACTIVITY_ORDER_REVERSE ( activity_table.column )
activity_table.column: A column of an activity table. Usually, the activity column of an activity table is used.
NULL handling
If a row is NULL, then NULL will also be returned. NULL values do not influence the position of the non-NULL activities.
[1] INDEX_ACTIVITY_ORDER_REVERSE with null values. | ||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||
|
Result
INDEX_ACITIVTY_ORDER_REVERSE returns an INT column which gives for each not null activity in the activity table the reverse position within a case. The resulting column is temporarily added to the activity table.
Examples
[2] Example with two cases in which each activity is taken into account. | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|
[3] Example with two cases in which only B values are taken into account. | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|