Canvas: Showing "Field not found" when using influxDB or flux as data source #81955
Labels
Comments
|
same issue here, any solve for it ?
|
|
@KasperKorsholmChristiansen thank you for reporting this issue! Would it be possible for either you or @tcs-christian-ulrich to provide a debug panel dashboard so we can reproduce this locally and work on a fix? https://grafana.com/docs/grafana/latest/troubleshooting/send-panel-to-grafana-support/ Thanks! |
nmarrs
changed the title
Panel debug snapshot dashboard{
"panels": [
{
"datasource": {
"type": "grafana",
"uid": "grafana"
},
"description": "",
"fieldConfig": {
"defaults": {
"unitScale": true,
"mappings": [
{
"options": {
"match": "null",
"result": {
"index": 0,
"text": "-"
}
},
"type": "special"
},
{
"options": {
"match": "null+nan",
"result": {
"index": 1,
"text": "-"
}
},
"type": "special"
},
{
"options": {
"match": "empty",
"result": {
"index": 2,
"text": "-"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "#ffffff",
"value": null
},
{
"color": "super-light-green",
"value": 10
},
{
"color": "green",
"value": 20
}
]
},
"color": {
"mode": "thresholds"
},
"noValue": "-"
},
"overrides": []
},
"gridPos": {
"h": 13,
"w": 15,
"x": 0,
"y": 0
},
"id": 2,
"options": {
"inlineEditing": false,
"showAdvancedTypes": true,
"panZoom": false,
"root": {
"background": {
"color": {
"fixed": "#ffffff"
},
"image": {
"fixed": "https://pdash.tcsapps.de/public/img/OG1.svg",
"mode": "fixed"
},
"size": "original"
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 0
},
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"elements": [
{
"background": {
"color": {
"field": "Susi",
"fixed": "#D9D9D9"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"field": "Susi",
"fixed": "",
"mode": "field"
},
"valign": "middle"
},
"connections": [],
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 2",
"placement": {
"height": 21,
"left": 878,
"top": 109,
"width": 16
},
"type": "metric-value"
},
{
"background": {
"color": {
"field": "S1.50.033 1",
"fixed": "#D9D9D9"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"field": "S1.50.033 1",
"fixed": "",
"mode": "field"
},
"valign": "middle"
},
"connections": [],
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 3",
"placement": {
"height": 26,
"left": 960,
"top": 245,
"width": 15
},
"type": "metric-value"
},
{
"background": {
"color": {
"field": "C5_2",
"fixed": "#D9D9D9"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"field": "M1.37.003",
"fixed": "",
"mode": "field"
},
"valign": "middle"
},
"connections": [],
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 4",
"placement": {
"height": 26,
"left": 660,
"top": 50,
"width": 18
},
"type": "metric-value"
},
{
"background": {
"color": {
"field": "PUK",
"fixed": "#D9D9D9"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"field": "PUK",
"fixed": "",
"mode": "field"
},
"valign": "middle"
},
"connections": [],
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 5",
"placement": {
"height": 15,
"left": 728,
"top": 153,
"width": 28
},
"type": "metric-value"
},
{
"background": {
"color": {
"field": "M1.10.001",
"fixed": "#D9D9D9"
},
"image": {
"mode": "fixed"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"field": "M1.10.001",
"fixed": "",
"mode": "field"
},
"valign": "middle"
},
"connections": [],
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 6",
"placement": {
"height": 15,
"left": 647,
"top": 153,
"width": 26
},
"type": "metric-value"
},
{
"background": {
"color": {
"field": "PES",
"fixed": "#D9D9D9"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"field": "PES",
"fixed": "",
"mode": "field"
},
"valign": "middle"
},
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 7",
"placement": {
"height": 26,
"left": 693,
"top": 136,
"width": 18
},
"type": "metric-value"
},
{
"background": {
"color": {
"field": "S1.50.033 2",
"fixed": "#D9D9D9"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"field": "S1.50.033 2",
"fixed": "",
"mode": "field"
},
"valign": "middle"
},
"connections": [],
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 8",
"placement": {
"height": 26,
"left": 986,
"top": 245,
"width": 15
},
"type": "metric-value"
},
{
"background": {
"color": {
"field": "S1.50.033 3",
"fixed": "#D9D9D9"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"field": "S1.50.033 3",
"fixed": "",
"mode": "field"
},
"valign": "middle"
},
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 9",
"placement": {
"height": 26,
"left": 1010,
"top": 245,
"width": 15
},
"type": "metric-value"
},
{
"background": {
"color": {
"field": "Reinhardt",
"fixed": "#D9D9D9"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"field": "Reinhardt",
"fixed": "",
"mode": "field"
},
"valign": "middle"
},
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 10",
"placement": {
"height": 26,
"left": 938,
"top": 228,
"width": 15
},
"type": "metric-value"
},
{
"background": {
"color": {
"field": "ASI Insel",
"fixed": "#D9D9D9"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"field": "ASI Insel",
"fixed": "",
"mode": "field"
},
"valign": "middle"
},
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 11",
"placement": {
"height": 26,
"left": 458,
"top": 60,
"width": 18
},
"type": "metric-value"
},
{
"background": {
"color": {
"field": "M1.20.025",
"fixed": "#D9D9D9"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"field": "M1.20.025",
"fixed": "",
"mode": "field"
},
"valign": "middle"
},
"connections": [],
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 12",
"placement": {
"height": 26,
"left": 811,
"top": 50,
"width": 18
},
"type": "metric-value"
},
{
"background": {
"color": {
"field": "M1.20.027",
"fixed": "#D9D9D9"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"field": "M1.20.027",
"fixed": "",
"mode": "field"
},
"valign": "middle"
},
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 13",
"placement": {
"height": 26,
"left": 778,
"top": 50,
"width": 18
},
"type": "metric-value"
},
{
"background": {
"color": {
"fixed": "#D9D9D9"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"fixed": "-",
"mode": "fixed"
},
"valign": "middle"
},
"connections": [],
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 14",
"placement": {
"height": 26,
"left": 761,
"top": 50,
"width": 18
},
"type": "metric-value"
},
{
"background": {
"color": {
"field": "C5_2",
"fixed": "#D9D9D9"
}
},
"border": {
"color": {
"fixed": "#5d5d5d"
},
"width": 1
},
"config": {
"align": "center",
"color": {
"fixed": "#000000"
},
"size": 8,
"text": {
"field": "M1.37.003",
"fixed": "-",
"mode": "fixed"
},
"valign": "middle"
},
"constraint": {
"horizontal": "left",
"vertical": "top"
},
"name": "Element 15",
"placement": {
"height": 26,
"left": 725,
"top": 50,
"width": 18
},
"type": "metric-value"
}
],
"name": "Element 1707396111760",
"placement": {
"height": 100,
"left": 0,
"top": 0,
"width": 100
},
"type": "frame"
}
},
"pluginVersion": "10.3.1",
"targets": [
{
"refId": "A",
"datasource": {
"type": "grafana",
"uid": "grafana"
},
"queryType": "snapshot",
"snapshot": [
{
"schema": {
"refId": "PUK",
"meta": {
"typeVersion": [
0,
0
],
"preferredVisualisationType": "graph",
"executedQueryString": "SELECT sum(\"ok\") FROM \"tests\" WHERE \"system\"::tag = 'TCSGNT190' AND time >= 1708936219635ms and time <= 1708939819635ms ORDER BY time ASC"
},
"name": "PUK",
"fields": [
{
"name": "Time",
"type": "time",
"typeInfo": {
"frame": "time.Time"
},
"config": {}
},
{
"name": "Value",
"type": "number",
"typeInfo": {
"frame": "float64",
"nullable": true
},
"config": {
"displayNameFromDS": "PUK"
}
}
]
},
"data": {
"values": [
[
1708936219635
],
[
6
]
]
}
}
]
}
],
"transparent": true,
"type": "canvas",
"title": "Reproduced with embedded data"
},
{
"gridPos": {
"h": 7,
"w": 9,
"x": 15,
"y": 0
},
"id": 5,
"options": {
"content": "<table width=\"100%\">\n <tr>\n <th width=\"2%\">Panel</th>\n <td >canvas @ 10.3.1</td>\n </tr>\n <tr>\n <th>Queries</th>\n <td>SUSI[influxdb], M110001[influxdb], M120025[influxdb], M137003[influxdb], M120015[influxdb], M120027[influxdb], PUK[influxdb], PES[influxdb], S1500331[influxdb], S1500332[influxdb], S1500333[influxdb], REINHARDT[influxdb], ASIINSEL[influxdb]</td>\n </tr>\n \n <tr><th>Data</th><td> 1 frames, 2 fields, 1 rows </td></tr>\n \n <tr>\n <th>Grafana</th>\n <td>10.3.1 (00a22ff8b28550d593ec369ba3da1b25780f0a4a) // Open Source</td>\n </tr>\n </table>",
"mode": "html"
},
"title": "Debug info",
"type": "text"
},
{
"id": 6,
"title": "Original Panel JSON",
"type": "text",
"gridPos": {
"h": 13,
"w": 9,
"x": 15,
"y": 7
},
"options": {
"content": "{\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"description\": \"\",\n \"fieldConfig\": {\n \"defaults\": {\n \"unitScale\": true,\n \"mappings\": [\n {\n \"options\": {\n \"match\": \"null\",\n \"result\": {\n \"index\": 0,\n \"text\": \"-\"\n }\n },\n \"type\": \"special\"\n },\n {\n \"options\": {\n \"match\": \"null+nan\",\n \"result\": {\n \"index\": 1,\n \"text\": \"-\"\n }\n },\n \"type\": \"special\"\n },\n {\n \"options\": {\n \"match\": \"empty\",\n \"result\": {\n \"index\": 2,\n \"text\": \"-\"\n }\n },\n \"type\": \"special\"\n }\n ],\n \"thresholds\": {\n \"mode\": \"absolute\",\n \"steps\": [\n {\n \"color\": \"#ffffff\",\n \"value\": null\n },\n {\n \"color\": \"super-light-green\",\n \"value\": 10\n },\n {\n \"color\": \"green\",\n \"value\": 20\n }\n ]\n },\n \"color\": {\n \"mode\": \"thresholds\"\n },\n \"noValue\": \"-\"\n },\n \"overrides\": []\n },\n \"gridPos\": {\n \"h\": 9,\n \"w\": 19,\n \"x\": 0,\n \"y\": 0\n },\n \"id\": 6,\n \"options\": {\n \"inlineEditing\": false,\n \"showAdvancedTypes\": true,\n \"panZoom\": false,\n \"root\": {\n \"background\": {\n \"color\": {\n \"fixed\": \"#ffffff\"\n },\n \"image\": {\n \"fixed\": \"https://pdash.tcsapps.de/public/img/OG1.svg\",\n \"mode\": \"fixed\"\n },\n \"size\": \"original\"\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 0\n },\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"elements\": [\n {\n \"background\": {\n \"color\": {\n \"field\": \"Susi\",\n \"fixed\": \"#D9D9D9\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"field\": \"Susi\",\n \"fixed\": \"\",\n \"mode\": \"field\"\n },\n \"valign\": \"middle\"\n },\n \"connections\": [],\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 2\",\n \"placement\": {\n \"height\": 21,\n \"left\": 878,\n \"top\": 109,\n \"width\": 16\n },\n \"type\": \"metric-value\"\n },\n {\n \"background\": {\n \"color\": {\n \"field\": \"S1.50.033 1\",\n \"fixed\": \"#D9D9D9\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"field\": \"S1.50.033 1\",\n \"fixed\": \"\",\n \"mode\": \"field\"\n },\n \"valign\": \"middle\"\n },\n \"connections\": [],\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 3\",\n \"placement\": {\n \"height\": 26,\n \"left\": 960,\n \"top\": 245,\n \"width\": 15\n },\n \"type\": \"metric-value\"\n },\n {\n \"background\": {\n \"color\": {\n \"field\": \"C5_2\",\n \"fixed\": \"#D9D9D9\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"field\": \"M1.37.003\",\n \"fixed\": \"\",\n \"mode\": \"field\"\n },\n \"valign\": \"middle\"\n },\n \"connections\": [],\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 4\",\n \"placement\": {\n \"height\": 26,\n \"left\": 660,\n \"top\": 50,\n \"width\": 18\n },\n \"type\": \"metric-value\"\n },\n {\n \"background\": {\n \"color\": {\n \"field\": \"PUK\",\n \"fixed\": \"#D9D9D9\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"field\": \"PUK\",\n \"fixed\": \"\",\n \"mode\": \"field\"\n },\n \"valign\": \"middle\"\n },\n \"connections\": [],\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 5\",\n \"placement\": {\n \"height\": 15,\n \"left\": 728,\n \"top\": 153,\n \"width\": 28\n },\n \"type\": \"metric-value\"\n },\n {\n \"background\": {\n \"color\": {\n \"field\": \"M1.10.001\",\n \"fixed\": \"#D9D9D9\"\n },\n \"image\": {\n \"mode\": \"fixed\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"field\": \"M1.10.001\",\n \"fixed\": \"\",\n \"mode\": \"field\"\n },\n \"valign\": \"middle\"\n },\n \"connections\": [],\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 6\",\n \"placement\": {\n \"height\": 15,\n \"left\": 647,\n \"top\": 153,\n \"width\": 26\n },\n \"type\": \"metric-value\"\n },\n {\n \"background\": {\n \"color\": {\n \"field\": \"PES\",\n \"fixed\": \"#D9D9D9\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"field\": \"PES\",\n \"fixed\": \"\",\n \"mode\": \"field\"\n },\n \"valign\": \"middle\"\n },\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 7\",\n \"placement\": {\n \"height\": 26,\n \"left\": 693,\n \"top\": 136,\n \"width\": 18\n },\n \"type\": \"metric-value\"\n },\n {\n \"background\": {\n \"color\": {\n \"field\": \"S1.50.033 2\",\n \"fixed\": \"#D9D9D9\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"field\": \"S1.50.033 2\",\n \"fixed\": \"\",\n \"mode\": \"field\"\n },\n \"valign\": \"middle\"\n },\n \"connections\": [],\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 8\",\n \"placement\": {\n \"height\": 26,\n \"left\": 986,\n \"top\": 245,\n \"width\": 15\n },\n \"type\": \"metric-value\"\n },\n {\n \"background\": {\n \"color\": {\n \"field\": \"S1.50.033 3\",\n \"fixed\": \"#D9D9D9\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"field\": \"S1.50.033 3\",\n \"fixed\": \"\",\n \"mode\": \"field\"\n },\n \"valign\": \"middle\"\n },\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 9\",\n \"placement\": {\n \"height\": 26,\n \"left\": 1010,\n \"top\": 245,\n \"width\": 15\n },\n \"type\": \"metric-value\"\n },\n {\n \"background\": {\n \"color\": {\n \"field\": \"Reinhardt\",\n \"fixed\": \"#D9D9D9\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"field\": \"Reinhardt\",\n \"fixed\": \"\",\n \"mode\": \"field\"\n },\n \"valign\": \"middle\"\n },\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 10\",\n \"placement\": {\n \"height\": 26,\n \"left\": 938,\n \"top\": 228,\n \"width\": 15\n },\n \"type\": \"metric-value\"\n },\n {\n \"background\": {\n \"color\": {\n \"field\": \"ASI Insel\",\n \"fixed\": \"#D9D9D9\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"field\": \"ASI Insel\",\n \"fixed\": \"\",\n \"mode\": \"field\"\n },\n \"valign\": \"middle\"\n },\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 11\",\n \"placement\": {\n \"height\": 26,\n \"left\": 458,\n \"top\": 60,\n \"width\": 18\n },\n \"type\": \"metric-value\"\n },\n {\n \"background\": {\n \"color\": {\n \"field\": \"M1.20.025\",\n \"fixed\": \"#D9D9D9\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"field\": \"M1.20.025\",\n \"fixed\": \"\",\n \"mode\": \"field\"\n },\n \"valign\": \"middle\"\n },\n \"connections\": [],\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 12\",\n \"placement\": {\n \"height\": 26,\n \"left\": 811,\n \"top\": 50,\n \"width\": 18\n },\n \"type\": \"metric-value\"\n },\n {\n \"background\": {\n \"color\": {\n \"field\": \"M1.20.027\",\n \"fixed\": \"#D9D9D9\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"field\": \"M1.20.027\",\n \"fixed\": \"\",\n \"mode\": \"field\"\n },\n \"valign\": \"middle\"\n },\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 13\",\n \"placement\": {\n \"height\": 26,\n \"left\": 778,\n \"top\": 50,\n \"width\": 18\n },\n \"type\": \"metric-value\"\n },\n {\n \"background\": {\n \"color\": {\n \"fixed\": \"#D9D9D9\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"fixed\": \"-\",\n \"mode\": \"fixed\"\n },\n \"valign\": \"middle\"\n },\n \"connections\": [],\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 14\",\n \"placement\": {\n \"height\": 26,\n \"left\": 761,\n \"top\": 50,\n \"width\": 18\n },\n \"type\": \"metric-value\"\n },\n {\n \"background\": {\n \"color\": {\n \"field\": \"C5_2\",\n \"fixed\": \"#D9D9D9\"\n }\n },\n \"border\": {\n \"color\": {\n \"fixed\": \"#5d5d5d\"\n },\n \"width\": 1\n },\n \"config\": {\n \"align\": \"center\",\n \"color\": {\n \"fixed\": \"#000000\"\n },\n \"size\": 8,\n \"text\": {\n \"field\": \"M1.37.003\",\n \"fixed\": \"-\",\n \"mode\": \"fixed\"\n },\n \"valign\": \"middle\"\n },\n \"constraint\": {\n \"horizontal\": \"left\",\n \"vertical\": \"top\"\n },\n \"name\": \"Element 15\",\n \"placement\": {\n \"height\": 26,\n \"left\": 725,\n \"top\": 50,\n \"width\": 18\n },\n \"type\": \"metric-value\"\n }\n ],\n \"name\": \"Element 1707396111760\",\n \"placement\": {\n \"height\": 100,\n \"left\": 0,\n \"top\": 0,\n \"width\": 100\n },\n \"type\": \"frame\"\n }\n },\n \"pluginVersion\": \"10.3.1\",\n \"targets\": [\n {\n \"alias\": \"Susi\",\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"groupBy\": [],\n \"hide\": false,\n \"measurement\": \"tests\",\n \"orderByTime\": \"ASC\",\n \"policy\": \"default\",\n \"query\": \"SELECT sum(\\\"ok\\\") FROM \\\"tests\\\" WHERE (\\\"system\\\"::tag = 'TCSGNT218') AND $timeFilter\",\n \"rawQuery\": false,\n \"refId\": \"SUSI\",\n \"resultFormat\": \"time_series\",\n \"select\": [\n [\n {\n \"params\": [\n \"ok\"\n ],\n \"type\": \"field\"\n },\n {\n \"params\": [],\n \"type\": \"sum\"\n }\n ]\n ],\n \"tags\": [\n {\n \"key\": \"system::tag\",\n \"operator\": \"=\",\n \"value\": \"TCSGNT218\"\n }\n ]\n },\n {\n \"alias\": \"M1.10.001\",\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"groupBy\": [],\n \"hide\": false,\n \"measurement\": \"tests\",\n \"orderByTime\": \"ASC\",\n \"policy\": \"default\",\n \"query\": \"SELECT sum(\\\"ok\\\") FROM \\\"tests\\\" WHERE (\\\"system\\\"::tag = 'TCSGNT170') AND $timeFilter GROUP BY time(1m)\",\n \"rawQuery\": false,\n \"refId\": \"M110001\",\n \"resultFormat\": \"time_series\",\n \"select\": [\n [\n {\n \"params\": [\n \"ok\"\n ],\n \"type\": \"field\"\n },\n {\n \"params\": [],\n \"type\": \"sum\"\n }\n ]\n ],\n \"tags\": [\n {\n \"key\": \"system::tag\",\n \"operator\": \"=\",\n \"value\": \"TCSGNT194\"\n }\n ]\n },\n {\n \"alias\": \"M1.20.025\",\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"groupBy\": [],\n \"hide\": false,\n \"measurement\": \"tests\",\n \"orderByTime\": \"ASC\",\n \"policy\": \"default\",\n \"query\": \"SELECT sum(\\\"ok\\\") FROM \\\"tests\\\" WHERE (\\\"system\\\"::tag = 'TCSGNT170') AND $timeFilter GROUP BY time(1m)\",\n \"rawQuery\": false,\n \"refId\": \"M120025\",\n \"resultFormat\": \"time_series\",\n \"select\": [\n [\n {\n \"params\": [\n \"ok\"\n ],\n \"type\": \"field\"\n },\n {\n \"params\": [],\n \"type\": \"sum\"\n }\n ]\n ],\n \"tags\": [\n {\n \"key\": \"system::tag\",\n \"operator\": \"=\",\n \"value\": \"TCSGNT224\"\n }\n ]\n },\n {\n \"alias\": \"M1.37.003\",\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"groupBy\": [],\n \"hide\": false,\n \"measurement\": \"tests\",\n \"orderByTime\": \"ASC\",\n \"policy\": \"default\",\n \"query\": \"SELECT sum(\\\"ok\\\") FROM \\\"tests\\\" WHERE (\\\"system\\\"::tag = 'TCSGNT170') AND $timeFilter GROUP BY time(1m)\",\n \"rawQuery\": false,\n \"refId\": \"M137003\",\n \"resultFormat\": \"time_series\",\n \"select\": [\n [\n {\n \"params\": [\n \"ok\"\n ],\n \"type\": \"field\"\n },\n {\n \"params\": [],\n \"type\": \"sum\"\n }\n ]\n ],\n \"tags\": [\n {\n \"key\": \"system::tag\",\n \"operator\": \"=\",\n \"value\": \"TCSGNT198\"\n }\n ]\n },\n {\n \"alias\": \"M1.20.015\",\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"groupBy\": [],\n \"hide\": false,\n \"measurement\": \"tests\",\n \"orderByTime\": \"ASC\",\n \"policy\": \"default\",\n \"query\": \"SELECT sum(\\\"ok\\\") FROM \\\"tests\\\" WHERE (\\\"system\\\"::tag = 'TCSGNT170') AND $timeFilter GROUP BY time(1m)\",\n \"rawQuery\": false,\n \"refId\": \"M120015\",\n \"resultFormat\": \"time_series\",\n \"select\": [\n [\n {\n \"params\": [\n \"ok\"\n ],\n \"type\": \"field\"\n },\n {\n \"params\": [],\n \"type\": \"sum\"\n }\n ]\n ],\n \"tags\": [\n {\n \"key\": \"system::tag\",\n \"operator\": \"=\",\n \"value\": \"TCSGNT103\"\n }\n ]\n },\n {\n \"alias\": \"M1.20.027\",\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"groupBy\": [],\n \"hide\": false,\n \"measurement\": \"tests\",\n \"orderByTime\": \"ASC\",\n \"policy\": \"default\",\n \"query\": \"SELECT sum(\\\"ok\\\") FROM \\\"tests\\\" WHERE (\\\"system\\\"::tag = 'TCSGNT170') AND $timeFilter GROUP BY time(1m)\",\n \"rawQuery\": false,\n \"refId\": \"M120027\",\n \"resultFormat\": \"time_series\",\n \"select\": [\n [\n {\n \"params\": [\n \"ok\"\n ],\n \"type\": \"field\"\n },\n {\n \"params\": [],\n \"type\": \"sum\"\n }\n ]\n ],\n \"tags\": [\n {\n \"key\": \"system::tag\",\n \"operator\": \"=\",\n \"value\": \"TCSGNT183\"\n }\n ]\n },\n {\n \"alias\": \"PUK\",\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"groupBy\": [],\n \"hide\": false,\n \"measurement\": \"tests\",\n \"orderByTime\": \"ASC\",\n \"policy\": \"default\",\n \"query\": \"SELECT sum(\\\"ok\\\") FROM \\\"tests\\\" WHERE (\\\"system\\\"::tag = 'TCSGNT170') AND $timeFilter GROUP BY time(1m)\",\n \"rawQuery\": false,\n \"refId\": \"PUK\",\n \"resultFormat\": \"time_series\",\n \"select\": [\n [\n {\n \"params\": [\n \"ok\"\n ],\n \"type\": \"field\"\n },\n {\n \"params\": [],\n \"type\": \"sum\"\n }\n ]\n ],\n \"tags\": [\n {\n \"key\": \"system::tag\",\n \"operator\": \"=\",\n \"value\": \"TCSGNT190\"\n }\n ]\n },\n {\n \"alias\": \"PES\",\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"groupBy\": [],\n \"hide\": false,\n \"measurement\": \"tests\",\n \"orderByTime\": \"ASC\",\n \"policy\": \"default\",\n \"query\": \"SELECT sum(\\\"ok\\\") FROM \\\"tests\\\" WHERE (\\\"system\\\"::tag = 'TCSGNT170') AND $timeFilter GROUP BY time(1m)\",\n \"rawQuery\": false,\n \"refId\": \"PES\",\n \"resultFormat\": \"time_series\",\n \"select\": [\n [\n {\n \"params\": [\n \"ok\"\n ],\n \"type\": \"field\"\n },\n {\n \"params\": [],\n \"type\": \"sum\"\n }\n ]\n ],\n \"tags\": [\n {\n \"key\": \"system::tag\",\n \"operator\": \"=\",\n \"value\": \"TCSGNT195\"\n }\n ]\n },\n {\n \"alias\": \"S1.50.033 1\",\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"groupBy\": [],\n \"hide\": false,\n \"measurement\": \"tests\",\n \"orderByTime\": \"ASC\",\n \"policy\": \"default\",\n \"query\": \"SELECT sum(\\\"ok\\\") FROM \\\"tests\\\" WHERE (\\\"system\\\"::tag = 'TCSGNT170') AND $timeFilter GROUP BY time(1m)\",\n \"rawQuery\": false,\n \"refId\": \"S1500331\",\n \"resultFormat\": \"time_series\",\n \"select\": [\n [\n {\n \"params\": [\n \"ok\"\n ],\n \"type\": \"field\"\n },\n {\n \"params\": [],\n \"type\": \"sum\"\n }\n ]\n ],\n \"tags\": [\n {\n \"key\": \"system::tag\",\n \"operator\": \"=\",\n \"value\": \"TCSGNT155\"\n }\n ]\n },\n {\n \"alias\": \"S1.50.033 2\",\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"groupBy\": [],\n \"hide\": false,\n \"measurement\": \"tests\",\n \"orderByTime\": \"ASC\",\n \"policy\": \"default\",\n \"query\": \"SELECT sum(\\\"ok\\\") FROM \\\"tests\\\" WHERE (\\\"system\\\"::tag = 'TCSGNT170') AND $timeFilter GROUP BY time(1m)\",\n \"rawQuery\": false,\n \"refId\": \"S1500332\",\n \"resultFormat\": \"time_series\",\n \"select\": [\n [\n {\n \"params\": [\n \"ok\"\n ],\n \"type\": \"field\"\n },\n {\n \"params\": [],\n \"type\": \"sum\"\n }\n ]\n ],\n \"tags\": [\n {\n \"key\": \"system::tag\",\n \"operator\": \"=\",\n \"value\": \"TCSGNT211\"\n }\n ]\n },\n {\n \"alias\": \"S1.50.033 3\",\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"groupBy\": [],\n \"hide\": false,\n \"measurement\": \"tests\",\n \"orderByTime\": \"ASC\",\n \"policy\": \"default\",\n \"query\": \"SELECT sum(\\\"ok\\\") FROM \\\"tests\\\" WHERE (\\\"system\\\"::tag = 'TCSGNT170') AND $timeFilter GROUP BY time(1m)\",\n \"rawQuery\": false,\n \"refId\": \"S1500333\",\n \"resultFormat\": \"time_series\",\n \"select\": [\n [\n {\n \"params\": [\n \"ok\"\n ],\n \"type\": \"field\"\n },\n {\n \"params\": [],\n \"type\": \"sum\"\n }\n ]\n ],\n \"tags\": [\n {\n \"key\": \"system::tag\",\n \"operator\": \"=\",\n \"value\": \"TCSGNT196\"\n }\n ]\n },\n {\n \"alias\": \"Reinhardt\",\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"groupBy\": [],\n \"hide\": false,\n \"measurement\": \"tests\",\n \"orderByTime\": \"ASC\",\n \"policy\": \"default\",\n \"query\": \"SELECT sum(\\\"ok\\\") FROM \\\"tests\\\" WHERE (\\\"system\\\"::tag = 'TCSGNT170') AND $timeFilter GROUP BY time(1m)\",\n \"rawQuery\": false,\n \"refId\": \"REINHARDT\",\n \"resultFormat\": \"time_series\",\n \"select\": [\n [\n {\n \"params\": [\n \"ok\"\n ],\n \"type\": \"field\"\n },\n {\n \"params\": [],\n \"type\": \"sum\"\n }\n ]\n ],\n \"tags\": [\n {\n \"key\": \"function::field\",\n \"operator\": \"=\",\n \"value\": \"reinhardt\"\n }\n ]\n },\n {\n \"alias\": \"ASI Insel\",\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"a2840576-bf26-47e0-b30e-d767c2480b48\"\n },\n \"groupBy\": [],\n \"hide\": false,\n \"measurement\": \"tests\",\n \"orderByTime\": \"ASC\",\n \"policy\": \"default\",\n \"query\": \"SELECT sum(\\\"ok\\\") FROM \\\"tests\\\" WHERE (\\\"system\\\"::tag = 'TCSGNT170') AND $timeFilter GROUP BY time(1m)\",\n \"rawQuery\": false,\n \"refId\": \"ASIINSEL\",\n \"resultFormat\": \"time_series\",\n \"select\": [\n [\n {\n \"params\": [\n \"ok\"\n ],\n \"type\": \"field\"\n },\n {\n \"params\": [],\n \"type\": \"sum\"\n }\n ]\n ],\n \"tags\": [\n {\n \"key\": \"system::tag\",\n \"operator\": \"=\",\n \"value\": \"TCSGNT181\"\n }\n ]\n }\n ],\n \"transparent\": true,\n \"type\": \"canvas\"\n}",
"mode": "code",
"code": {
"language": "json",
"showLineNumbers": true,
"showMiniMap": true
}
}
},
{
"id": 3,
"title": "Data from panel above",
"type": "table",
"datasource": {
"type": "datasource",
"uid": "-- Dashboard --"
},
"gridPos": {
"h": 7,
"w": 15,
"x": 0,
"y": 13
},
"options": {
"showTypeIcons": true
},
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "-- Dashboard --"
},
"panelId": 2,
"withTransforms": true,
"refId": "A"
}
]
}
],
"schemaVersion": 37,
"title": "Debug: undefined // 2024-02-26 10:30:36",
"tags": [
"debug",
"debug-canvas"
],
"time": {
"from": "2024-02-26T08:30:36.335Z",
"to": "2024-02-26T09:30:36.336Z"
}
} |
|
I actually played around, and at some point I got it to work, but actually don't know why 🙄 Currently I am not able to replicate the error 🤔 |
|
does the snapshot help to reproduce it ? |
1 similar comment
|
does the snapshot help to reproduce it ? |
|
Hi @tcs-christian-ulrich - sorry for the delay on getting back to you on this. Based on the debug panel you provided it appears that the issue may be with your influx query as panel data only has two returned fields (Time and PUK) which is the reason why the canvas metric value elements are not able to find the associated data. Are you seeing a similar result in the table view of the panel? Was this functionality ever working for you before? 🤔 Screen.Recording.2024-05-13.at.5.27.16.PM.mov |
|
@nmarrs Thanks for the Answer Oh, maybe its not the same issue as the op described. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
What happened?
Hi
This is the same issues described here: #67580
The query does return a result, but I am not able to link it to a Canvas field
What did you expect to happen?
To see field in the drop down menu
Did this work before?
no
How do we reproduce it?
Try to add a InfluxDB data source and add field to Canvas from influxDB
Is the bug inside a dashboard panel?
No response
Environment (with versions)?
Grafana: Grafana v10.2.2
OS: Windows
Browser: Chrome
InfluxDB: v2.7.4
Grafana platform?
Kubernetes
Datasource(s)?
InfluxDB: v2.7.4
The text was updated successfully, but these errors were encountered: