Calculate throughput time between one certain activity and the closest activity from a list of activities We are analysing a contract cancellation process and I would like to calculate the average throughput time between the cancellation notice and the first customer touchpoint per touchpoint. Different activities can be the first touch point, e.g. the cancellation confirmation or an outbound call. I would like to know the throughput time per touch point, e.g. "in cases in which the first touch point is the cancellation confirmation, the average time between cancellation notice and cancelation confirmation is xy"Some additional info:The process does not always start with the cancellation notice. There can be touch points before the cancellation notice, that we want to ignorethere can be several cancellation notices in one case; we want to start calculating the throughput time from the first notice. If there is another cancellation notice it is a customer touch pointWe are working with an on prem solution, so not all pql formulas workHere you can see the desired structure, with S
