mboswell28
New Member
- Joined
- Oct 9, 2014
- Messages
- 8
I am looking for assistance with counting the frequency that TIMEOUT appears consecutively for each driver on each day. I'm looking for instances TIMEOUT appears 3 times consecutively for a driver on a given day. At that point I'd like to know the number of rows that appear after the 3rd consecutive TIMEOUT for that driver on that day. I've included that data table below.
For example Driver 1 on 9/19 had 3 consecutive TIMEOUT's and one row appeared after the 3rd TIMEOUT. Driver 2 on 9/23 had 3 consecutive TIMEOUTS's and there were two rows after the 3rd TIMEOUT. Any assistance is greatly appreciated.
<tbody>
</tbody><colgroup><col><col><col><col span="2"><col><col></colgroup>
For example Driver 1 on 9/19 had 3 consecutive TIMEOUT's and one row appeared after the 3rd TIMEOUT. Driver 2 on 9/23 had 3 consecutive TIMEOUTS's and there were two rows after the 3rd TIMEOUT. Any assistance is greatly appreciated.
TIMEOUT | ||||||
OWNR_NAME | DATE | JOB STATUS | OWNR_NAME | DATE | ||
DRIVER 1 | 9/19/2017 | ACCEPTED | DRIVER 1 | 9/19/2017 | ||
DRIVER 1 | 9/19/2017 | TIMEOUT | DRIVER 1 | 9/20/2017 | ||
DRIVER 1 | 9/19/2017 | TIMEOUT | DRIVER 1 | 9/21/2017 | ||
DRIVER 1 | 9/19/2017 | TIMEOUT | DRIVER 1 | 9/22/2017 | ||
DRIVER 1 | 9/19/2017 | ACCEPTED | DRIVER 2 | 9/18/2017 | ||
DRIVER 1 | 9/20/2017 | ACCEPTED | DRIVER 2 | 9/20/2017 | ||
DRIVER 1 | 9/20/2017 | TIMEOUT | DRIVER 2 | 9/21/2017 | ||
DRIVER 1 | 9/20/2017 | ACCEPTED | DRIVER 2 | 9/22/2017 | ||
DRIVER 1 | 9/21/2017 | TIMEOUT | DRIVER 2 | 9/23/2017 | ||
DRIVER 1 | 9/21/2017 | REJECTED | DRIVER 2 | 9/24/2017 | ||
DRIVER 1 | 9/22/2017 | ACCEPTED | ||||
DRIVER 2 | 9/18/2017 | TIMEOUT | ||||
DRIVER 2 | 9/18/2017 | TIMEOUT | ||||
DRIVER 2 | 9/20/2017 | TIMEOUT | ||||
DRIVER 2 | 9/20/2017 | TIMEOUT | ||||
DRIVER 2 | 9/20/2017 | TIMEOUT | ||||
DRIVER 2 | 9/21/2017 | ACCEPTED | ||||
DRIVER 2 | 9/21/2017 | ACCEPTED | ||||
DRIVER 2 | 9/21/2017 | REJECTED | ||||
DRIVER 2 | 9/22/2017 | TIMEOUT | ||||
DRIVER 2 | 9/22/2017 | REJECTED | ||||
DRIVER 2 | 9/22/2017 | TIMEOUT | ||||
DRIVER 2 | 9/23/2017 | ACCEPTED | ||||
DRIVER 2 | 9/23/2017 | TIMEOUT | ||||
DRIVER 2 | 9/23/2017 | TIMEOUT | ||||
DRIVER 2 | 9/23/2017 | TIMEOUT | ||||
DRIVER 2 | 9/23/2017 | ACCEPTED | ||||
DRIVER 2 | 9/23/2017 | REJECTED | ||||
DRIVER 2 | 9/24/2017 | REJECTED | ||||
DRIVER 2 | 9/24/2017 | TIMEOUT | ||||
DRIVER 2 | 9/24/2017 | TIMEOUT |
<tbody>
</tbody><colgroup><col><col><col><col span="2"><col><col></colgroup>