Transform function not calculating on Solar dashboard

[mitya969]

HI All,

I’m a noob here and new to Grafana, so please forgive me if this is a really basic question.

Grafana v 7.5.2
InfluxDB v 4.4.1
Home Assistant OS 7.6
Raspberry Pi 3

I’ve setting up a Solar dashboard that has a number of panels that show generation over time, generation now, exported energy, consumed energy, etc… All has gone well and I’ve been able to utilise the data captured in Home Assistant via the MyEnergi integration. I’m stuck however, trying to calculate the cash value offset against grid consumption.

I’ve created two queries and the 3rd is a result of a “Transform” binary operation that adds the result of the two queries. As you can see the transform doesn’t appear to be calculating as expected.
Here are screenshots for showing the queries
Grid Import (see output of the queries above and you can see that the calculated total is zero but should be -£0.54)

Solar Generation
Removed as I’m only able to post 2 images but the query is the same as above but with a different entity.

Total

Any assistance would be appreciated as this is all new to me.

[usman.ahmad]

Hi @mitya969 , welcome to the community forums.

Thanks for providing the details.

We had tried to reproduce it but were not able to as it seems to work fine when doing the transformation of the 2 queries (Grid + Solar)

Therefore, can you please follow these steps to share your raw unformatted data? That way, the community can try and mock up your problem

show-inspect-data