I have looked through topics here and seen, for example, someone saying you can add Cumulative sum calculation to a chart. I tried real hard to find CUSUM in the Operators list but can’t find it.
What I want to do is have a daily sum calculated (midnight-to-midnight) and scheduled no a daily basis
Best answer by Johannes Hovda
Can you just use the SUM aggregates directly?
+3Can you just use the SUM aggregates directly?
Excellent. Thanks. So that i where the “sum” aggregate is!!
That is exactly what I was looking for
Quick check: if I schedule that with a “day” granularity, will it do the calculation from midnight-to-midnight?
+3It should default to midnight to midnight:
Aggregates are aligned to the start time modulo of the granularity unit. If you ask for daily average temperatures since Monday afternoon last week, the first aggregated data point will contain averages for the whole of Monday, the second for Tuesday, etc.
https://developer.cognite.com/dev/concepts/aggregation/#granularity
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
