I have a downtime dataset with assets, downtime start, and downtime end. I want to create a recipe in Dataiku without using Python to create a time series with the downtime and run time. 1 for downtime and 0 for running.
Here is an example of the data set:
| Asset | downtime_start | downtime_end | status |
| 123 | 01/15/23 11:00 am | 01/15/23 1:00 pm | 1 |
| 123 | 01/15/23 1:45 pm | 01/15/23 3:00 pm | 1 |
| 123 | 02/01/23 6:20 am | 02/03/23 4:00 pm | 1 |
| 789 | 01/01/23 7:48 pm | 01/02/23 7:49 pm | 1 |
I want the time series to start on the first downtime on 01/01/23 and keep until the last downtime on 02/03/23. Fill in the values for each asset for the date and time it was running with 0 in the Status.
Operating system used: Windows
