How to obtain the energy cost in a template?

Configuration
1

Hi!

Is it possible to extract the energy cost automatically calculated on the energy dashboard using a template? I want to display the value in a specific way on a dashboard?

Thanks :slight_smile:

2

The calculated values do not have entities associated with them that you can access in a template.

If you know SQL you might be able to query the recorder database to obtain the value you want with an SQL sensor.

3

Good point :+1:

I do know SQL, but as the cost does not have an entity, I am unable to find any information about it in the DB. These are the tables I see:

Skærmbillede 2022-05-26 kl. 14.03.28
Skærmbillede 2022-05-26 kl. 14.03.28384×670 63.7 KB

Any idea where I might find the energy information? It MUST be there, unless it is calculated on the fly from the previous energy usage and kWh costs (?)

4

it would be in the statistics tables.

5

But, isn’t everyting in the statistics table linked to entities as well?

6

I don’t know, I haven’t looked in the tables. FYI this isn’t something that people are going to know off the top of their head. You’re going to have to look for it yourself. It’s also possible that it’s not in the tables and you have to perform a summation on the data yourself.