-
What Grafana version and what operating system are you using?
Latest, Linux. -
What are you trying to achieve?
Taking the momentary watts data I’m inputting, and create a bar graph that converts to kWh per day (so I can see daily energy usage). -
How are you trying to achieve it?
Setup a bar graph using the sum() and math(/360000) setup. -
What happened?
Graph shows very wrong values per day, and the few days of data I have seem offset (i.e. I’m not seeing any data at all for today, but I’m getting a bar on the day before I started my influx database). If I set the bar graph to “today” time scale I get the correct tally. -
What did you expect to happen?
Expected to get a bar graph showing the correct KWH per day. -
Can you copy/paste the configuration(s) that you are having problems with?
SELECT sum(“Watts”) / 360000 FROM “autogen”.“iotawatt” WHERE (“sensor”::tag = ‘solar’) AND time >= 1682924400000ms and time <= 1685394119999ms GROUP BY time(1d) fill(null)
