Forum Discussion

asganesh's avatar
asganesh
Microsoft Employee
5 years ago

Time Series with Scatter Plot

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

 

No RepliesBe the first to reply