Hello I’m running Grafana version 9.1.7 on Windows 10.
I’m trying to plot a Track och GPS positions in TrackMap v 2.1.4 (TrackMap plugin for Grafana | Grafana Labs).
I’m trying to plot it as a time series. I’m using a MySQL database and my query looks like this:
SELECT
timestamp as time_sec,
CAST(latitude AS DECIMAL(10,6)) AS latitude,
CAST(longitude AS DECIMAL(10,6)) AS longitude
FROM coords
WHERE $__timeFilter(timestamp) AND id = 1
ORDER BY timestamp ASC;
There is no error just an empty panel.
I can see the results in the table view. But all the coordinates only have one decimal number.