-
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": ""
}
