-
Grafana version and what operating system are you using? Grafana v8.1.4. Installed on Raspberry PI 4.
-
Trying to plot coordinates (latidude and longitude) as circles in a GeoMap panel. Ideally plotting a “trace” of points as the position (sailboat) moves, and with the size of the circles indicating boat speed (also available from influxDB)
-
Data fetched from influxdb as measurement “navigation.position”, which contains the lon an lat position (see screenshot below). I’m new to the lookup syntax in Grafana.
-
What happened: No data showing in plot. When selecting “Coords” instead of “Auto” in the Data layer dialog boxes, no data seem to be available for the “Longitude” and “latitude” fields.
-
What did you expect to happen? I expected to see data points in my map.
-
Can you copy/paste the configuration(s) that you are having problems with? See screenshots below. And JSON dump at the very bottom.
-
No error messages.
-
Did you follow any online instructions? If so, what is the URL? Various googeled examples.
{
"id": 23763571993,
"gridPos": {
"h": 11,
"w": 8,
"x": 16,
"y": 3
},
"type": "geomap",
"interval": "5s",
"fieldConfig": {
"defaults": {
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"mappings": [],
"color": {
"mode": "thresholds"
}
},
"overrides": []
},
"options": {
"view": {
"id": "coords",
"lat": 60.3788035,
"lon": 5.3296661,
"zoom": 12
},
"basemap": {
"type": "esri-xyz",
"config": {
"server": "streets"
}
},
"layers": [
{
"config": {
"size": {
"fixed": 50,
"max": 15,
"min": 2
},
"color": {
"fixed": "dark-red"
},
"fillOpacity": 0.4,
"shape": "circle",
"showLegend": true
},
"location": {
"mode": "coords"
},
"type": "markers"
}
],
"controls": {
"showZoom": true,
"mouseWheelZoom": true,
"showAttribution": true,
"showScale": true,
"showDebug": false
}
},
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "navigation.position",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"value\") FROM \"navigation.position\" WHERE (\"source\" = 'ActisenseUSB.2') AND $timeFilter ",
"rawQuery": true,
"refId": "A",
"resultFormat": "table",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"key": "source",
"value": "ActisenseUSB.2",
"operator": "="
}
]
}
],
"timeFrom": null,
"datasource": null
}
