Geomap panel not working for me

  • What Grafana version and what operating system are you using?
    8.4.1

  • What are you trying to achieve?
    show location of a device on geomap-panel

  • How are you trying to achieve it?
    from a gps-device i store with node-red latitude and longitude vales into two fields of a influxdb database. in grafana i setup a dashboard with geomap-panel and defiened two querys, one for the latitude and one for the longitude. configured the panel to use coordinates. see config at the end.

  • What happened?
    no data point on the map

  • What did you expect to happen?
    a cross-mark at the location of latitude and longitude

  • Can you copy/paste the configuration(s) that you are having problems with?
    yes, see below dashboard-json

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    no

  • Did you follow any online instructions? If so, what is the URL?
    tried to use the geomap-panel documentation site unfortunately without success

Thanks for your support

{
  "annotations": {
    "list": [
      {
        "builtIn": 1,
        "datasource": "-- Grafana --",
        "enable": true,
        "hide": true,
        "iconColor": "rgba(0, 211, 255, 1)",
        "name": "Annotations & Alerts",
        "target": {
          "limit": 100,
          "matchAny": false,
          "tags": [],
          "type": "dashboard"
        },
        "type": "dashboard"
      }
    ]
  },
  "editable": true,
  "fiscalYearStartMonth": 0,
  "graphTooltip": 0,
  "id": 11,
  "links": [],
  "liveNow": false,
  "panels": [
    {
      "datasource": {
        "type": "influxdb",
        "uid": "s8Go0hRRz"
      },
      "description": "",
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "decimals": 1,
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 16,
        "w": 24,
        "x": 0,
        "y": 0
      },
      "id": 2,
      "options": {
        "basemap": {
          "config": {},
          "name": "Layer 0",
          "type": "osm-standard"
        },
        "controls": {
          "mouseWheelZoom": true,
          "showAttribution": true,
          "showDebug": false,
          "showScale": true,
          "showZoom": true
        },
        "layers": [
          {
            "config": {
              "showLegend": true,
              "style": {
                "color": {
                  "fixed": "dark-red"
                },
                "opacity": 0.4,
                "rotation": {
                  "fixed": 0,
                  "max": 360,
                  "min": -360,
                  "mode": "mod"
                },
                "size": {
                  "fixed": 5,
                  "max": 15,
                  "min": 2
                },
                "symbol": {
                  "fixed": "img/icons/marker/cross.svg",
                  "mode": "fixed"
                },
                "text": {
                  "field": "Value",
                  "fixed": "",
                  "mode": "field"
                },
                "textConfig": {
                  "fontSize": 12,
                  "offsetX": 0,
                  "offsetY": 0,
                  "textAlign": "center",
                  "textBaseline": "middle"
                }
              }
            },
            "location": {
              "latitude": "latitude",
              "longitude": "longitude",
              "mode": "coords"
            },
            "name": "Layer 1",
            "tooltip": true,
            "type": "markers"
          }
        ],
        "view": {
          "id": "europe",
          "lat": 46,
          "lon": 14,
          "zoom": 4
        }
      },
      "pluginVersion": "8.4.1",
      "targets": [
        {
          "alias": "latitude",
          "datasource": {
            "type": "influxdb",
            "uid": "s8Go0hRRz"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "measurement": "standort",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT * FROM \"trailer\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": false,
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "lat"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": []
        },
        {
          "alias": "longitude",
          "datasource": {
            "type": "influxdb",
            "uid": "s8Go0hRRz"
          },
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "null"
              ],
              "type": "fill"
            }
          ],
          "hide": false,
          "measurement": "standort",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT * FROM \"trailer\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": false,
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "lon"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": []
        }
      ],
      "title": "Trailer Standort",
      "type": "geomap"
    }
  ],
  "schemaVersion": 35,
  "style": "dark",
  "tags": [],
  "templating": {
    "list": []
  },
  "time": {
    "from": "now-6h",
    "to": "now"
  },
  "timepicker": {},
  "timezone": "",
  "title": "Test_Geomap_Plugin",
  "uid": "F0-49pRgk",
  "version": 12,
  "weekStart": ""
}

I solved the problem for me after I found the correct Influx query for the coordinates. So the query should look like:

For the Layer use ‘markers’ and location coordinates with alias latitude for the latitude field and the alias longitude for the longitude field.
After this changes, I see the cross marker at the right location on the map.