AMG Grafana transform calculation problem

Question

I'm trying to calculate the sum of 2 data stream values(double) in AMG (sitewise data source/disassociated data stream) and present the calculated result in a timeseries panel.
I have attempted to use transform 'Add field from calculation':  Using 'Mode' binary operation', operation 'datastream1 + datastream 2' without success.
How can I calculate fields in AMG ? Any tips will be welcome!

Answer

Hi Jason,

Your issue is likely due to a different time precision in each datastream. Look at the example below.

Note the difference in `offsetInNanos` for timestamps 1662866820 and 1662866830. When the offset is different in each datastream, Grafana Binary operation returns a NaN.

![Enter image description here](/media/postImages/original/IM2mqpZDaMS0mGfCyv8IjzoA)
![Enter image description here](/media/postImages/original/IM5cCNCdP2SyGDcluAND8xGg)

If this is helpful, consider accepting the answer.

Raju

AMG Grafana transform calculation problem

Contenus pertinents