Hello,
Some weeks ago, I set up InfluxDB to monitor my solar panels over a longer time.
I have not done much yet with influxDB/Grafana, just created one graph.
This is the config, i wanted to start with one sensor only:
> influxdb:
> host: 192.168.1.99
> port: 8086
> database: homeassistant
> username: user
> password: password
> ssl: false
> verify_ssl: false
> max_retries: 3
> default_measurement: state
> include:
> entities:
> - sensor.pv_strom_gesamt
And this is the query in Grafana. Just selected the sensor from the gui
SELECT mean("value") FROM "autogen"."Watt" WHERE ("entity_id" = 'pv_strom_gesamt') AND $timeFilter GROUP BY time($__interval) fill(null)
Now this is what I get: 1st picture is a lovelace sensor card, 2nd is a Grafana Graph.
We are looking at last Sunday, the 26th. Why is the “Max” Value in the Lovelace card another than the one in the Grafana chart? Is there something missing in the config or the query?
Thanks for any comment on this
Philipp