Current Dataset:
The current dataset, the datetime are together in a column with a measure called Incidents.
| DateTime | Incidents |
| 2022-01-03 00:00:00 | 0 |
| 2022-01-03 00:30:00 | 0 |
| 2022-01-03 01:00:00 | 2 |
| 2022-01-03 01:30:00 | 1 |
| 2022-01-03 02:00:00 | 4 |
| 2022-01-03 02:30:00 | 5 |
| 2022-01-03 03:00:00 | 1 |
| 2022-01-03 03:30:00 | 2 |
| 2022-01-03 04:00:00 | 0 |
| 2022-01-03 04:30:00 | 2 |
I would like to split the time out into a table seen below:
New Column:
1) Period - 30 minutes interval with the name stated
2) Period Number - Period 1 to 48 since there are 48 periods in a day (30 minutes interval)
This is just a snippet of the data and I would like to include for multiple days and data are running in all 24 hours (12am to 12am - 48 "30 minutes" period interval)
| DateTime | Incidents | Period | Period Number |
| 2022-01-03 | 0 | 12am to 12.30am | 1 |
| 2022-01-03 | 0 | 12.30am to 1am | 2 |
| 2022-01-03 | 2 | 1am to 1.30am | 3 |
| 2022-01-03 | 1 | 1.30am to 2am | 4 |
| 2022-01-03 | 4 | 2am to 2.30am | 5 |
| 2022-01-03 | 5 | 2.30am to 3am | 6 |
| 2022-01-03 | 1 | 3am to 3.30am | 7 |
| 2022-01-03 | 2 | 3.30am to 4.00am | 8 |
| 2022-01-03 | 0 | 4am to 4.30am | 9 |
| 2022-01-03 | 2 | 4.30am to 5am | 10 |
