I have 10 years of energy measures in a MYSQL database.
I downloaded this app but dont get it to work. Dont see any numbers.
The query I am using looks like this.
SELECT counts_a_60 AS ‘power’, counts_a_24 AS ‘meter’ FROM answers a ORDER BY Created DESC LIMIT 1;
I can test my sql statement in query browser and it returns values ok, see picture