Energy-distribution - Values available as sensors?

[ScooterAssistant]

Hey there.
Is there any way to get the values shown on the distribution-card as sensor-values?
energy distribution

[tom_l]

If you know SQL you could create an SQL sensor to query the statistics table of the database.

SQL

This one is for MariaDB:

Extract complet Sensor values from Database

Thanks! SELECT mean,min,max,from_unixtime(start_ts) FROM statistics WHERE metadata_id = ( SELECT id FROM statistics_meta WHERE statistic_id = 'sensor.strom_waschmaschine_voltage'); Did the trick!

[ScooterAssistant]

Thanks for the quick answer. But i don’t know SQL. So i assume that there is no “classic” sensor to use and i need to do all the math, HA already does anyway (adding all sensors etc…)?

[tom_l]

Correct, but HA only does the calculations when the stats are viewed.