Skip to main content
Question

Cycle Time between activities when activity happens manually

  • June 4, 2024
  • 1 reply
  • 28 views
bennita.dutoi12
Level 7
Forum|alt.badge.img+6

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.

 

 

    1 reply

    bennita.dutoi12
    Level 7
    Forum|alt.badge.img+6

    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 [ 'e_custom_InitiatePayment' ]

        TO  ALL_OCCURRENCE [ '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 [ '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

    Community Code of ConductAccessibility statement