Sqlite - Unable to graph data Switch to table view

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


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.

Can anyone point me in the right direction.

Thank you
Br,
kd

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

gb

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?

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;

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

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