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.
Thank you kindly for any advice.