I’m using Grafana 7.5.4
Using TrackMap to attempt to plot two lat/lng locations from a non time-series database and have a line drawn between these points.
Fields are latitude, longitude, and datecreated
datecreated is the 10 digit UNIX_TIMESTAMP.
CAST(latitude AS DECIMAL(10,6)) AS latitude,
CAST(longitude AS DECIMAL(10,6)) AS longitude,
FROM MyTable WHERE (narrow down selection)
ORDER BY datecreated ASC
The query inspector shows the two lat/lng and corresponding datecreated but nothing plots on the map.
Using the Grafana TrackMap Panel page but information is quite limited.