Implement washover based on two events

[david26694]

For each record in our experiment, we have two events' timestamps, login_timestamp and logout_timestamp. We want to apply washover such that if there is a change in treatment between login_timestamp and logout_timestamp.

Calendar:

treatment,time
A,10:00
B,11:00
B,12:00

Record data:

id,start_time,end_time
1,10:50,10:59
2,10:51,11:01
3,11:01,11:05
4,11:01,12:01
5,12:01,12:05

In this case, we want to washover row number 2.