Data not showing in GeoMap

Grafana
1

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

Untitled
Untitled1816×887 127 KB

Untitled
Untitled1900×903 191 KB

{
  "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
}
2

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

Untitled
Untitled1466×648 23 KB

3

@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.

4

Maybe same bug as described here

5

This topic was automatically closed after 365 days. New replies are no longer allowed.