I’m storing a current and voltage value in InfluxDB. I’m trying to use the new Transformation function in Grafana to calculate power in a graph.
It seems to work, but because current and voltage are not collected at the exact same moment, I see a lot of null values. I have “Null value -> connected” set, and it works for the current and voltage data sets. But the transformation graph shows spikes and 0 values, not the expect line.
Could it be that the transformation returns 0 and not null when one of the two is null?
Any way to work around this?