I have some data in a mysql data base that is used as datasource. With a query, I get all values of power consumption for each day and I want to show them in a graph, but I did not find how.
With a table panel, I can see this:
But I only can show a graph like this:
The graph is displaying hours, not only days.
This is how my query looks like:
SELECT last_changed AS "time", SUM(state) AS "state" FROM states WHERE entity_id = 'sensor.consumo_electrico' GROUP BY CAST(last_changed AS DATE) ORDER BY last_changed
Is it possible to show only one bar per day? I am not sure if by hours is the only way…