Hi everyone,

i got following activity table structure:

Item ID (case ID), Activity (activity), Timestamp (timestamp), Item position ID

One Item ID can have multiple Item Position IDs; so 1:n relationship. Some activities tend to repeat themselves for each distinct Item Position ID, example:

Item 1, Activity A, 08.08.2023 10:00, -

Item 1, Activity B, 08.08.2023 10:01, ItemPosition 11

Item 1, Activity C, 08.08.2023 10:02, ItemPosition 11

Item 1, Activity B, 08.08.2023 10:03, ItemPosition 12

Item 1, Activity C, 08.08.2023 10:06, ItemPosition 12

Item 1, Activity D, 08.08.2023 10:07, -

I want following throughput time calculation to be considered for each Item Position ID, which i am not able to generate.

 CALC_THROUGHPUT (

  FIRST_OCCURRENCE U 'Activity B' ]

  TO

  FIRST_OCCURRENCE T 'Activity C' ] ,

  REMAP_TIMESTAMPS ( "Activity_Sheet"."TIMESTAMP" , MINUTES )

)

Output expected:

ItemPosition 11, 1 min.

ItemPosition 12, 3 min.

Generally i would create 2 activity logs, one each for Item ID and Item Position ID. But i don't have the luxery of multi-log, so i want a solution within one log.

Is it somehow possible for the calculation to be for each distinct Item Position ID?

Thanks for all the help,

Cheers