The energy dashboard has some great graphs and panels. I configured the cost of my electricity and get a great read out of how much I’ve spent today/this week/last year on electricity for each appliance. [image] This can be added to a dashboard via one of the energy cards, but I don’t see anywher…

Two options: you address this via SQL (this is in the statistics table) or you add your own sensor, e.g. utility meter(s) Utility Meter - Home Assistant (home-assistant.io) SQL - Home Assistant (home-assistant.io)

Thanks for the links, it would be great if this data was accessible via a sensor, but there is a workaround at least.

I just wanted to add some info on this because although these forums are great I really struggled to get enough info and I’m sure I am not alone. HA is quite difficult and very tricky to get right. So I’ll go through the steps I have taken as a newbie, some of these will be obvious to some but perha…

[image] riccol1966: SELECT * FROM “statistics_meta” where statistic_id like ‘%study%’ Many thanks for this contribution Richard. Could you please verify exact syntax of the “select query” that goes into the SQL integration? I am getting “SQL Query invalid” when entering the following (your q…

[image] riccol1966: SELECT round( (SELECT round(max(sum), 2) FROM “statistics” WHERE metadata_id = 6 AND date(created_ts, ‘unixepoch’) = date(‘now’)) (SELECT round(min(sum), 2) FROM “statistics” WHERE metadata_id = 6 AND date(created_ts, ‘unixepoch’) = date(‘now’)), 2) AS sum you have…

[image] tvandenbroeck: SELECT round( (SELECT round(max(sum), 2) FROM statistics WHERE metadata_id = 317 AND date(created_ts, ‘unixepoch’) = date(‘now’)) - (SELECT round(max(sum), 2) FROM statistics WHERE metadata_id = 317 AND date(created_ts, ‘unixepoch’) = date(‘now’, ‘-1 days’)), 2) AS sum T…

Thanks for the post! Exactly what I needed! For anyone else coming along to this thread. The SQL posted by @flyingpenguin only works if youre in CDT. Here is how to make it work for other timezones. SELECT round( (SELECT max(state) FROM "statistics" WHERE metadata_id = 61 AND date(created_ts, 'un…

When I search for my energy sensor in Developer tools, States, I find another hidden sensor ending with cost that I use. Hope that can help you

Hello, is it possible to calculate the household’s general consumption costs outside of the energy screen? I’m isolated and don’t have grid consumption, and I wanted to create a template with the fixed expenses and consumption.

Access cost information from Energy dashboard graphs

Energy

flyingpenguin (Joost Perquin) December 8, 2023, 7:28pm 7

Thanks for the quick reply!

Not sure what I am soing wrong… but still getting “SQL query invalid”

New Energy flow Sankey chart: very nice, but upstream devices break floors and areas?