Stacked value disappears betw 8.4 and 10.4

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