CALC_REWORK Vs INDEX_ACTIVITY_TYPE

Hi @Raman Silotia 

you are right that both can be used to calculate KPIs related to rework, but the actual functions do different things.

The main difference is that CALC_REWORK calculates "rework" on Case-Level. Just using CALC_REWORK() just returns the number of Activities per case (which, I agree, is not really rework), but when you pass a filter condition to select a specific activity (e.g., CALC_REWORK("Activities"."Activity" = 'X') ), then it will return the number of times this activity occurs per case (i.e., how often it was reworked).

INDEX_ACTIVITY_TYPE, however, returns the result not on Case-level, but on Activity level. For each row in the Activity table, it returns how often this Activity has already occurred in that case so far.

So filtering on a specific Activity, and calculating the maximum INDEX_ACTIVITY_TYPE value per Case would give you the same result as the CALC_REWORK would return for this Activity.

For more information on both functions, including examples and syntax descriptions, please have a look at the documentation pages: https://docs.celonis.com/en/calc_rework.html, https://docs.celonis.com/en/index_activity_type.html

Let me know if you have more questions about these functions.

Best

David

So can I say that if I want to calculate rework rate of all activities I should go for INDEX_ACTIVITY_TYPE, but for a specific set of activities I should use CALC_REWORK ?

So can I say that if I want to calculate rework rate of all activities I should go for INDEX_ACTIVITY_TYPE, but for a specific set of activities I should use CALC_REWORK ?

@dominik.pappe12 

You can use a PU function for this. For example, you could use a PU_MAX on the INDEX_ACTIVITY_TYPE result and if that is >1, you have a rework case.

CASE WHEN PU_MAX( CASE_TABLE(), INDEX_ACTIVITY_TYPE( ACTIVITY_COLUMN() ) ) > 1 THEN 1 ELSE 0 END

This would return a 1 if the case is a rework case, and a 0 otherwise.

Best

David

Hey David,

first of all thanks for your explanations... I used them to fix my problem, but if I use INDEX it shows me just 3 Activities with Rework (which ones I can controll in the Variant explorer that have Rework on them self) and in the CALC_REWORK functions it shows me 100% in every Activity...

In the picture below you see I want to analyse all Activities. So I take the Activities as the Dimension and Acitivity count as KPI. Furthermore I would like to show how many Activities where real "Rework" and how often did they appear.

best regards

Arthur

Hi David,

thanks a lot for your help! I used your function in my case but it gives me the same numbers as the "activity count" function (see picture 1 below)

The second picture shows an overview about my talbes which I need for my analysis. There you see the last table (on the button) where i don´t know how to calculate the activities which accours more then one times in a case (rework).

In this table i want to sum the activities count of the activities which accours more then one times in a case (which stands for rework, right?)

(I hope you understand what I mean)

Picture 1

Picture 2