Skip to main content
Question

Calculate time between two activities without a third being in between

  • December 12, 2023
  • 4 replies
  • 25 views
enrico.pugli12
Level 6
Forum|alt.badge.img+10

Hello everyone,

I should create two KPIs: average times between two activities.

1) the first one between activity A and activity B, in cases where activity C is not between these two activities

2) the second between activity A and activity C, in cases where activity B is not between these two activities.

 

So in a nutshell: the time between activity A and activity B, when the latter comes before C, and the time between activity A and activity C, when the latter comes before B.

I leave a diagram to explain better.

When there are only A and C without B, or only A and B without C it is very easy, but I cannot create when there are all 3.

 

Can you help me?

 

Thanks

 

1 Attachments

4 replies

K
Level 0
Forum|alt.badge.img+6
Hi, could you please check if using ACTIVITY_LEAD helps? If not, I would suggest creating a support ticket.
enrico.pugli12
Level 6
Forum|alt.badge.img+10
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

K
Level 0
Forum|alt.badge.img+6
Hi Enrico, thanks for your response. I would suggest creating a support ticket by providing the actual activity data.
enrico.pugli12
Level 6
Forum|alt.badge.img+10

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_OCCURRENCE['A'] TO FIRST_OCCURRENCE['B'], REMAP_TIMESTAMPS("Activity"."timestamp", MINUTES))

WHEN PROCESS EQUALS 'A' AND PROCESS EQUALS 'B' AND PROCESS EQUALS 'C'

AND CALC_THROUGHPUT(FIRST_OCCURRENCE['A'] TO FIRST_OCCURRENCE['B'], REMAP_TIMESTAMPS("Activity"."timestamp", MINUTES)) < CALC_THROUGHPUT(FIRST_OCCURRENCE['A'] TO FIRST_OCCURRENCE['C'], REMAP_TIMESTAMPS("Activity"."timestamp", MINUTES))

THEN CALC_THROUGHPUT(FIRST_OCCURRENCE['A'] TO FIRST_OCCURRENCE['B'], REMAP_TIMESTAMPS("Activity"."timestamp", MINUTES))

END

 

For the complementary indicator, I reversed 'B' with 'C'

Community Code of ConductAccessibility statement