CALC_REWORK
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
CALC_REWORK counts the number of activities per case. A filter expression can be specified to restrict the activities that should be taken into account.
Syntax
CALC_REWORK ()
CALC_REWORK ( filter_condition )
CALC_REWORK ( table.column )
CALC_REWORK ( filter_condition , table.column )
filter_condition: All activities that match the filter condition will be counted.
table.column: Column which has to be joinable to an activity table (Since: CELONIS 4.6). This can be used to specify the event log that should be used if multiple event logs are contained in the data model.
NULL handling
NULL values are in general not relevant for the calculation since CALC_REWORK counts how often a CASE_ID appears. However, if a case does not have a join partner in the case table, it will be ignored. If there is a NULL case id in the case table, it will be taken over into the result table. However, the result for it will be 0 since NULL cases are not joined.
[1] CALC_REWORK with NULL values in the activity table. The first element in the result table represents the NULL case. However, NULL values in the activity table are ignored. Therefore, the result is 0.
|
Examples
[2] Example for CALC_REWORK on 3 cases without filter.
|
[3] Example for CALC_REWORK on 3 cases without filter. The activity column that should be used is passed as a parameter. This can be used to specify the event log that should be used if multiple event logs are contained in the data model.
|
[4] Example for CALC_REWORK with filter on activities B and C.
|
[5] Example for CALC_REWORK with filter on activities B and C with specified activity column. This can be used to specify the event log that should be used if multiple event logs are contained in the data model.
|