Total calculations sometimes not showing

  • What Grafana version and what operating system are you using?
    Grafana 9.0.2, Ubuntu 20.x.x and InfluxDB 1.8

  • What are you trying to achieve?
    Always showing the totals

  • How are you trying to achieve it?
    By making 4 seperate query’s and combining them in the Transformations tab

  • What happened?
    Somethimes the total value of two rows is not shown while there both visible and from the same table.

  • What did you expect to happen?
    Always showing a total value

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No errors to find what so ever only NaN errors which cannot be true

So the value Voorzijde totaal is a binary operation from Voorzijde PV 1 and 2.
Both values are collected in a seperate query but are limited to 1 for the last value.
Query C and D are seperate but come from the same InfluxDB series/table.

The values in the Explore screenshot differ from the one above since a refresh in between

Why is Voorzijde totaal empty / NaN but the values are showing in the query’s tab?