Hi all,
I'd like to know how to omit specific throughput time activity. In my process flow is A->B->C->D, for example, and the throughtput time between C to D is too long than other throughput time and it might be misleading so I'd like to omit that value. does anybody know how to do it?
What exactly are you trying to accomplish? Do you want to omit/exclude the specific throughput time of that specific (trans)action in general? Or do you want to omit/exclude it under certain conditions?
Did you also thought about the consequences and implications of omitting/excluding? (just a question). Will the omit/exclude be isolated to this specific use case or do you want to use the same conditions for other analyses as well?
Hi, what I'd like to accomplish is to omit throghput time that related with specific activity. This requirement is from Japan specific business custom but they clear invoice at end of month so it might take 1 month maximum that not depend on therir business speed.
And I think I can use crop function of celonis analysis but it not filters data, I checked it but it only works on process or variant explorer.
Do you know how to omit that time with specific activity?
Hi Jumbo, In this formula we are omitting time between Current activity and Next activity ( Cancel Goods Receipt') and calculating avg throughput time.
AVG(PU_SUM(DOMAIN_TABLE("_CEL_P2P_ACTIVITIES_EN"."_CASE_KEY"),
CASE WHEN ACTIVITY_LEAD("_CEL_P2P_ACTIVITIES_EN"."ACTIVITY_EN")= 'Cancel Goods Receipt' THEN 0 ELSE
(DATEDIFF(dd,"_CEL_P2P_ACTIVITIES_EN"."EVENTTIME",
ACTIVITY_LEAD("_CEL_P2P_ACTIVITIES_EN"."EVENTTIME"))) END))
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
