Question about how to generate a new column named "cycle" to count cycle time? kindly help to suggest:
within same "group name", with column "date" time increase, column "count" value increases, after a certain level(max value is not fixed for each cycle), it will be back to a small one, which means another cycle start. Also need help to consider the raw data table sort properly by group name & Date.thanks
| 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 | 11 |
| 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 | 11 |
| 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 |
