Skip to main content
Solved

Synthetic timeseries API does not support "sum" aggregation

  • November 16, 2022
  • 2 replies
  • 90 views
M
Committed
Forum|alt.badge.img

In grafana, we want to display total of all timeseries data-points for all assets connected to particular asset for which we are passing query like this:

ts{assetSubtreeIds=[{id=$Org4}], name='oil-production-rate'}

where value of $Org1 is coming from dashboard variable.

and since cognite grafana plugin does not handle cursor api responses and synthetic timeseries api have some limitation in returning 10k records only in a request, to reduce number of data-points, we are trying to use aggregation: ‘sum’ and granularity: ‘30d’ since there could be more than 10k data-points.

 

But its is throwing error saying “sum” is not valid aggregation type of synthetic timeseries.

 

Any reason why “sum” aggregation is not supported for synthetic timeseries.

(screenshot attached)

Best answer by Shashan Udawatte

Hi Mithul, as mentioned in the docs the aggregate must be one of interpolation, stepinterpolation, or average for synthetic time series. We are currently only supporting mentioned aggerates for synthetic time series. Although if you want to add sum as an aggregate, you need to add it as a feature request. 
Please submit your feature request here, by clicking the Give Product Feedback button. Once you have submitted your feedback, you will now also be able to track its progress!

View original
1 Attachments
Did this topic help you find an answer to your question?

2 replies

S
Practitioner
Forum|alt.badge.img+1

Hi Mithul, I have replied to this question in the ticket 6916. Please refer the ticket for my answer. 

S
Practitioner
Forum|alt.badge.img+1

Hi Mithul, as mentioned in the docs the aggregate must be one of interpolation, stepinterpolation, or average for synthetic time series. We are currently only supporting mentioned aggerates for synthetic time series. Although if you want to add sum as an aggregate, you need to add it as a feature request. 
Please submit your feature request here, by clicking the Give Product Feedback button. Once you have submitted your feedback, you will now also be able to track its progress!

Reply


Terms & ConditionsCookie Settings

Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings