Getting sum of values of the day in Gauges

Grafana Time Series Panel
1

Hello,

I’ve recently discovered Home Assistant / InfluDB / Grafana and would like to use these to 2 things:

  • Displaying a Graph of the current day in W with values from gathered my smartplugs, the total consumption of the house, my EVSE and the PV production → That’s done

    grafana_1
    grafana_11162×528 38.5 KB

  • Displaying Gauges of the same day in kWh with the sum of these devices/sensors… And I can’t get the this right.

I have this:
SELECT sum("value") FROM "W" WHERE ("entity_id" = 'evchargingpower') AND $timeFilter GROUP BY time($__interval) fill(0)

The values are sent to HA/InfluxDB every minute or for some devices every two minutes…

Many thank in advance