Hi, I need to determine the Cycle time of each activity that is not fully automated to determine the impact of not being fully automated. The Cycle time must be from the activity before the specific activity to the activity after the specific activity. How can I do that without specifically referencing the activity - hence 1 PQL that can apply to all non-fully automated activities.
Hi have this formula - but need to trim it down to only the activity before and after:
${{agg}}(CASE WHEN ( ${{user_type_column_name}}
!= '${{automatic_user_types}}')
then (
CALC_THROUGHPUT (
ALL_OCCURRENCE N 'e_custom_InitiatePayment' ]
TO ALL_OCCURRENCE R 'e_custom_ConfirmPayment' ] ,
REMAP_TIMESTAMPS (
TIMESTAMP_COLUMN ( ${{activity_table_case_centric}} ) ,
${{main_time_scale}} ))) ELSE NULL END)
-
${{agg}}(CASE WHEN ( ${{user_type_column_name}}
= '${{automatic_user_types}}')
then (
CALC_THROUGHPUT (
ALL_OCCURRENCE > 'e_custom_InitiatePayment' ]
TO ALL_OCCURRENCE p 'e_custom_ConfirmPayment' ] ,
REMAP_TIMESTAMPS (
TIMESTAMP_COLUMN ( ${{activity_table_case_centric}} ) ,
${{main_time_scale}} ))) ELSE NULL END)
So the 'e_custom_initiatePayment must be the lag activity and the e_custom)confirmPayment the lead activity for each manual activity
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
