I am looking for an OLAP table which can show multiple KPI’s (MODUS, MEAN, TRIMMED MEAN, QUANTILE) of the throughput time between activities.
The business use case is to have a comprehensive overview of the “real” throughput time from Celonis in order to compare these values with the current master data settings in the operating system.
The first row is showing the overall throughput time of the process from the first activity (A) to the last activity (D) (e.g. from customer order is received until product arrived at the customer.
In the rows below I want to check the throughput time of the individual process steps. For example, activity A (start pick&pack) to activity B (complete pick&pack))
Question 1: How can I show in the first columns the two activities I am interested in?
Question 2: In addition, how can I add an individual line like illustrated as Bottom Up SUM
Question 2: How can the MODUS be calculated? There is no PQL function available
In general, I am clear about calculating the MEAN between two activities like below
AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[‘Activity A’] TO FIRST_OCCURRENCE[‘Activity B’], REMAP_TIMESTAMPS("_CEL_O2C_ACTIVITIES".“EVENTTIME”, DAYS)))
I am on version 4.3 and will move to 4.5 by the end of this week.
Thanks for your help