Is there an option to apply filters in PQL statements when defining custom KPIs. I am working on a scenario where the KPI needs to be applied at a sub-category of activities(sub-processes to be precise) instead of the whole case itself.

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 [ACTIVITY X'] TO LAST_OCCURRENCE[ACTIVITY 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