I would like to create a KPI to determine the % of the confirmation date changes which were caused by a requested date change in the Order to Cash activity flow.

If the 2 events: Requested Date Change and Confirmed Date Change happened at the same time and with the same change number (which is stored in a separate column in the activity table), we assume the confirmed date change was caused by the requested date change.

What would be the best way to check for this? SOURCE? TARGET? ACTIVITY_LAG/LEAD?

Any ideas are appreciated.