Extract event from time series

[Anonymous]

Hello Everyone

I need help to calculate duration of those events that occur in my data. In order to solve it, I have to be able to extract the start and end time from dataset.

So how can I achieve result as in the picture?

So how can I make a new tabel that contain all these "events", or make a new column where end time or start time of events is return as pictured below?

DATASAMPEL:

Server	Dato	Optaget ()
d2d3f	06.01.2020 09:29	0
d2d3f	06.01.2020 09:40	1
d2d3f	06.01.2020 09:44	1
d2d3f	06.01.2020 09:49	1
d2d3f	06.01.2020 09:59	0
d2d3f	06.01.2020 10:07	1
d2d3f	06.01.2020 10:15	1
d2d3f	06.01.2020 10:30	0
d2d3f	06.01.2020 10:43	1
d2d3f	06.01.2020 10:45	1
d2d3f	06.01.2020 11:00	0
d2d3f	06.01.2020 11:15	0
d2d3f	06.01.2020 11:21	1
d2d3f	06.01.2020 11:30	0
d2d3f	06.01.2020 11:45	0
d2d3f	06.01.2020 11:59	1
d2d3f	06.01.2020 12:00	1
d2d3f	06.01.2020 12:15	0
d2d3f	06.01.2020 12:25	1
d2d3f	06.01.2020 12:30	1
d2d3f	06.01.2020 12:45	1
d2d3f	06.01.2020 13:00	1
d2d3f	06.01.2020 13:15	1
d2d3f	06.01.2020 13:30	1
d2d3f	06.01.2020 13:45	1
d2d3f	06.01.2020 14:00	1
d2d3f	06.01.2020 14:07	1
d2d3f	06.01.2020 14:15	0
d2d3f	06.01.2020 14:30	0
d2d3f	06.01.2020 14:45	0
d2d3f	06.01.2020 15:00	0
d2d3f	06.01.2020 15:15	0
d2d3f	06.01.2020 15:30	0
d2d3f	06.01.2020 15:45	0
d2d3f	06.01.2020 16:00	0

[V-lianl-msft]

Hi @Anonymous ,

Can you format your data? And reupload the pictures of the results you expect.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous ,

Do you need a table to connect to the rest of your database or you want a visual with that data?

Best Regards,

Duarte Raminhos