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!