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 [ 'Activity B' ]
TO
FIRST_OCCURRENCE [ '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
