I've managed the conversions directly at the server side.

Hi Raluca, 

Are you aware that we introduced Unit support in CDF recently?  You can store your data points with a unit of grams, but specify the output of a query to be in pounds if you wish (conversions are calculated at query time and are not persisted).

This approach allows you to preserve the integrity of the original source data.

Here’s a link to the developer guide, if this is useful https://developer.cognite.com/dev/concepts/resource_types/units/

Thank you, @Glen Sykes , I'm aware of this, but we need to account for some decimal offsets too during conversion.

Ah ok.  I’m glad you were aware of the feature then at least. 

Just for reference, I believe you could accomplish the goal using a combination of a synthetic time series query with units and unit conversion.

https://developer.cognite.com/dev/concepts/resource_types/synthetic_timeseries.html

This would allow you to keep the data points in their original format in CDF and have a more visible audit trail as to how the data point values are what they are, within CDF.

Hope this is helpful? 

Best wishes from the CDF product team!

Glen
 

Thank you, @Glen Sykes , very helpful! Will look into it.

Regards,

Raluca

Hi @Raluca Bala,

We are following up to see whether you're satisfied with the responses you've received? 

Hi @Dilini Fernando ,

I've managed the conversions directly at the server side.

Thank you for your support.