Get the daily energy consumption and price for use in templates

[run]

I can’t seem to find any documentation on where to get access to the data displayed in the

type: energy-sources-table

component. I would love to just present the accumulated daily consumption and cost in a Mushroom card, along with the current spotprice and price level. The card will then link to the energy dashboard for details.

I see mentions of a Utility Meter - but really, the data is already calculated and is available to the above mentioned UI component?

Thanks in advance.

[tom_l]

@run

the data is already calculated

Indeed. It is calculated from the database tables as required fro the dashboard / cards, and not available as entities

[run]

Ok Is there some way to expose this data, in a consumable form, using e.g. a template entity or using another trick? I can work out the details myself, but any suggestion as to which approach to take, would be appreciated. Thanks!

[tom_l]

If you are any good with SQL I guess you could create entities with this:

SQL

[tom_l]

You could also vote for this:

WTH why can't I use the graphs as used for energy/solar/gas for other data

The energy dashboard has some nice graphs that can show usage/production per day/week/month/year. It would be nice if you could use those type graphs for other things to. For me I am interested in keeping an overview of the amount of data used on the internet connection. I have sensors that keep track of it, just no nice way to display it (with normal statistics graph it just shows the total ever, not usage per day/week etc… ). Would be useful for basically anything you want to keep track of u…

[run]

I did just that. Thanks

[cristimi (Cristi Militaru)]

Can you please share how your SQL sensors look like?