Sqlite - Unable to graph data Switch to table view

Grafana
1

Greetings. Newbie user alert :slight_smile:

I’ve just come across this great software. I managed to use sqlte-datasource plugin and grab the from the DB using query.

Data is there. I can see it in the table view, but not in the Graph view. It says Unable to graph data Switch to table view

graf1
graf11493×831 46.7 KB

I can see the timestamps are not in the same format as from TestDataDB.

If I add the Time in time formatted columns, all timestamps disappear.

graf2
graf21492×947 46.9 KB

Can anyone point me in the right direction.

Thank you
Br,
kd

2

Hi kd
have got exactly the same issue. have you had any joy getting it to work?

gb

3

In order to graph something, you need a time column and a value column. Usually when you get that error, it means you are missing one or the other.

This could also be a bug in the plugin, so you might want to check with the plugin author as well. Perhaps file an issue in the plugin repo?

4

Yes I got it to work with this query:

SELECT CAST(strftime(‘%s’, CHANGE_DATE, ‘-1 hour’) as INTEGER) as time, NEW_VALUE as value1 FROM DEVICE_VALUE_HISTORY WHERE DEVICE_REF =1778;

graf
graf1186×908 32.7 KB

5

kdiamond
Im stuck with the same problem, and I struggle to solve it. Can you help me ?

6

Hi atlshelia

i got my issue fixed with below query
select
strftime(’%Y-%m-%dT%H:%M:%S.000Z’,timestamp,’-2 hours’) as time
from table;

the main issue I had, was with the needed date format.
The standard ISO format 2013-02-04T22:44:30.652Z.worked fine for me