-
What Grafana version and what operating system are you using?
Upgrading from 8.4.6 to => 10.4.4 -
What are you trying to achieve?
Visualization of power generation/consumption, achieving same visual as existing 8.4.x dashboard. -
How are you trying to achieve it?
Migrate configuration to 10.4.x, adjust as needed. -
What happened?
Almost everything looks basically correct, except a particular series isn’t displaying in the visualization. However, it does show in the legend and it does show in the tooltips on hover. -
What did you expect to happen?
The missing series is shown in the visualization -
Can you copy/paste the configuration(s) that you are having problems with?
{
"datasource": {
"uid": "bxVSrzy7z",
"type": "influxdb"
},
"fieldConfig": {
"defaults": {
"custom": {
"drawStyle": "bars",
"lineInterpolation": "linear",
"barAlignment": 0,
"lineWidth": 1,
"fillOpacity": 100,
"gradientMode": "none",
"spanNulls": true,
"insertNulls": false,
"showPoints": "never",
"pointSize": 5,
"stacking": {
"mode": "normal",
"group": "A"
},
"axisPlacement": "auto",
"axisLabel": "",
"axisColorMode": "text",
"axisBorderShow": false,
"scaleDistribution": {
"type": "linear"
},
"axisCenteredZero": false,
"hideFrom": {
"tooltip": false,
"viz": false,
"legend": false
},
"thresholdsStyle": {
"mode": "off"
}
},
"color": {
"mode": "palette-classic"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"max": 2,
"min": -2,
"unit": "kwatth"
},
"overrides": [
{
"matcher": {
"id": "byRegexp",
"options": "/Consumed|BatteryCharging|GridExported/"
},
"properties": [
{
"id": "custom.transform",
"value": "negative-Y"
}
]
},
{
"matcher": {
"id": "byRegexp",
"options": "/Grid/"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "light-purple",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byRegexp",
"options": "/Battery/"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "semi-dark-green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "samples.Solar { locationId: fbefa081-d49e-44e3-80fd-79881ed879f9 }"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "light-yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "samples.Solar { locationId: c40aa42a-ede8-42eb-9539-dfc4a532ed3e }"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "semi-dark-yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "samples.Solar { locationId: fbefa081-d49e-44e3-80fd-79881ed879f9 }"
},
"properties": [
{
"id": "displayName",
"value": "South panels (22)"
}
]
},
{
"matcher": {
"id": "byName",
"options": "samples.Solar { locationId: c40aa42a-ede8-42eb-9539-dfc4a532ed3e }"
},
"properties": [
{
"id": "displayName",
"value": "East panels (10)"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Consumed"
},
"properties": [
{
"id": "color",
"value": {
"mode": "fixed",
"fixedColor": "red"
}
}
]
}
]
},
"gridPos": {
"h": 11,
"w": 16,
"x": 0,
"y": 13
},
"id": 16,
"options": {
"tooltip": {
"mode": "multi",
"sort": "none"
},
"legend": {
"showLegend": true,
"displayMode": "list",
"placement": "bottom",
"calcs": [
"sum"
]
}
},
"pluginVersion": "8.4.4",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "bxVSrzy7z"
},
"alias": "BatteryCharging",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "samples",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT \n sum(\"batteryPower\") / 3600 * -1 as BatteryCharging\nFROM \"samples\" \nWHERE $timeFilter AND \"batteryPower\" <= 0\nGROUP BY time(10m) fill(null)",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"consumptionPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
],
[
{
"params": [
"batteryPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
],
[
{
"params": [
"generationPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": []
},
{
"datasource": {
"type": "influxdb",
"uid": "bxVSrzy7z"
},
"alias": "BatteryDischarging",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "samples",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT \n sum(\"batteryPower\") / 3600 as BatteryDischarging\nFROM \"samples\" \nWHERE $timeFilter AND \"batteryPower\" > 0\nGROUP BY time(10m) fill(null)",
"rawQuery": true,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"consumptionPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
],
[
{
"params": [
"batteryPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
],
[
{
"params": [
"generationPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": []
},
{
"datasource": {
"type": "influxdb",
"uid": "bxVSrzy7z"
},
"alias": "",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"locationId"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "samples",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT \n sum(\"generationPower\") / 3600 as Solar\nFROM \"samples\" \nWHERE $timeFilter \nGROUP BY time(10m), \"locationId\" fill(null)",
"rawQuery": true,
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"consumptionPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
],
[
{
"params": [
"batteryPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
],
[
{
"params": [
"generationPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": []
},
{
"datasource": {
"type": "influxdb",
"uid": "bxVSrzy7z"
},
"alias": "Consumed",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "samples",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT \n sum(\"consumptionPower\") / 3600 as Consumed\nFROM \"samples\" \nWHERE $timeFilter \nGROUP BY time(10m) fill(null)",
"rawQuery": true,
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"consumptionPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
],
[
{
"params": [
"batteryPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
],
[
{
"params": [
"generationPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": []
},
{
"datasource": {
"type": "influxdb",
"uid": "bxVSrzy7z"
},
"alias": "GridExported",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "samples",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT \n sum(\"netPower\") / 3600 * -1 as GridExported\nFROM \"samples\" \nWHERE $timeFilter AND \"netPower\" < 0\nGROUP BY time(10m) fill(null)",
"rawQuery": true,
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"consumptionPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
],
[
{
"params": [
"batteryPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
],
[
{
"params": [
"generationPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": []
},
{
"datasource": {
"type": "influxdb",
"uid": "bxVSrzy7z"
},
"alias": "GridImported",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "samples",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT \n sum(\"netPower\") / 3600 as GridImported\nFROM \"samples\" \nWHERE $timeFilter AND \"netPower\" >= 0\nGROUP BY time(10m) fill(null)",
"rawQuery": true,
"refId": "F",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"consumptionPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
],
[
{
"params": [
"batteryPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
],
[
{
"params": [
"generationPower"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": []
}
],
"title": "Energy Distribution",
"transparent": true,
"type": "timeseries"
}
-
No errors
-
Not this time …
Panel in 8.4.x
Detail showing BatteryCharging (green)
Panel in 10.4.x
Detail not showing BatteryCharging (green)
If I hide all other series, the visualization in 10.4.x does show the BatteryCharging data, so the query is working, the data is there, and it is configured to display, seemingly.