i have a simple SQLite database which contains a timestamp, a value with a current consumption and a value with summarize the consumption. The values are updated every 10 seconds.
Now i tried to make a dashboard which summarize the consumption for each day (for the last 7 days). I thought this is a easy think. But im failed…
So your issue is really not grafana but sqlite query language. You would get more traction if you posted on a sqllite forum. But that said what you have is not being grouped by anything neither by Zeit nor by date
All you are doing is taking the max and min and getting the difference.
sorry i forgot the last screenshot. When i add the “group by query” than nothing happens. But nothing is not correct. The value of “Tagesverbrauch” switch to zero…
The target should be, that the query take the min and max value (of each day) and calculate the consumption for each day. But im not able to Group the values day by day and im not sure, what is the problem. Is the problem the format of the time, is there a problem with the query, or is there a other problem.
Just as a hint. You indeed have an SQL problem (nothing about Grafana or the plugin).
When you do “group by zeit”, then in SQL all the values with the same Zeit value are grouped. This makes no sense in your case as you only have one value per Zeit. With only one value your grouping does nothing and the min and max are the same value (which makes the difference 0 of course).
