Another issue where I don’t know how to solve - and the google solutions didn’t work.
I built a water meter for monitoring the water consumption of my house. In fact its a webcam over the meter and some python code for interpreting the pointer. If there is a change it is writing the difference (>0.25 liter) into an InfluxDB.
Now I want to visualize the consumption in a lovelace statistic card and thought the easiest way would be to create a sensor which is reading the last value from this DB table. Something like this:
SELECT last("Current_Consump") AS "mean_Current_Consump" FROM "water"."autogen"."Consump"
How can I create this?
And overall, is this a good solution or are there better ways to do so?
Thanks in advance and cheers