Hello everyone,
i need a throughput between two consequitive activities and want to implement it via source and target.
Die idee wre source(activity_table.activity), target(activity_table.activity, process_order(target)=process_order(source)+1))
would it work?
Best,
Maria
SOURCE("activities"."activity")TARGET("activities"."activity")HOURS_BETWEEN ( SOURCE("activities"."timestamp"), TARGET("activities"."timestamp") )Hi Marina,
here is a great resource that explains calculations on activity sequences. Check out this documentation which also provides further scenarios + solutions:
https://confluence.celonis.com/display/PQLdevelopment/Calculations+on+Activity+Sequences
Best,
Kevin
Hello Maria,
Better than SOURCE() and TARGET() is to use ACTIVITY_LAG
ACTIVITY_LAG ( table.column [, offset ] )
You could simply use DAYS_BETWEEN,ACTIVITY.ACTIVITY_EN,ACTIVITY_LAG(ACTIVITY.ACTIVITY_EN,1))
Best,
Gabriel
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.