- What Grafana version and what operating system are you using?
Grafana docker image
- What are you trying to achieve?
Query SQLite database to retrieve time-based events and plot the corresponding values
- How are you trying to achieve it?
Using the query
select started_at, pst_id from consolidated_results group by pst_id
- What happened?
started_at is empty. The other columns are correct.
- What did you expect to happen?
started_at to have data such as
- The same query done directly on the SQLite file with DB Browser for SQLite returns correct data.
- I am not sure yet that the format is correct for Grafana (I read the the UNIX epoch is better) - right now the date is not being pulled in at all so I would like to fix that first (and as I type this I hope it is not related)