I have an activity in my activity table that can be initiated multiple times. In order to be able to define the activity more precisely, there is a combination of 3 codes which is provided in the activity details. 

Now, during the process, it can happen that some of the initiated activities are cancelled again.

For example, a process flow could look like following:

Activity name - Activity detail - Eventtime

Initiation Activity - A0/B1/C3 - Monday

Initiation Activity - A3/B3/C9 - Monday

Initiation Activity - A7/B2/C0 - Wednesday

Initiation Activity - A5/B6/C6 - Thursday

Cancellation Activity - A0/B1/C3 - Sunday

Cancellation Activity - A7/B2/C0 - Sunday

I would like to measure the cycle time from initiation to cancellation of each activity.

So in the example shown above from the 1st & 3rd "Initiation Activity" to the corresponding "Cancellation Activity" which would equal 6 (monday-sunday) and 4 (wednesday-sunday) days respectively.

How can a corresponding PQL formula look like?

I've tried different ways using Calc_Throughput and Days_Between but couldn't find a solution.

Thanks in advance!