Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Extract event from time series

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:

ServerDatoOptaget () 
d2d3f06.01.2020 09:290
d2d3f06.01.2020 09:401
d2d3f06.01.2020 09:441
d2d3f06.01.2020 09:491
d2d3f06.01.2020 09:590
d2d3f06.01.2020 10:071
d2d3f06.01.2020 10:151
d2d3f06.01.2020 10:300
d2d3f06.01.2020 10:431
d2d3f06.01.2020 10:451
d2d3f06.01.2020 11:000
d2d3f06.01.2020 11:150
d2d3f06.01.2020 11:211
d2d3f06.01.2020 11:300
d2d3f06.01.2020 11:450
d2d3f06.01.2020 11:591
d2d3f06.01.2020 12:001
d2d3f06.01.2020 12:150
d2d3f06.01.2020 12:251
d2d3f06.01.2020 12:301
d2d3f06.01.2020 12:451
d2d3f06.01.2020 13:001
d2d3f06.01.2020 13:151
d2d3f06.01.2020 13:301
d2d3f06.01.2020 13:451
d2d3f06.01.2020 14:001
d2d3f06.01.2020 14:071
d2d3f06.01.2020 14:150
d2d3f06.01.2020 14:300
d2d3f06.01.2020 14:450
d2d3f06.01.2020 15:000
d2d3f06.01.2020 15:150
d2d3f06.01.2020 15:300
d2d3f06.01.2020 15:450
d2d3f06.01.2020 16:000
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago
    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.