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