Skip to main content

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

 

imageーー

AVG(

   CALC_THROUGHPUT (

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

  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​ーー

 

Hi Ishiduka!

Try this:

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

(

CALC_THROUGHPUT (

 

FIRST_OCCURRENCE 'Activity1' ]

 

TO FIRST_OCCURRENCE E 'Activity2' ]

 

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

 

)

)


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


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?


Reply