Forum Discussion
Aggregation(sum) from time column
Do you want a rolling 3 hrs (so for each row, add up all values in the last 3 hours) or do you want to define periods of 3 hours from the first row 1500-1800, 1800-2100 etc?
Perhaps you could reply with the desired output from the supplied dataset (also can you post the dataset as data and not a picture please?)
Hi HotChilli ,
Thank You! there is value for each 15 min. but i would like to have value as aggregated by 3 hours. the desired output as follows:
value
DateTime
Calculated column 1 (Date/Time)
calculated column2 (value)
0.004
04-03-2019 15:15:00
04/03/2019 15:00
aggregated value
0
04-03-2019 15:45:00
04/03/2019 18:00
aggregated value
0.002
04-03-2019 16:00:00
04/03/2019 21:00
aggregated value
0.001
04-03-2019 16:15:00
04/03/2019 00:00
0
04-03-2019 16:30:00
04/03/2019 03:00
0.001
04-03-2019 16:45:00
04/03/2019 06:00
0
04-03-2019 17:00:00
04/03/2019 09:00
0
04-03-2019 17:15:00
04/03/2019 12:00
0.001
04-03-2019 17:30:00
04/03/2019 00:00
0
04-03-2019 17:45:00
04/03/2019 03:00
0.001
04-03-2019 18:00:00
04/03/2019 06:00
0
04-03-2019 18:15:00
04/03/2019 09:00
0.001
04-03-2019 18:30:00
04/03/2019 12:00
0
04-03-2019 18:45:00
06/03/2019 15:00
0.001
04-03-2019 19:00:00
06/03/2019 18:00
0
04-03-2019 19:15:00
06/03/2019 21:00
0.001
04-03-2019 19:30:00
07/03/2019 00:00
0
04-03-2019 19:45:00
07/03/2019 03:00
0
04-03-2019 20:00:00
07/03/2019 06:00
0
04-03-2019 20:15:00
Thank you!