Hello,I want to split the value between two timestamps into 15 minutes, so I have 96 records per day.I have this table:
I want this table:
I also need a record when the value is 0, so for everyday 96 records.I really hope someone can help me!Thanks!
I'm not sure how the Value is calculated here. But see how the Bucket can be created.
,Date(Floor(Date#(TimeStamp_Start, 'MM.DD.YYYY hh:mm'))) As Date_Start
,Date(Floor(Date#(TimeStamp_Start, 'MM.DD.YYYY hh:mm'))+15*(IterNo()-1)/(24*60)) As Bucket_Start
LOAD * INLINE [
ID, TimeStamp_Start, TimeStamp_End, Value
123456, 01.03.2020 05:42, 01.03.2020 06:11, 567
987654, 01.04.2020 02:57, 01.05.2020 00:10, "12577,68"
Hi,the "new" Value should be calculated by the minutes between TimeStamp_Start and TimeStamp_End.Value / (TimeStamp_End-TimeStamp_Start)
Can someone please help me!