Data not showing in GeoMap

  • 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
}

I was not allowed to paste all my screenshots in the initial post. Here is the input data:

@leifivarmyklebust what do you see in the query inspector? What kind of data source is that?
Also try to see if you can view the data returned from that query in table format and see if anything is being returned.