Grafana - Timeseries plot doesn't work (SQLite database)-CodePudding

I've been trying to make a timeseries plot in Grafana, but I keep getting messages like "Data does not have a time field" or "No numeric fields found." How could I format my data to fix these issues? Thank you!

CodePudding user response：

See README of used plugin first https://grafana.com/grafana/plugins/frser-sqlite-datasource/ :

Your ts column is not formatted in accordance with RFC3339.
Your value_string is a string and not numeric - REAL type.

CodePudding user response：

Reformat your time variable in SQLite to Unix time format, ie strftime("%s" , my_time_var ).

Then in the grafana query dialog define my_time_var as a time formatted column of a Time Series.

I don't know if it also works in Windows.