i use grafana with influxdb and I’m collecting values from OpenHab.
Database in very simple, 2 columns:
Openhab save values for power consumption in €.
The graph with the lines shows correct values but the graph with the bars show a much too high value.
I would like to see the daily electricity costs.
The following query is executed
SELECT mean(“value”) FROM “Strom_Summe” WHERE $timeFilter GROUP BY time($__interval) fill(null)
SELECT count(“value”) FROM “Strom_Summe” WHERE $timeFilter GROUP BY time(1d)
Can someone tell me what I do wrong?