Hi, could you please check if using ACTIVITY_LEAD helps? If not, I would suggest creating a support ticket.
Hi, could you please check if using ACTIVITY_LEAD helps? If not, I would suggest creating a support ticket.
Hi Keiko,
thank you for your response.
However, I don't think I understand how to use your suggestion.
I read the definition and usage of ACTIVITY_LEAD and I think I understood that to use it I need to know the exact location of the activity.
Unfortunately, between activities A, B and C there can be n different activities, and for each case they can be different, so I don't think I can use it.
Am I missing something?
Thank you
Hi Enrico, thanks for your response. I would suggest creating a support ticket by providing the actual activity data.
Since no one was able to help me and I was able, after several trials, to achieve a good result, I am reporting it here for anyone who had the same problem:
CASE WHEN PROCESS EQUALS 'A' AND PROCESS EQUALS 'B' AND PROCESS NOT EQUALS 'C'
THEN CALC_THROUGHPUT(FIRST_OCCURRENCEE'A'] TO FIRST_OCCURRENCEE'B'], REMAP_TIMESTAMPS("Activity"."timestamp", MINUTES))
WHEN PROCESS EQUALS 'A' AND PROCESS EQUALS 'B' AND PROCESS EQUALS 'C'
AND CALC_THROUGHPUT(FIRST_OCCURRENCEE'A'] TO FIRST_OCCURRENCEE'B'], REMAP_TIMESTAMPS("Activity"."timestamp", MINUTES)) < CALC_THROUGHPUT(FIRST_OCCURRENCEE'A'] TO FIRST_OCCURRENCEE'C'], REMAP_TIMESTAMPS("Activity"."timestamp", MINUTES))
THEN CALC_THROUGHPUT(FIRST_OCCURRENCEE'A'] TO FIRST_OCCURRENCEE'B'], REMAP_TIMESTAMPS("Activity"."timestamp", MINUTES))
END
For the complementary indicator, I reversed 'B' with 'C'
