Our time series data from our sensor store in Sqlite db file.
I am using the plugin sqlite-datasource and not able to create dashboard to visualize data as graph (line or bar)
I am trying to use following query with “Time series” but it is failing with error “not enough args to execute query: want 1 got 0”
strftime(’%s’, RecordDateUTC) as time_sec,
cast(lastReading as signed) as value,
moduleName as metric
ORDER BY RecordDateUTC ASC
The actual data when make following query to the table is as follows
SELECT RecordDateUTC, lastReading FROM sensorData WHERE moduleName=‘myPh’ AND sensorType=‘pH’
The result look as follows
Please help me so that I can create the graph - line/bar.