Time series for runtime

HValderrama

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

Turribeach

Why can't it be done in Python? Where is this dataset stored on? (ie which technology).

HValderrama

The preference is to use the Dataiku Recipe and not code in Python. Data is stored on an SQL database Azure Synapse.