Grafana not connecting points to lines

Hi,
Since a couple of days I have strange problems in my Grafana-Dashbaord:


Grafana suddelny isn’t connecting the points anymore, maybe it happened with the update 7.5.5 but I don’t think so.

Here are the configurations and the panel json:


→ Only two images allowed, the other two will go in the next post

{
  "aliasColors": {
    "EVU": "semi-dark-yellow",
    "House": "semi-dark-red",
    "PV": "semi-dark-green",
    "solcast": "dark-blue"
  },
  "bars": false,
  "dashLength": 10,
  "dashes": false,
  "datasource": "-- Mixed --",
  "fieldConfig": {
    "defaults": {
      "links": []
    },
    "overrides": [
      {
        "matcher": {
          "id": "byName",
          "options": "Sun altitude"
        },
        "properties": [
          {
            "id": "displayName",
            "value": "Sonnenstand"
          }
        ]
      }
    ]
  },
  "fill": 3,
  "fillGradient": 3,
  "gridPos": {
    "h": 17,
    "w": 24,
    "x": 0,
    "y": 19
  },
  "hiddenSeries": false,
  "hideTimeOverride": true,
  "id": 23763571993,
  "interval": "",
  "legend": {
    "alignAsTable": false,
    "avg": true,
    "current": false,
    "hideEmpty": false,
    "hideZero": false,
    "max": true,
    "min": false,
    "rightSide": false,
    "show": true,
    "total": false,
    "values": true
  },
  "lines": true,
  "linewidth": 1,
  "maxPerRow": 3,
  "nullPointMode": "connected",
  "options": {
    "alertThreshold": true
  },
  "percentage": false,
  "pluginVersion": "7.5.5",
  "pointradius": 2,
  "points": false,
  "renderer": "flot",
  "repeat": null,
  "repeatDirection": "h",
  "seriesOverrides": [
    {
      "$$hashKey": "object:2941",
      "alias": "Speicher-SoC",
      "color": "#5794F2",
      "dashes": true,
      "fillGradient": 1,
      "yaxis": 2
    },
    {
      "$$hashKey": "object:445",
      "alias": "Sonnenstand",
      "color": "#FADE2A",
      "dashes": true,
      "yaxis": 2
    },
    {
      "$$hashKey": "object:514",
      "alias": "PV-Leisung",
      "color": "#FADE2A"
    },
    {
      "$$hashKey": "object:522",
      "alias": "Netz-Leistung",
      "color": "rgb(130, 130, 130)"
    },
    {
      "$$hashKey": "object:2626",
      "alias": "Hausverbrauch",
      "color": "#73BF69"
    },
    {
      "$$hashKey": "object:2635",
      "alias": "PV-Prognose",
      "color": "#FF9830"
    },
    {
      "$$hashKey": "object:3144",
      "alias": "Speicher-Leistung",
      "color": "#5794F2"
    },
    {
      "$$hashKey": "object:454",
      "alias": "70%",
      "color": "#F2495C",
      "dashLength": 4,
      "dashes": true,
      "fillGradient": 1
    },
    {
      "$$hashKey": "object:422",
      "alias": "kWp",
      "color": "#B877D9",
      "dashLength": 4,
      "dashes": true,
      "fillGradient": 1
    }
  ],
  "spaceLength": 10,
  "stack": false,
  "steppedLine": false,
  "targets": [
    {
      "alias": "PV-Leisung",
      "datasource": "InfluxDB",
      "groupBy": [
        {
          "params": [
            "$__interval"
          ],
          "type": "time"
        },
        {
          "params": [
            "null"
          ],
          "type": "fill"
        }
      ],
      "measurement": "mqtt_consumer",
      "orderByTime": "ASC",
      "policy": "default",
      "refId": "C",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "value"
            ],
            "type": "field"
          },
          {
            "params": [],
            "type": "mean"
          },
          {
            "params": [
              "* -1"
            ],
            "type": "math"
          }
        ]
      ],
      "tags": [
        {
          "key": "topic",
          "operator": "=",
          "value": "openWB/pv/W"
        }
      ],
      "query": "SELECT mean(\"value\") * -1 FROM \"mqtt_consumer\" WHERE (\"topic\" = 'openWB/pv/W') AND $timeFilter GROUP BY time($__interval) fill(null)",
      "rawQuery": true
    },
    {
      "alias": "Netz-Leistung",
      "datasource": "InfluxDB",
      "groupBy": [
        {
          "params": [
            "$__interval"
          ],
          "type": "time"
        },
        {
          "params": [
            "null"
          ],
          "type": "fill"
        }
      ],
      "hide": false,
      "measurement": "mqtt_consumer",
      "orderByTime": "ASC",
      "policy": "default",
      "refId": "B",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "value"
            ],
            "type": "field"
          },
          {
            "params": [],
            "type": "mean"
          },
          {
            "params": [
              "*-1"
            ],
            "type": "math"
          }
        ]
      ],
      "tags": [
        {
          "key": "topic",
          "operator": "=",
          "value": "openWB/evu/W"
        }
      ],
      "query": "SELECT mean(\"value\") *-1 FROM \"mqtt_consumer\" WHERE (\"topic\" = 'openWB/evu/W') AND $timeFilter GROUP BY time($__interval) fill(null)",
      "rawQuery": true
    },
    {
      "alias": "Hausverbrauch",
      "datasource": "InfluxDB",
      "groupBy": [
        {
          "params": [
            "$__interval"
          ],
          "type": "time"
        },
        {
          "params": [
            "null"
          ],
          "type": "fill"
        }
      ],
      "hide": false,
      "measurement": "mqtt_consumer",
      "orderByTime": "ASC",
      "policy": "default",
      "refId": "A",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "value"
            ],
            "type": "field"
          },
          {
            "params": [],
            "type": "mean"
          }
        ]
      ],
      "tags": [
        {
          "key": "topic",
          "operator": "=",
          "value": "openWB/global/WHouseConsumption"
        }
      ],
      "query": "SELECT mean(\"value\") FROM \"mqtt_consumer\" WHERE (\"topic\" = 'openWB/global/WHouseConsumption') AND $timeFilter GROUP BY time($__interval) fill(null)",
      "rawQuery": true
    },
    {
      "alias": "PV-Prognose",
      "datasource": "InfluxDB",
      "groupBy": [
        {
          "params": [
            "$__interval"
          ],
          "type": "time"
        },
        {
          "params": [
            "null"
          ],
          "type": "fill"
        }
      ],
      "measurement": "solcast",
      "orderByTime": "ASC",
      "policy": "autogen",
      "query": "SELECT mean(\"value\") FROM \"autogen\".\"solcast\" WHERE (\"topic\" = 'pv_estimate') AND $timeFilter GROUP BY time($__interval) fill(null)",
      "rawQuery": true,
      "refId": "D",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "value"
            ],
            "type": "field"
          },
          {
            "params": [],
            "type": "mean"
          }
        ]
      ],
      "tags": [
        {
          "key": "topic",
          "operator": "=",
          "value": "pv_estimate"
        }
      ]
    },
    {
      "alias": "Speicher-Leistung",
      "datasource": "InfluxDB",
      "groupBy": [
        {
          "params": [
            "$__interval"
          ],
          "type": "time"
        },
        {
          "params": [
            "null"
          ],
          "type": "fill"
        }
      ],
      "measurement": "mqtt_consumer",
      "orderByTime": "ASC",
      "policy": "default",
      "refId": "E",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "value"
            ],
            "type": "field"
          },
          {
            "params": [],
            "type": "mean"
          }
        ]
      ],
      "tags": [
        {
          "key": "topic",
          "operator": "=",
          "value": "openWB/housebattery/W"
        }
      ],
      "query": "SELECT mean(\"value\") FROM \"mqtt_consumer\" WHERE (\"topic\" = 'openWB/housebattery/W') AND $timeFilter GROUP BY time($__interval) fill(null)",
      "rawQuery": true
    },
    {
      "alias": "Speicher-SoC",
      "datasource": "InfluxDB",
      "groupBy": [
        {
          "params": [
            "$__interval"
          ],
          "type": "time"
        },
        {
          "params": [
            "null"
          ],
          "type": "fill"
        }
      ],
      "measurement": "mqtt_consumer",
      "orderByTime": "ASC",
      "policy": "default",
      "refId": "F",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "value"
            ],
            "type": "field"
          },
          {
            "params": [],
            "type": "mean"
          }
        ]
      ],
      "tags": [
        {
          "key": "topic",
          "operator": "=",
          "value": "openWB/housebattery/%Soc"
        }
      ],
      "query": "SELECT mean(\"value\") FROM \"mqtt_consumer\" WHERE (\"topic\" = 'openWB/housebattery/%Soc') AND $timeFilter GROUP BY time($__interval) fill(null)",
      "rawQuery": true
    },
    {
      "datasource": "Sun and Moon",
      "refId": "G",
      "target": "sun_altitude"
    }
  ],
  "thresholds": [],
  "timeFrom": null,
  "timeRegions": [],
  "timeShift": null,
  "title": "PV Leistung, PV-Prognose, Sonnenstand, Netz Leistung, Speicherleistung, Speicher SoC und Hausverbrauch",
  "tooltip": {
    "shared": true,
    "sort": 0,
    "value_type": "individual"
  },
  "transformations": [
    {
      "id": "calculateField",
      "options": {
        "alias": "70%",
        "binary": {
          "left": "1",
          "operator": "*",
          "reducer": "sum",
          "right": "6860"
        },
        "mode": "binary",
        "reduce": {
          "reducer": "sum"
        }
      }
    },
    {
      "id": "calculateField",
      "options": {
        "alias": "kWp",
        "binary": {
          "left": "1",
          "operator": "*",
          "reducer": "sum",
          "right": "9800"
        },
        "mode": "binary",
        "reduce": {
          "reducer": "sum"
        }
      }
    }
  ],
  "type": "graph",
  "xaxis": {
    "buckets": null,
    "mode": "time",
    "name": null,
    "show": true,
    "values": []
  },
  "yaxes": [
    {
      "$$hashKey": "object:2913",
      "decimals": 2,
      "format": "watt",
      "label": "",
      "logBase": 1,
      "max": null,
      "min": null,
      "show": true
    },
    {
      "$$hashKey": "object:2914",
      "format": "percent",
      "label": null,
      "logBase": 1,
      "max": "100",
      "min": "0",
      "show": true
    }
  ],
  "yaxis": {
    "align": false,
    "alignLevel": null
  }
}

Any ideas?


Hm, I now found an “solution”:

I haven’t got it to work again with the “Graph”-Plugin, but luckily it is working with the new “Time-series”-Plugin.

1 Like

Hi @jsanyone,

Have you tried this on the Grafana8 beta by any chance? What minor version of Grafana 7 are you currently running?

Hi @mattabrams,
My current Grafana version is v7.5.6 (5fdad5bfe4) . I‘ve just seen that there is a never version, I will install it today.
For me the problem is „solved“ with the new plugin, I really like the new options. But if it helps you to understand the problem I could restore an older version of the dashboard and try it with the update or even the beta8. Just tell me!

1 Like