Is it possible to integrate(totalize) analog data from mariadb/mysql?

I am using the Tado component, and with the available sensors I’d like to make a quantification of the power used for heating.

Concretely, with the _power sensor I can get readings like this, where I can see how opened is a radiator valve (and proportionally how much energy is being used to heat the room):
image
The recorder data is being saved in the mariadb server addon, but I’d go the InfluxDB way if necessary.
How could I extract a daily integration of these sensors?

or https://www.home-assistant.io/components/utility_meter/

1 Like

Thanks! I had’nt noticed this new component since I’m stuck in an older version.
I think I’ll combine this with an automation to calculate the daily power used.