Problems with data transformation

Hello everyone,

Installation information:
Grafana is wrapped in Home Assistant
HA version:
Core: 2023.11.3
Supervisor: 2023.11.6
Operating System: 11.1
Grafana version: 9.1.1

I don’t understand how the transformation works even though I’ve documented it.

When I try to average all the averages, the result is never correct.

When I want to add up the last values, it’s the same thing.

The total of the averages, the average of the last values, everything is never correct.
Just the sum of the sums is correct.

Is this the version I’m using or something else?

Thank you for your future answers