Case when and Calc throughput focus on the full case and not a part(sub-process instead of process) for each case. I want KPIs to focus both on the entire case and sub process as well. I tried providing the first occurence and last occurence workaround, however this assumes that the process sequence is adhered to, it skips cases where the process sequence is not fully adhered to.
Page 1 / 1
Hi Narasimhan,
there are a series of PQL functionalities that could be used on activity level.
The easiest one for throughput time would be CALC_THROUGHPUT ( begin_range_specifier TO end_range_specifier, timestamps [, table.column ] )
but you can define very specific cases/paths with MATCH_PROCESS_REGEX
I hope it helps,
Best
Gabriel
Hi Narasimhan,
there are a series of PQL functionalities that could be used on activity level.
The easiest one for throughput time would be CALC_THROUGHPUT ( begin_range_specifier TO end_range_specifier, timestamps [, table.column ] )
but you can define very specific cases/paths with MATCH_PROCESS_REGEX
I hope it helps,
Best
Gabriel
Hi Gabriel, it is nice to see a reply on this topic
I have in fact used AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE EACTIVITY X'] TO LAST_OCCURRENCECACTIVITY N], REMAP_TIMESTAMPS("DATA_SOURCE_X"."DATE&TIMESTAMP", DAYS,WEEKDAY_CALENDAR ( MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY ))))
This provides me a Result, but I fear this will ignore activities which are typically completed before ACTIVITY N but in certain cases are completed after last occurence of ACTIVITY N
ideally i would have liked a solution where i can enrich the case table/ activity table with a sub-process value and used it to filter the throughput, but i believe celonis does not allow that now.
Hope the challenge is clearer now.
Regards
Narasimhan C
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.