Throughput time with factory calendar


#1

Hi,

is it possible to calculate the throughput time between two activities with respect to the factory calendar (which is included in the data model)?
To be precise, is there an option to use workdays in the PQL function CALC_THOUGHPUT since we want to have the freedom to choose e.g. the last or first occurence of an activitiy?

Thanks in advance.


#2

Hi Daniela,

I did not use the CALC_THROUGHPUT function, but doing something similar using the PU_LAST/PU_FIRST functionality. Maybe this is also an option for you.

MEDIAN(WORKDAYS_BETWEEN(“PROD_CASES”.“CALENDARID”, PU_FIRST(“PROD_CASES”, “_CEL_PROD_ACTIVITIES”.“EVENTTIME”,"_CEL_PROD_ACTIVITIES".“ACTIVITY_EN” = <%= From %> ),
PU_LAST(“PROD_CASES”, “_CEL_PROD_ACTIVITIES”.“EVENTTIME”, “_CEL_PROD_ACTIVITIES”.“ACTIVITY_EN” = <%= To %>)))


#3

Thanks for your reply, worked out! :smile: