Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I have a problem, I would like to analyze my data 2 by 2 rows.
|
|
|
| ||||
---|---|---|---|---|---|---|---|
1 |
|
|
| ||||
1 |
|
|
|
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.
Regards,
Todor
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