Processing time series – aggregating into defined 15-minute time intervals
Hello,
I have a table consisting of the following columns:
timestamp (date and time)
Station (integer)
Measurement1 (number)
Measurement2 (number)
The table should be aggregated into 15-minute intervals.
For Measurement1 and Measurement2, the mean value should be calculated if two or more measurements fall within the same interval.
I asked the AI about it. It suggested using the "Date & Time Aggregator."
However, there’s no option to set a 15-minute interval for the minutes, and you can only select a single column.
Completely useless.
And these nodes don’t get you any further, either.
How can this be solved?
Regards, Patrik