The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I would like to have something similar to the below, where each blue mark represents duration of a service call at a specific start time, but the orange represents the time series in which a Node Drain is In Progress.
At the moment, I was able to get the scatter plot together, but i'm not sure how to pull in the time series:
My thought is i take this data and mark each second inside the index as "Node Drain In Progress". How can i splice up this time below so for each index there are multiple entries for the time the index interval is inside. For example:
So ideally, here I would have multiple entries for Index 0 where it would look like:
0 10/19/2020 10:18:31 Node Drain in Progress
0 10/19/2020 10:18:32 Node Drain in Progress
....
0 10/19/2020 10:19:30 Node Drain in Progress
0 10/19/2020 10:19:31 Node Drain in Progress