Refer to below data table, how to New Create A column to count Cycle Time? kindly help to suggest. thanks a lot.
1.need sort properly by "Group Name" and "Date".
2. within same "Group Name", with "Date" increase, column"Count" number increases, after a certain level (the max value maybe not fixed, sometimes change), it will be back to small value, which means another cycle start.
Group Name | Date | Count |
P1 | 4/22/2020 7:26 | 1 |
P1 | 4/22/2020 8:26 | 2 |
P1 | 4/22/2020 9:26 | 3 |
P1 | 4/22/2020 10:26 | 4 |
P1 | 4/22/2020 11:26 | 5 |
P1 | 4/22/2020 12:26 | 6 |
P1 | 4/22/2020 13:26 | 7 |
P1 | 4/22/2020 14:26 | 8 |
P1 | 4/22/2020 15:26 | 9 |
P1 | 4/22/2020 16:26 | 10 |
P1 | 4/22/2020 17:26 | 13 |
P1 | 4/22/2020 18:26 | 1 |
P1 | 4/22/2020 19:26 | 2 |
P1 | 4/22/2020 20:26 | 3 |
P1 | 4/22/2020 21:26 | 4 |
P1 | 4/22/2020 22:26 | 5 |
P1 | 4/22/2020 23:26 | 6 |
P1 | 4/23/2020 0:26 | 7 |
P1 | 4/23/2020 1:26 | 8 |
P1 | 4/23/2020 2:26 | 9 |
P1 | 4/23/2020 3:26 | 10 |
P1 | 4/23/2020 4:26 | 11 |
P1 | 4/23/2020 5:26 | 1 |
P1 | 4/23/2020 6:26 | 2 |
P1 | 4/23/2020 7:26 | 3 |
P1 | 4/23/2020 8:26 | 4 |
P1 | 4/23/2020 9:26 | 5 |
P1 | 4/23/2020 10:26 | 6 |
P1 | 4/23/2020 11:26 | 7 |
P1 | 4/23/2020 12:26 | 8 |
P1 | 4/23/2020 13:26 | 9 |
P1 | 4/23/2020 14:26 | 10 |
P1 | 4/23/2020 15:26 | 18 |
P2 | 4/22/2020 5:26 | 1 |
P2 | 4/22/2020 6:26 | 2 |
P2 | 4/22/2020 7:26 | 3 |
P2 | 4/22/2020 8:26 | 4 |
P2 | 4/22/2020 9:26 | 5 |
P2 | 4/22/2020 10:26 | 6 |
P2 | 4/22/2020 11:26 | 7 |
P2 | 4/22/2020 12:26 | 8 |
P2 | 4/22/2020 13:26 | 9 |
P2 | 4/22/2020 14:26 | 10 |
P2 | 4/22/2020 15:26 | 11 |
P2 | 4/22/2020 16:26 | 1 |
P2 | 4/22/2020 17:26 | 2 |
P2 | 4/22/2020 18:26 | 3 |
P2 | 4/22/2020 19:26 | 4 |
P2 | 4/22/2020 20:26 | 5 |
P2 | 4/22/2020 21:26 | 6 |
P2 | 4/22/2020 22:26 | 7 |
P2 | 4/22/2020 23:26 | 8 |
P2 | 4/23/2020 0:26 | 9 |
P2 | 4/23/2020 1:26 | 10 |
P2 | 4/23/2020 2:26 | 11 |
P2 | 4/23/2020 3:26 | 1 |
P2 | 4/23/2020 4:26 | 2 |
P2 | 4/23/2020 5:26 | 3 |
P2 | 4/23/2020 6:26 | 4 |
P2 | 4/23/2020 7:26 | 5 |
P2 | 4/23/2020 8:26 | 6 |
P2 | 4/23/2020 9:26 | 7 |
P2 | 4/23/2020 10:26 | 8 |
P2 | 4/23/2020 11:26 | 9 |
P2 | 4/23/2020 12:26 | 10 |
P2 | 4/23/2020 13:26 | 11 |