Dashboard for sqlite3 data, find no way to configure a Time Series
Thank you first for your fast answer !
Sorry, in my original post there was the table as well as 2 snapshots of my result and a further description. Try again …
I think I have tried all possible conversions and casts of my timevalues “ts” in the table, except one missing as correct 
The best result was a Dashboard without the Error “Data is missing a time field”, see snapshot. But time is 1970, all values are on a vertical line.
The table consists PV Data, Power of R/S/T, Network in/out, Battery load and status, marked by the “id”.
What I would need is a first step of a working Dashboard with time and one of the values (WHERE id = 1), in best case with graph of all 7 lines.
Here is the table
Snap 1
Snap 1 in table view
Grafana Time Series panel only works if your query returns a proper time field.
Please share your sqlite3 table you are querying. Basically you want the following
Select log_date as time,
Name as metric,
Interval as value
From zi.table
Order by log_date asc
Make sure to not pick Table format
Restored my post, could you please have a look to it again?
Thank you, Klaus
Thank you for the link, but it is a general info as I found a lot the last two weeks. I dont get it. Please have a look to my restored post again, thank you!
Looks like your time column is missing values?
Maybe you can use the convert transformation
No conversion needed, somtimes it is more easy than thought. 3 different Queries for each value
SELECT ts/1000 as time, val as PowerT FROM ts_number
where id = 1;
SELECT ts/1000 as time, val as PowerS FROM ts_number
where id = 5;
SELECT ts/1000 as time, val as PowerR FROM ts_number
where id = 6;
give the result:
