[SOLVED] How can I access accumulated Grid totals from Energy Dashboard?

The Energy Dashboard is great!

I currently have been putting my energy data into InfluxDB and charting daily kWh usage in Grafana.

Now that the Energy Dashboard has the Grid total value is there a way that I can access that value and chart a monthly graph for each day, similar to what I’m doing in the above chart?

I found this doc reference. Nice the values are part of the sql db.

I just have to do a few queries like this against the statistics table:

SELECT MAX(sum)
FROM "statistics" WHERE metadata_id = "31" and start >= '2021-08-10 00:00:00' and start < '2021-08-11 00:00:00'

And and add/subtract the appropriate IDs

Hi Gregtd,
I am also interested in this, however reading the reference doc, I can’t seem to determine a few things.

  • How you can access ‘statistics’ in your influxdb database
  • Where you’re obtaining the metadata_id from.

I know this is an outdated thread - but no one seems to be interested in that Grid total $, as per your original query.

Any insight into how to access the stats in influx / grafana would be greatly appreciated.