Skip to main content
Parked

Cognite Data Fusion: Include aggregates in the output from Synthetic TimeSeries

Related products:API and SDKs
  • May 3, 2022
  • 3 replies
  • 103 views

Forum|alt.badge.img

As a developer, I want to be able to retrieve min/max from synthetic time series and not just the average values, from the javascript sdk

 

The custom calculation feature in tnt is complicated by not being able to retrieve min max values from synthetic time series. We therefore have to load hourly granularity to show a representative time serie. We would like synthetic time series to return the min max values as well.

Should take into account that each time serie might not have max/min values at the same time within the granularity.

 

This has the highest priority from the Statnett App development team. 

3 replies

Anita Hæhre
Seasoned Practitioner
Forum|alt.badge.img+1
  • Head of Community
  • May 3, 2022
Updated idea statusNewGathering Interest

Anita Hæhre
Seasoned Practitioner
Forum|alt.badge.img+1
  • Head of Community
  • August 22, 2022
Gathering InterestParked

Ben Brandt
Seasoned
  • Seasoned
  • August 24, 2022

@RobersoSN Since this idea is “Parked”, one workaround I recently discovered is getting these types of aggregates from the PostgreSQL Gateway, which doesn’t have the Synthetic Time Series limitations.  The gateway is intended for data ingestion, but seems to be working now for querying DataPoints including their aggregates.  Personally, I’m really liking be able to query via SQL that I’ve used for 20 years instead of having to call an API that I learned a few months ago.  :-)

 


Setup and administration | Cognite Documentation
https://learn.cognite.com/postgresql-gateway