Issues creating a KWH per day bar graph

  • 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)