The example above shows that 1h aggregates of type average computed at time-point 03:00 takes into considereation the interpolated values in the time-span 03:00 to 04:00. Is it always like this as long as i choose granualarity 1h ?
I could not find the answer to my question here:
Aggregation | Cognite documentation
Best answer by Håkon V. Treider
I am not entirely sure I get your question, but I’ll try to answer as best as I can! 
The timestamps for aggregates are labelled by the left boundary. That means the period from 03:00 (inclusive) to 04:00 (exclusive) will be labelled as 03:00.
In your data above, for the aggregate data point at 03:00, with the value 0.0 is zero because all datapoints inside and the two outside points (for the purpose of interpolation to the boundary) are zero.
The aggregate data point, at 04:00, with the value 0.125 can be computed as follows:
I hope this addresses at least some parts of your question!
I am not entirely sure I get your question, but I’ll try to answer as best as I can!
The timestamps for aggregates are labelled by the left boundary. That means the period from 03:00 (inclusive) to 04:00 (exclusive) will be labelled as 03:00.
In your data above, for the aggregate data point at 03:00, with the value 0.0 is zero because all datapoints inside and the two outside points (for the purpose of interpolation to the boundary) are zero.
The aggregate data point, at 04:00, with the value 0.125 can be computed as follows:
I hope this addresses at least some parts of your question!
Thanks, I agree with the computed value. The last thing I wonder about is how/if I can be sure that no matter how the original datapoints are distributed with respect to time, the average for hourly aggregates computed at say 01:00 will always be based on the weighted averages over the timespan from [01:00; 02:00[ .
Thanks, I agree with the computed value. The last thing I wonder about is how/if I can be sure that no matter how the original datapoints are distributed with respect to time, the average for hourly aggregates computed at say 01:00 will always be based on the weighted averages over the timespan from [01:00; 02:00).
Almost yes; the start and end of the interval can be influence by outside points. I made an illustration to show it better, modifying the illustration in the documentation:
Here you have two points inside the interval (green), one point before (red) influencing the part of the average from the left boundary to the first inside datapoint (same and opposite argument for blue / datapoint after the interval).
Thanks a lot Håkon. We are comparing the measurements from some standard sensors with those from fiscal meters that by design display hourly averages. So, when averaging the measurements from standard meters we needed to know what was done so they are averaged in the same way.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
