Dashboard SQLite Query Group by Day

Grafana Dashboards
1

Hi,

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…

This are my Tables:

image
image1402×822 46.7 KB

i tried this which calculate the difference from the beginning to the end of database:

image
image1402×832 32.4 KB

But when i group it by “zeit” than there is no group and the value is zero

Of course i tried much much more and yes, i also used google…
Now the question, where is my fault? What i have to change?

2

Welcome

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.

I would encourage you to read this doco

3

Hi,

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…

image
image1410×771 37.3 KB

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.

1 Like
4

Did you read the doco I posted?

Here is a good forum yo ask this question at.

https://sqlite.org/forum/forum