Total throughput time of a sub process which occurs multiple times within a case

Question

Good evening guys,I would like to calculate the total throughput time of a sub process which can occur multiple times within one case. The subprocess always starts with a unique activity and ends with a unique activity. There might be different activities between the start & end activity (see picture). I tried my best by using the MATCH_PROCESS_REGEX function but didn't succeed. Thanks a lot for any hints and suggestions! Cheers,Alex

deleted.delet27 · Answer

Hello,

It's rather complicated problem, so for now i will just advice with general approach - maybe in some days I will create practical example with solution.

You can use REMAP_VALUES to NULLify all the activities besides B & C, which will leave you with possibility to use DAYS_BETWEEN(<eventtime>, LEAD(eventtime)) functions to calculate times between rows.
After calculation you would need to use PU_SUM(Case_table, earlier PQL calculation statement)

I think it's good place to start, but unfortunately it will calculate time difference for every row, and you want to have calulation only for B's

Best Regards,

Mateusz Dudek

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN