Skip to main content
Question

I would like to get the throughput time between specific activities, averaged per unit.

  • May 22, 2024
  • 3 replies
  • 74 views
I
Level 3
Forum|alt.badge.img+5

How can we calculate the average throughput time per unit without errors?

 

imageーー

AVG(

   CALC_THROUGHPUT (

   FIRST_OCCURRENCE [ '伝票登録画面表示' ]

  TO FIRST_OCCURRENCE [ '伝票保存' ]

  , REMAP_TIMESTAMPS ("t_Activity"."日時", MINUTES ) )

 )

ーー

ーーErrormessage​ーー

The aggregation function AVG is applied on a column from table "t_Case" which has a 1:N relationship to the common table "t_Activity". This means that one input value can contribute to the aggregation result multiple times. For more information search for "Join functionality" in PQL documentation.

ーーErrormessage​ーー

 

    3 replies

    P
    Level 0
    Forum|alt.badge.img+6

    Hi Ishiduka!

    Try this:

    PU_AVG( DOMAIN_TABLE("Case_Table"."_CASE_KEY"),

    (

    CALC_THROUGHPUT (

     

    FIRST_OCCURRENCE [ 'Activity1' ]

     

    TO FIRST_OCCURRENCE [ 'Activity2' ]

     

    , REMAP_TIMESTAMPS ("Activity_Table"."EVENTTIME", MINUTES ) )

     

    )

    )

    I
    Level 3
    Forum|alt.badge.img+5

    Thank you so much.

     

    I created the PQL as you said. When I did so, the throughput time per record was displayed.

    What I want to display is the throughput per unit number.

    How should I describe it?

    image

    P
    Level 0
    Forum|alt.badge.img+6

    Hi Ishiduka!

    Could you provide more info on what table your unit number comes from and the relationship of this table to the activity table?

    Community Code of ConductAccessibility statement