Sequential event identification based on event ?

I  would like to compute calculated column to find an effective study event 

Many student records are available  each student have two events namely study and sports 
 
The good study event is decided based on the sports event (only if there is no imediate sports event after study based on date time column)

Attached the sample data and the required output column

0 - indicates after study there is immediate sports event

1  -Indicates  after study there is no immediate sports event 

 

Thanks in advance 

 

 

Attachments

AttachmentSize
Image icon sample_data.jpg46.54 KB

1 Comment

I am a bit confused about your requirement. The row with Good study=1  had a sports event in the next row that starts 1 hour after end of that row. Do you mean sequential based on the next row, no matter the NAME value? Or does your logic involve the begin/end times?

Sean Riley - Mar 06, 2017 - 1:17pm ::
+ Add a Comment

(1) Answer

Login