I have a problem, I would like to analyze my data 2 by 2 rows.
Id
Time
EventId
Type
1
15-06-2009T13:45:30
1
End_Time
1
15-06-2009T13:45:34
4
Something
This is my data. For example, we have id of an operation, End_Time of an operation, EventId etc. and it is an consequent Event for the same operation. I would like to get the Count of id, which have started with EventId = 1 and Type = 'End_Time' and consequent action with EventId = 4, but the maximum difference between time should be 5 seconds.
I attach excel file with more data but imagine there are many types of EventId and Type.
I would add a field on the same row for EventId=1 with the subsequent time for EventId=4 and flag the records that are 5 seconds or less. Something like attached. Depending on your other needs/datamodel you can add other fields and/or rows
