Nodered to sqlite to grafana help

General
1

Hello again,
Does anybody use the sqlite+grafana combo? (influxdb is too complicated for me).
My time series column is TEXT datatype with “YYYY-MM-DDTHH:MM:SS” (tried different formats, without the "T" too).
Yet when I set "datetimestamp" to be recognized as a time series column, the values disappear.
When I leave it like that, i can see the values in the query table but no chart is drawn in both cases.
I know it's not the most node-red-ish issue, help please.
I was doing the same thing with node-red > csv > smb > grafana (different linux pc) and it worked flawlessly. I assume I don't have the right knowledge about the perfect sql query syntax for my case.

As timeseries;

image (1)
image (1)1804×674 52.8 KB

No timeseries;

image
image1739×573 60.8 KB

Thank you kindly for any advice.

2

Hi,
I don't have any experience with sqlite in combination with grafana so no ready to run solution from me :wink:
Have a look at this SQLite plugin for Grafana | Grafana Labs and then in particular the paragraph about Support for Time Formatted Columns
With the provided example you should get it working.

1 Like
3

Cheers mate, the "Z" was missing from the format's end.

4

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.