HZG Stats Livius
Statistik der Heizung in der Livius
{
  "__inputs": [
    {
      "name": "DS_INFLUXDB-LOCAL",
      "label": "InfluxDB-local",
      "description": "",
      "type": "datasource",
      "pluginId": "influxdb",
      "pluginName": "InfluxDB"
    },
    {
      "name": "DS_INFLUXDB",
      "label": "InfluxDB",
      "description": "",
      "type": "datasource",
      "pluginId": "influxdb",
      "pluginName": "InfluxDB"
    },
    {
      "name": "DS_INFLUXDB_RP4GH",
      "label": "InfluxDB_rp4GH",
      "description": "",
      "type": "datasource",
      "pluginId": "influxdb",
      "pluginName": "InfluxDB"
    }
  ],
  "__elements": {},
  "__requires": [
    {
      "type": "panel",
      "id": "barchart",
      "name": "Bar chart",
      "version": ""
    },
    {
      "type": "grafana",
      "id": "grafana",
      "name": "Grafana",
      "version": "9.0.4"
    },
    {
      "type": "datasource",
      "id": "influxdb",
      "name": "InfluxDB",
      "version": "1.0.0"
    },
    {
      "type": "panel",
      "id": "stat",
      "name": "Stat",
      "version": ""
    },
    {
      "type": "panel",
      "id": "table",
      "name": "Table",
      "version": ""
    },
    {
      "type": "panel",
      "id": "timeseries",
      "name": "Time series",
      "version": ""
    }
  ],
  "annotations": {
    "list": [
      {
        "builtIn": 1,
        "datasource": {
          "type": "datasource",
          "uid": "grafana"
        },
        "enable": true,
        "hide": true,
        "iconColor": "rgba(0, 211, 255, 1)",
        "name": "Annotations & Alerts",
        "target": {
          "limit": 100,
          "matchAny": false,
          "tags": [],
          "type": "dashboard"
        },
        "type": "dashboard"
      }
    ]
  },
  "description": "Statistik der Heizung in der Livius",
  "editable": true,
  "fiscalYearStartMonth": 0,
  "graphTooltip": 0,
  "id": null,
  "links": [],
  "liveNow": false,
  "panels": [
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB-LOCAL}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "fixedColor": "semi-dark-red",
            "mode": "fixed"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "watth"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 4,
        "w": 5,
        "x": 0,
        "y": 0
      },
      "id": 61,
      "options": {
        "colorMode": "none",
        "graphMode": "area",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "max"
          ],
          "fields": "",
          "values": false
        },
        "text": {},
        "textMode": "auto"
      },
      "pluginVersion": "9.0.4",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "from(bucket: \"cloudbktcp\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePower\")\n  |> filter(fn: (r) => r[\"eMeter\"] == \"VHWP\")\n  |> filter(fn: (r) => r[\"_field\"] == \"sumWh\")\n  //|> increase()\n  //|> aggregateWindow(every: 5m, fn: last, offset: -1h)\n // |> duplicate(column: \"_stop\", as: \"_time\")\n  //|> max()\n  |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)\n  |> increase()\n  |> yield(name: \"increase\")",
          "refId": "A"
        }
      ],
      "title": "Verbrauch WP VH in der Periode",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB-LOCAL}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "fixedColor": "semi-dark-red",
            "mode": "fixed"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "watth"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 4,
        "w": 6,
        "x": 5,
        "y": 0
      },
      "id": 59,
      "options": {
        "colorMode": "none",
        "graphMode": "area",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "max"
          ],
          "fields": "",
          "values": false
        },
        "text": {},
        "textMode": "auto"
      },
      "pluginVersion": "9.0.4",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "from(bucket: \"bktRP4GH\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePowerWP\")\n  |> filter(fn: (r) => r[\"meter\"] == \"WPGH\")\n  |> filter(fn: (r) => r[\"mptype\"] == \"totalEnergy\")\n  //|> increase()\n  //|> aggregateWindow(every: 5m, fn: last, offset: -1h)\n // |> duplicate(column: \"_stop\", as: \"_time\")\n  //|> max()\n  |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)\n  |> increase()\n  |> yield(name: \"increase\")",
          "refId": "A"
        }
      ],
      "title": "Verbrauch WP GH in der Periode",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB-LOCAL}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "fixedColor": "red",
            "mode": "fixed"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "kwatth"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 4,
        "w": 6,
        "x": 11,
        "y": 0
      },
      "id": 63,
      "options": {
        "colorMode": "none",
        "graphMode": "area",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "max"
          ],
          "fields": "/^gascnt$/",
          "values": false
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.0.4",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "from(bucket: \"cloudbktcp\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"Gas\")\n  |> filter(fn: (r) => r[\"_field\"] == \"gascnt\")\n  |> aggregateWindow(every: v.windowPeriod, column: \"_field\", fn: last, createEmpty: false)\n  |> increase()\n |> map(fn: (r) => ({\n   r with\n    _value: float(v: r._value)*0.105\n     }))\n // |> yield(name: \"gas\")",
          "refId": "A"
        }
      ],
      "title": "Gas",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "custom": {
            "align": "center",
            "displayMode": "auto",
            "inspect": false,
            "minWidth": 0
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "sumGH"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "GH"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "sumVH"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "VH"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "VH"
            },
            "properties": [
              {
                "id": "custom.width",
                "value": 76
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "GH"
            },
            "properties": [
              {
                "id": "custom.width",
                "value": 77
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 4,
        "w": 4,
        "x": 17,
        "y": 0
      },
      "id": 68,
      "options": {
        "footer": {
          "fields": "",
          "reducer": [
            "sum"
          ],
          "show": false
        },
        "showHeader": true,
        "sortBy": []
      },
      "pluginVersion": "9.0.4",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB}"
          },
          "query": "import \"contrib/tomhollingworth/events\"\nimport \"influxdata/influxdb/monitor\"\n\nfrom(bucket: \"LiviusStats\")\n|> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n   // |> range(start: -1d, stop: now())\n    //  |> range(start: 2022-04-13T23:29:39Z, stop: 2022-04-14T15:42:30Z)\n    |> filter(fn: (r) => r[\"_measurement\"] == \"gasstat\")\n    // |> keep(columns: [\"_time\", \"_value\", \"_stop\", \"_measurement\"])\n    |> group()\n    |> sort(columns: [\"_time\"])\n    |> duplicate(column: \"_value\", as: \"gasrate\")\n    |> derivative(unit: 1s, columns: [\"gasrate\"])\n    |> duplicate(column: \"_value\", as: \"gascnt_delta\")\n    |> difference(columns: [\"gascnt_delta\"])\n    |> filter(fn: (r) => r.gascnt_delta > 1)\n    |> reduce(\n        fn: (r, accumulator) =>\n            ({\n                sumVH: (((float(v: r.gasrate < 0.1 and r.gasrate > 0.081) + (float(v: r.gasrate > 0.1) /2.0))* float(v: r.gascnt_delta +1)) *0.105)+ accumulator.sumVH,\n                sumGH: (((float(v: r.gasrate <= 0.081) + (float(v: r.gasrate > 0.1) /2.0))* float(v: r.gascnt_delta +1))* 0.105) + accumulator.sumGH,\n            }),\n        identity: {sumVH: 0.0, sumGH: 0.0},\n    )",
          "refId": "A"
        }
      ],
      "title": "Gas",
      "type": "table"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB-LOCAL}"
      },
      "description": "shows results for the whole time since start of the capture until now",
      "fieldConfig": {
        "defaults": {
          "color": {
            "fixedColor": "text",
            "mode": "fixed"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "axisSoftMin": 0,
            "barAlignment": 0,
            "drawStyle": "bars",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineStyle": {
              "fill": "solid"
            },
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              }
            ]
          },
          "unit": "percentunit"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "Temp"
            },
            "properties": [
              {
                "id": "custom.axisPlacement",
                "value": "right"
              },
              {
                "id": "displayName",
                "value": "Temp"
              },
              {
                "id": "unit",
                "value": "celsius"
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "green",
                  "mode": "fixed"
                }
              },
              {
                "id": "custom.drawStyle",
                "value": "line"
              },
              {
                "id": "custom.lineStyle",
                "value": {
                  "dash": [
                    10,
                    10
                  ],
                  "fill": "dash"
                }
              }
            ]
          },
          {
            "__systemRef": "hideSeriesFrom",
            "matcher": {
              "id": "byNames",
              "options": {
                "mode": "exclude",
                "names": [
                  "Temp",
                  "ratio"
                ],
                "prefix": "All except:",
                "readOnly": true
              }
            },
            "properties": [
              {
                "id": "custom.hideFrom",
                "value": {
                  "legend": true,
                  "tooltip": true,
                  "viz": true
                }
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 8,
        "w": 9,
        "x": 0,
        "y": 4
      },
      "id": 70,
      "options": {
        "legend": {
          "calcs": [
            "min",
            "max",
            "mean"
          ],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "multi",
          "sort": "none"
        }
      },
      "pluginVersion": "8.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "f1 = 2.8\n\n// JAZ rough estimation\nVHWP =\n    from(bucket: \"cloudbktcp\")\n          |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n        |> filter(fn: (r) => r[\"_measurement\"] == \"ePower\")\n        |> filter(fn: (r) => r[\"_field\"] == \"sumWh\")\n        |> filter(fn: (r) => r[\"eMeter\"] == \"VHWP\")\n        |> aggregateWindow(every: 1d, fn: last, createEmpty: false)\n      // |> map(fn: (r) => ({r with _value: float(v: r._value) * f1}))\n        |> difference()\n        |> keep(columns: [\"_time\", \"_value\"])\n        |> rename(columns: {_value: \"VHWPvalue\"})\n        |> yield(name: \"VHWPsum\")\n\nGHWP =\n    from(bucket: \"bktRP4GH\")\n        |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n        |> filter(fn: (r) => r[\"_measurement\"] == \"ePowerWP\")\n        |> filter(fn: (r) => r[\"_field\"] == \"value\")\n        |> filter(fn: (r) => r[\"meter\"] == \"WPGH\")\n        |> filter(fn: (r) => r[\"mptype\"] == \"totalEnergy\")\n        |> aggregateWindow(every: 1d, fn: last, createEmpty: false)\n       // |> map(fn: (r) => ({r with _value: float(v: r._value) * f1}))\n        |> difference()\n        |> keep(columns: [\"_time\", \"_value\"])\n        |> yield(name: \"GHWPsum\")\n\nf2 = 105.0\nGas =\n    from(bucket: \"cloudbktcp\")\n        |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n        |> filter(fn: (r) => r[\"_measurement\"] == \"Gas\")\n        |> filter(fn: (r) => r[\"_field\"] == \"gascnt\")\n        |> increase()\n        |> aggregateWindow(every: 1d, fn: last, createEmpty: false)\n        \n        //ga scnt might restart at 0\n        |> map(fn: (r) => ({r with _value: float(v: r._value) * f2}))\n        |> difference(nonNegative: true)\n        |> keep(columns: [\"_time\", \"_value\"])\n        |> rename(columns: {_value: \"Gasvalue\"})\n        |> yield(name: \"gas\")\n\nWP = join(tables: {VHWP: VHWP, GHWP: GHWP}, on: [\"_time\"])\n|> map(fn: (r) => ({_time: r._time, WPsum: float(v: (r._value + r.VHWPvalue))}))\n//WP\njoin(tables: {WP: WP, Gas: Gas}, on: [\"_time\"])\n|> map(fn: (r) => ({_time: r._time, ratio: (r.WPsum *f1)/ ((r.WPsum*f1) + r.Gasvalue)} ))",
          "refId": "A"
        },
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "hide": false,
          "query": "from(bucket: \"dwdbkt\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"weather\")\n  //|> filter(fn: (r) => r[\"_field\"] == \"value\")\n  |> filter(fn: (r) => r[\"dataset\"] == \"temperature_air\")\n  |>drop (columns: [\"_start\",\"_stop\", \"quality\" ])\n  |> aggregateWindow(every: 1d, fn: mean, createEmpty: false)\n  |> map(fn: (r) => ({\n        r with\n        _value: if r.dataset == \"precipitation\" \n                  then r._value\n                  else (r._value - 273.15) // Kelvin -> °C\n      }))\n  |> rename(columns: {_value: \"Temp\"})\n  |> yield(name: \"Temp\")",
          "refId": "D"
        }
      ],
      "timeFrom": "now-30d/d",
      "title": "Deckungsbeitrag Umweltwärme",
      "transformations": [
        {
          "id": "convertFieldType",
          "options": {
            "conversions": [],
            "fields": {}
          }
        }
      ],
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB-LOCAL}"
      },
      "description": "shows results for the whole time since start of the capture until now",
      "fieldConfig": {
        "defaults": {
          "color": {
            "fixedColor": "blue",
            "mode": "fixed"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "axisSoftMin": 0,
            "barAlignment": 0,
            "drawStyle": "bars",
            "fillOpacity": 24,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineStyle": {
              "fill": "solid"
            },
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "normal"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "displayName": "VHWP",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              }
            ]
          },
          "unit": "short"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "value"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "GHWP"
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "yellow",
                  "mode": "fixed"
                }
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "gascnt"
            },
            "properties": [
              {
                "id": "color",
                "value": {
                  "fixedColor": "red",
                  "mode": "fixed"
                }
              },
              {
                "id": "displayName",
                "value": "Gas"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "Temp"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Temperature  avg"
              },
              {
                "id": "custom.lineStyle",
                "value": {
                  "dash": [
                    0,
                    10
                  ],
                  "fill": "dot"
                }
              },
              {
                "id": "custom.drawStyle",
                "value": "line"
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "green",
                  "mode": "fixed"
                }
              },
              {
                "id": "custom.axisPlacement",
                "value": "right"
              },
              {
                "id": "unit",
                "value": "celsius"
              },
              {
                "id": "custom.stacking",
                "value": {
                  "group": "A",
                  "mode": "none"
                }
              },
              {
                "id": "custom.fillOpacity",
                "value": 0
              },
              {
                "id": "custom.lineStyle",
                "value": {
                  "dash": [
                    10,
                    10
                  ],
                  "fill": "dash"
                }
              },
              {
                "id": "custom.lineWidth",
                "value": 2
              },
              {
                "id": "custom.pointSize",
                "value": 7
              },
              {
                "id": "custom.showPoints",
                "value": "always"
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 14,
        "w": 11,
        "x": 10,
        "y": 4
      },
      "id": 66,
      "options": {
        "legend": {
          "calcs": [
            "min",
            "max",
            "mean",
            "sum"
          ],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "multi",
          "sort": "none"
        }
      },
      "pluginVersion": "8.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "f1 = if (\"${Option1}\" == \"Primary\") then 1.0\n          else  if (\"${Option1}\" == \"Costs\") then 0.00021\n          else 2.8\n\nfrom(bucket: \"cloudbktcp\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePower\")\n  |> filter(fn: (r) => r[\"_field\"] == \"sumWh\")\n  |> filter(fn: (r) => r[\"eMeter\"] == \"VHWP\")\n  |> aggregateWindow(every: 1d, fn: last, createEmpty: false)\n  |> map(fn: (r) => ({\n   r with\n    _value: float(v: r._value)* f1\n     }))\n  |> difference()\n  |> yield(name: \"VHWPsum\")\n",
          "refId": "A"
        },
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "hide": false,
          "query": "f1 = if (\"${Option1}\" == \"Primary\") then 1.0\n          else  if (\"${Option1}\" == \"Costs\") then 0.00021\n          else 2.8\n\nfrom(bucket: \"bktRP4GH\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePowerWP\")\n  |> filter(fn: (r) => r[\"_field\"] == \"value\")\n  |> filter(fn: (r) => r[\"meter\"] == \"WPGH\")\n  |> filter(fn: (r) => r[\"mptype\"] == \"totalEnergy\")\n  |> aggregateWindow(every: 1d, fn: last, createEmpty: false)\n  |> map(fn: (r) => ({\n   r with\n    _value: float(v: r._value)*f1\n     }))\n  |> difference()\n  |> yield(name: \"GHWPsum\")",
          "refId": "B"
        },
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "hide": false,
          "query": "f2 = if (\"${Option1}\" == \"Primary\") then 108.0\n          else  if (\"${Option1}\" == \"Costs\") then 0.0044\n          else 108.0*0.8\n\nfrom(bucket: \"cloudbktcp\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"Gas\")\n  |> filter(fn: (r) => r[\"_field\"] == \"gascnt\")\n  |> increase()\n  |> aggregateWindow(every: 1d, fn: last, createEmpty: false)\n   //ga scnt might restart at 0\n|> map(fn: (r) => ({\n   r with\n    _value: float(v: r._value)*f2\n     }))\n  |> difference(nonNegative: true)\n  \n  |> yield(name: \"gas\")",
          "refId": "C"
        },
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "hide": false,
          "query": "from(bucket: \"dwdbkt\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"weather\")\n  //|> filter(fn: (r) => r[\"_field\"] == \"value\")\n  |> filter(fn: (r) => r[\"dataset\"] == \"temperature_air\")\n  |>drop (columns: [\"_start\",\"_stop\", \"quality\" ])\n  |> aggregateWindow(every: 1d, fn: mean, createEmpty: false)\n  |> map(fn: (r) => ({\n        r with\n        _value: if r.dataset == \"precipitation\" \n                  then r._value\n                  else (r._value - 273.15) // Kelvin -> °C\n      }))\n  |> rename(columns: {_value: \"Temp\"})\n  |> yield(name: \"Temp\")",
          "refId": "D"
        }
      ],
      "timeFrom": "now-30d/d",
      "title": "Daily  Heating $Option1",
      "transformations": [
        {
          "id": "convertFieldType",
          "options": {
            "conversions": [],
            "fields": {}
          }
        }
      ],
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB-LOCAL}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "bars",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineStyle": {
              "fill": "solid"
            },
            "lineWidth": 1,
            "pointSize": 3,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": true,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "kwatth"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 5,
        "w": 8,
        "x": 0,
        "y": 12
      },
      "id": 57,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "8.4.3",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "from(bucket: \"cloudbktcp\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"Gas\")\n  |> filter(fn: (r) => r[\"_field\"] == \"gascnt\")\n  |> increase() //gascnt might restart at 0\n  |> aggregateWindow(every: 1d, fn: last, createEmpty: false)\n  \n  |> difference(nonNegative: true)\n  |> map(fn: (r) => ({\n   r with\n    _value: float(v: r._value)*0.105\n     }))\n  \n  |> yield(name: \"gas\")",
          "refId": "A"
        }
      ],
      "timeFrom": "now-30d/d",
      "title": "Gas",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB_RP4GH}"
      },
      "description": "shows results for the whole time since start of the capture until now",
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "axisSoftMin": 0,
            "barAlignment": 0,
            "drawStyle": "bars",
            "fillOpacity": 15,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineStyle": {
              "fill": "solid"
            },
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "always",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "displayName": "Daily Sum",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              }
            ]
          },
          "unit": "watth"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "runtime_sum"
            },
            "properties": [
              {
                "id": "color",
                "value": {
                  "fixedColor": "light-yellow",
                  "mode": "fixed"
                }
              },
              {
                "id": "custom.axisLabel",
                "value": "runtime"
              },
              {
                "id": "unit",
                "value": "s"
              },
              {
                "id": "custom.axisPlacement",
                "value": "right"
              },
              {
                "id": "displayName",
                "value": "runtime sum"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "value"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Energy sum"
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "blue",
                  "mode": "fixed"
                }
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 5,
        "w": 9,
        "x": 0,
        "y": 17
      },
      "id": 5,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "multi",
          "sort": "none"
        }
      },
      "pluginVersion": "8.2.2",
      "targets": [
        {
          "query": " import \"influxdata/influxdb/monitor\"\nfrom(bucket: \"statbkt\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePowerWP\")\n  |> filter(fn: (r) => r[\"_field\"] == \"value\")\n  //next steps are just for safety, if there a multiple tables\n |> group()\n |> sort(columns: [\"_time\"])\n |> monitor.stateChangesOnly()\n |> group()\n |> sort(columns: [\"_time\"])\n|>elapsed()\n//we want only the time between 2 off = info\n|> filter (fn: (r) => r[\"_level\"] == \"info\")\n|> sort(columns: [\"elapsed\"])\n|> filter (fn: (r) => r[\"elapsed\"] < 7200)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> aggregateWindow(every: 1d, column: \"elapsed\", fn: sum)\n|> rename(columns: {elapsed: \"runtime_sum\"})\n|> yield (name: \"runtime_sum\")\n \n from(bucket: \"bktWP\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePowerWP\")\n  |> filter(fn: (r) => r[\"_field\"] == \"value\")\n  |> filter(fn: (r) => r[\"meter\"] == \"WPGH\")\n  |> filter(fn: (r) => r[\"mptype\"] == \"totalEnergy\")\n  |> aggregateWindow(every: 1d, fn: last, createEmpty: false)\n  |> difference()\n  |> yield(name: \"energy_sum\")\n",
          "refId": "A",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB_RP4GH}"
          }
        }
      ],
      "timeFrom": "now-14d/d",
      "title": "GH Power Consumption WP Daily",
      "transformations": [
        {
          "id": "convertFieldType",
          "options": {
            "conversions": [],
            "fields": {}
          }
        }
      ],
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB-LOCAL}"
      },
      "description": "shows results for the whole time since start of the capture until now",
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "axisSoftMin": 0,
            "barAlignment": 0,
            "drawStyle": "bars",
            "fillOpacity": 15,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineStyle": {
              "fill": "solid"
            },
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "always",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "displayName": "Daily Sum",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              }
            ]
          },
          "unit": "watth"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "runtime_sum"
            },
            "properties": [
              {
                "id": "color",
                "value": {
                  "fixedColor": "light-yellow",
                  "mode": "fixed"
                }
              },
              {
                "id": "custom.axisLabel",
                "value": "runtime"
              },
              {
                "id": "unit",
                "value": "s"
              },
              {
                "id": "custom.axisPlacement",
                "value": "right"
              },
              {
                "id": "displayName",
                "value": "runtime sum"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "sumWh"
            },
            "properties": [
              {
                "id": "color",
                "value": {
                  "fixedColor": "semi-dark-blue",
                  "mode": "fixed"
                }
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 5,
        "w": 9,
        "x": 10,
        "y": 18
      },
      "id": 46,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "multi",
          "sort": "none"
        }
      },
      "pluginVersion": "8.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": " import \"influxdata/influxdb/monitor\"\nfrom(bucket: \"LiviusStats\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n   |> filter(fn: (r) => r[\"_measurement\"] == \"vhwp_runs_from_total\")\n  |> filter(fn: (r) => r[\"_field\"] == \"sumWh\")\n  //next steps are just for safety, if there a multiple tables\n |> group()\n |> sort(columns: [\"_time\"])\n |> monitor.stateChangesOnly()\n |> group()\n |> sort(columns: [\"_time\"])\n|>elapsed()\n//we want only the time between 2 off = info\n|> filter (fn: (r) => r[\"_level\"] == \"info\")\n|> sort(columns: [\"elapsed\"])\n|> filter (fn: (r) => r[\"elapsed\"] < 7200)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> aggregateWindow(every: 1d, column: \"elapsed\", fn: sum)\n|> rename(columns: {elapsed: \"runtime_sum\"})\n|> yield (name: \"runtime_sum\")\n \nfrom(bucket: \"cloudbktcp\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePower\")\n  |> filter(fn: (r) => r[\"_field\"] == \"sumWh\")\n  |> filter(fn: (r) => r[\"eMeter\"] == \"VHWP\")\n  |> aggregateWindow(every: 1d, fn: last, createEmpty: false)\n  |> difference()\n  |> yield(name: \"energy_sum\")",
          "refId": "A"
        }
      ],
      "timeFrom": "now-14d/d",
      "title": "VH Power Consumption WP Daily",
      "transformations": [
        {
          "id": "convertFieldType",
          "options": {
            "conversions": [],
            "fields": {}
          }
        }
      ],
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB_RP4GH}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "bars",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "displayName": "Hausstrom",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "watth"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 5,
        "w": 10,
        "x": 0,
        "y": 22
      },
      "id": 37,
      "options": {
        "legend": {
          "calcs": [
            "min",
            "max",
            "mean",
            "sum"
          ],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "targets": [
        {
          "query": "from(bucket: \"bktWP\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePowerWP\")\n  |> filter(fn: (r) => r[\"meter\"] == \"HSGH\")\n  |> filter(fn: (r) => r[\"mptype\"] == \"totalEnergy\")\n  |> aggregateWindow(every: 1d, fn: max, createEmpty: false)\n  |> difference()\n  |> yield(name: \"max\")",
          "refId": "A",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB_RP4GH}"
          }
        }
      ],
      "timeFrom": "now-30d/d",
      "title": "GH Hausstrom täglich",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB-LOCAL}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "bars",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "displayName": "Hausstrom",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "watth"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 6,
        "w": 10,
        "x": 10,
        "y": 23
      },
      "id": 64,
      "options": {
        "legend": {
          "calcs": [
            "min",
            "max",
            "mean",
            "sum"
          ],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "from(bucket: \"cloudbktcp\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePower\")\n  |> filter(fn: (r) => r[\"_field\"] == \"sumWh\")\n  |> filter(fn: (r) => r[\"eMeter\"] == \"VHHS\")\n  |> aggregateWindow(every: 1d, fn: max, createEmpty: false)\n  |> difference()\n  |> yield(name: \"max\")",
          "refId": "A"
        }
      ],
      "timeFrom": "now-30d/d",
      "title": "VH Hausstrom täglich",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB-LOCAL}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "celsius"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "value {dataset=\"precipitation\", parameter=\"precipitation_height\", station_id=\"00433\"}"
            },
            "properties": [
              {
                "id": "color",
                "value": {
                  "fixedColor": "light-purple",
                  "mode": "fixed"
                }
              },
              {
                "id": "custom.drawStyle",
                "value": "bars"
              },
              {
                "id": "custom.showPoints",
                "value": "always"
              },
              {
                "id": "displayName",
                "value": "Niederschlag"
              },
              {
                "id": "custom.fillOpacity",
                "value": 18
              },
              {
                "id": "unit",
                "value": "lengthmm"
              },
              {
                "id": "custom.lineStyle",
                "value": {
                  "fill": "solid"
                }
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "value {dataset=\"temperature_air\", parameter=\"temperature_air_mean_200\", station_id=\"00433\"}"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Lufttemperatur in 2 m Höhe"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "value {dataset=\"dew_point\", parameter=\"temperature_dew_point_mean_200\", station_id=\"00433\"}"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Taupunkt in °C"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "Taupunkt in °C"
            },
            "properties": [
              {
                "id": "color",
                "value": {
                  "fixedColor": "light-blue",
                  "mode": "fixed"
                }
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "Lufttemperatur in 2 m Höhe"
            },
            "properties": [
              {
                "id": "color",
                "value": {
                  "fixedColor": "light-orange",
                  "mode": "fixed"
                }
              }
            ]
          },
          {
            "__systemRef": "hideSeriesFrom",
            "matcher": {
              "id": "byNames",
              "options": {
                "mode": "exclude",
                "names": [
                  "Lufttemperatur in 2 m Höhe",
                  "Niederschlag"
                ],
                "prefix": "All except:",
                "readOnly": true
              }
            },
            "properties": [
              {
                "id": "custom.hideFrom",
                "value": {
                  "legend": false,
                  "tooltip": false,
                  "viz": true
                }
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 10,
        "w": 17,
        "x": 0,
        "y": 29
      },
      "id": 28,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "targets": [
        {
          "query": "from(bucket: \"dwdbkt\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"weather\")\n  //|> filter(fn: (r) => r[\"_field\"] == \"value\")\n  |>drop (columns: [\"_start\",\"_stop\", \"quality\" ])\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> map(fn: (r) => ({\n        r with\n        _value: if r.dataset == \"precipitation\" \n                  then r._value\n                  else (r._value - 273.15)\n      }))\n  |> yield(name: \"mean\")",
          "refId": "A",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          }
        }
      ],
      "title": "DWD Tempelhof Wetter",
      "type": "timeseries"
    },
    {
      "collapsed": false,
      "datasource": {
        "type": "influxdb",
        "uid": "5YkhJsqMz"
      },
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 39
      },
      "id": 24,
      "panels": [],
      "title": "last 2 weeks",
      "type": "row"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB-LOCAL}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "celsius"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "value {dataset=\"precipitation\", parameter=\"precipitation_height\", station_id=\"00433\"}"
            },
            "properties": [
              {
                "id": "color",
                "value": {
                  "fixedColor": "light-purple",
                  "mode": "fixed"
                }
              },
              {
                "id": "custom.drawStyle",
                "value": "bars"
              },
              {
                "id": "custom.showPoints",
                "value": "always"
              },
              {
                "id": "displayName",
                "value": "Niederschlag"
              },
              {
                "id": "custom.fillOpacity",
                "value": 18
              },
              {
                "id": "unit",
                "value": "lengthmm"
              },
              {
                "id": "custom.lineStyle",
                "value": {
                  "fill": "solid"
                }
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "value {dataset=\"temperature_air\", parameter=\"temperature_air_mean_200\", station_id=\"00433\"}"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Lufttemperatur in 2 m Höhe"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "value {dataset=\"dew_point\", parameter=\"temperature_dew_point_mean_200\", station_id=\"00433\"}"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Taupunkt in °C"
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 9,
        "w": 13,
        "x": 0,
        "y": 40
      },
      "id": 22,
      "interval": "1h",
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "targets": [
        {
          "query": "from(bucket: \"dwdbkt\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"weather\")\n  //|> filter(fn: (r) => r[\"_field\"] == \"value\")\n  |>drop (columns: [\"_start\",\"_stop\", \"quality\" ])\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> map(fn: (r) => ({\n        r with\n        _value: if r.dataset == \"precipitation\" \n                  then r._value\n                  else (r._value - 273.15)\n      }))\n  |> yield(name: \"mean\")",
          "refId": "A",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          }
        }
      ],
      "timeFrom": "now-30d/d",
      "title": "Wetterdaten DWD Tempelhof",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB_RP4GH}"
      },
      "description": "shows result for the actual Time Range",
      "fieldConfig": {
        "defaults": {
          "color": {
            "fixedColor": "text",
            "mode": "fixed"
          },
          "custom": {
            "axisLabel": "RunTime scale",
            "axisPlacement": "auto",
            "axisSoftMax": 1,
            "axisSoftMin": 0,
            "barAlignment": 0,
            "drawStyle": "bars",
            "fillOpacity": 9,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineWidth": 2,
            "pointSize": 10,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "decimals": 0,
          "links": [],
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          },
          "unit": "s"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "min"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "min"
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "semi-dark-red",
                  "mode": "thresholds"
                }
              },
              {
                "id": "thresholds",
                "value": {
                  "mode": "absolute",
                  "steps": [
                    {
                      "color": "dark-red"
                    },
                    {
                      "color": "semi-dark-red",
                      "value": 30
                    },
                    {
                      "color": "light-red",
                      "value": 60
                    },
                    {
                      "color": "super-light-red",
                      "value": 120
                    }
                  ]
                }
              },
              {
                "id": "custom.lineWidth",
                "value": 3
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "mean"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "mean"
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "#e2bc0e78",
                  "mode": "fixed"
                }
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "max"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "max"
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "light-green",
                  "mode": "fixed"
                }
              },
              {
                "id": "custom.lineWidth",
                "value": 1
              },
              {
                "id": "custom.showPoints",
                "value": "always"
              },
              {
                "id": "custom.pointSize",
                "value": 4
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "count"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "count"
              },
              {
                "id": "unit",
                "value": "none"
              },
              {
                "id": "custom.axisPlacement",
                "value": "right"
              },
              {
                "id": "custom.drawStyle",
                "value": "points"
              },
              {
                "id": "custom.pointSize",
                "value": 9
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "dark-blue",
                  "mode": "fixed"
                }
              },
              {
                "id": "custom.axisLabel",
                "value": "count"
              },
              {
                "id": "custom.scaleDistribution",
                "value": {
                  "type": "linear"
                }
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "sum"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "sum"
              },
              {
                "id": "custom.lineWidth",
                "value": 1
              }
            ]
          },
          {
            "__systemRef": "hideSeriesFrom",
            "matcher": {
              "id": "byNames",
              "options": {
                "mode": "exclude",
                "names": [
                  "min"
                ],
                "prefix": "All except:",
                "readOnly": true
              }
            },
            "properties": [
              {
                "id": "custom.hideFrom",
                "value": {
                  "legend": false,
                  "tooltip": false,
                  "viz": true
                }
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 7,
        "w": 8,
        "x": 0,
        "y": 49
      },
      "id": 20,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "multi",
          "sort": "none"
        }
      },
      "pluginVersion": "8.2.2",
      "targets": [
        {
          "query": "import \"influxdata/influxdb/monitor\"\nelapsed_tbl = from(bucket: \"statbkt\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePowerWP\")\n  |> filter(fn: (r) => r[\"_field\"] == \"value\")\n  //next steps are just for safety, if there a multiple tables\n |> group()\n |> sort(columns: [\"_time\"])\n |> monitor.stateChangesOnly()\n |> group()\n |> sort(columns: [\"_time\"])\n|>elapsed()\n//we want only the time between 2 off = info\n|> filter (fn: (r) => r[\"_level\"] == \"info\")\n|> filter (fn: (r) => r[\"elapsed\"] < 14400)\n//|> keep (columns: [\"elapsed\", \"_time\"])\n\nelapsed_tbl\n|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\", fn: min)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> rename(columns: {elapsed: \"min\"})\n|> yield (name: \"min\")\n\nelapsed_tbl\n|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\", fn: mean)\n|> rename(columns: {elapsed: \"mean\"})\n|> yield (name: \"mean\")\n\nelapsed_tbl\n|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\", fn: max)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> rename(columns: {elapsed: \"max\"})\n|> yield (name: \"max\")\n\nelapsed_tbl\n|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\",fn: count)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> rename(columns: {elapsed: \"count\"})\n|> yield (name: \"count\")\n\nelapsed_tbl\n|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\", fn: sum)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> rename(columns: {elapsed: \"sum\"})\n|> yield (name: \"sum\")",
          "refId": "A",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB_RP4GH}"
          }
        }
      ],
      "timeFrom": "now-30d/d",
      "title": "GHWP RunTime Stats",
      "transformations": [
        {
          "id": "convertFieldType",
          "options": {
            "conversions": [
              {
                "destinationType": "string",
                "targetField": "le"
              }
            ],
            "fields": {}
          }
        }
      ],
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB-LOCAL}"
      },
      "description": "shows result for the actual Time Range",
      "fieldConfig": {
        "defaults": {
          "color": {
            "fixedColor": "text",
            "mode": "fixed"
          },
          "custom": {
            "axisLabel": "RunTime scale",
            "axisPlacement": "auto",
            "axisSoftMax": 1,
            "axisSoftMin": 0,
            "barAlignment": 0,
            "drawStyle": "bars",
            "fillOpacity": 9,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineWidth": 2,
            "pointSize": 10,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "decimals": 0,
          "links": [],
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          },
          "unit": "s"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "min"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "min"
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "semi-dark-red",
                  "mode": "thresholds"
                }
              },
              {
                "id": "thresholds",
                "value": {
                  "mode": "absolute",
                  "steps": [
                    {
                      "color": "dark-red"
                    },
                    {
                      "color": "semi-dark-red",
                      "value": 30
                    },
                    {
                      "color": "light-red",
                      "value": 60
                    },
                    {
                      "color": "super-light-red",
                      "value": 120
                    }
                  ]
                }
              },
              {
                "id": "custom.lineWidth",
                "value": 3
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "mean"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "mean"
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "dark-yellow",
                  "mode": "fixed"
                }
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "max"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "max"
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "light-green",
                  "mode": "fixed"
                }
              },
              {
                "id": "custom.lineWidth",
                "value": 1
              },
              {
                "id": "custom.showPoints",
                "value": "always"
              },
              {
                "id": "custom.pointSize",
                "value": 4
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "count"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "count"
              },
              {
                "id": "unit",
                "value": "none"
              },
              {
                "id": "custom.axisPlacement",
                "value": "right"
              },
              {
                "id": "custom.drawStyle",
                "value": "points"
              },
              {
                "id": "custom.pointSize",
                "value": 9
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "semi-dark-green",
                  "mode": "fixed"
                }
              },
              {
                "id": "custom.axisLabel",
                "value": "count"
              },
              {
                "id": "custom.scaleDistribution",
                "value": {
                  "type": "linear"
                }
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "sum"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "sum"
              },
              {
                "id": "custom.lineWidth",
                "value": 1
              }
            ]
          },
          {
            "__systemRef": "hideSeriesFrom",
            "matcher": {
              "id": "byNames",
              "options": {
                "mode": "exclude",
                "names": [
                  "min"
                ],
                "prefix": "All except:",
                "readOnly": true
              }
            },
            "properties": [
              {
                "id": "custom.hideFrom",
                "value": {
                  "legend": false,
                  "tooltip": false,
                  "viz": true
                }
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 7,
        "w": 9,
        "x": 8,
        "y": 49
      },
      "id": 43,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "multi",
          "sort": "none"
        }
      },
      "pluginVersion": "8.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "elapsed_tbl = from(bucket: \"LiviusStats\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"vhwp_runs_from_total\")\n  |> filter(fn: (r) => r[\"_field\"] == \"sumWh\")\n  |>group()\n |> sort(columns: [\"_time\"])\n|> elapsed()\n|> filter (fn: (r) => r[\"_level\"] == \"info\")\n|> sort(columns: [\"elapsed\"])\n|> filter (fn: (r) => r[\"elapsed\"] < 10000)\n//|> keep (columns: [\"elapsed\"])\n|> keep (columns: [\"elapsed\", \"_time\"])\n\nelapsed_tbl\n|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\", fn: min)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> rename(columns: {elapsed: \"min\"})\n|> yield (name: \"min\")\n\nelapsed_tbl\n|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\", fn: mean)\n|> rename(columns: {elapsed: \"mean\"})\n|> yield (name: \"mean\")\n\nelapsed_tbl\n|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\", fn: max)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> rename(columns: {elapsed: \"max\"})\n|> yield (name: \"max\")\n\nelapsed_tbl\n|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\",fn: count)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> rename(columns: {elapsed: \"count\"})\n|> yield (name: \"count\")\n\nelapsed_tbl\n|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\", fn: sum)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> rename(columns: {elapsed: \"sum\"})\n|> yield (name: \"sum\")",
          "refId": "A"
        }
      ],
      "timeFrom": "now-30d/d",
      "title": "VHWP RunTime Stats",
      "transformations": [
        {
          "id": "convertFieldType",
          "options": {
            "conversions": [
              {
                "destinationType": "string",
                "targetField": "le"
              }
            ],
            "fields": {}
          }
        }
      ],
      "type": "timeseries"
    },
    {
      "alert": {
        "alertRuleTags": {},
        "conditions": [
          {
            "evaluator": {
              "params": [
                100
              ],
              "type": "lt"
            },
            "operator": {
              "type": "and"
            },
            "query": {
              "params": [
                "A",
                "2h",
                "now"
              ]
            },
            "reducer": {
              "params": [],
              "type": "sum"
            },
            "type": "query"
          }
        ],
        "executionErrorState": "alerting",
        "for": "8h",
        "frequency": "1h",
        "handler": 1,
        "message": "grafana hat beim stündlichen Stromverbrauch der WPGH einen  Wert kleiner 1000 Wh entdeckt",
        "name": "Power Consumption WP hourly alert",
        "noDataState": "alerting",
        "notifications": []
      },
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB-LOCAL}"
      },
      "description": "shows results for the whole time since start of the capture until now",
      "fieldConfig": {
        "defaults": {
          "color": {
            "fixedColor": "green",
            "mode": "thresholds",
            "seriesBy": "last"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "bars",
            "fillOpacity": 5,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineStyle": {
              "fill": "solid"
            },
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "displayName": "hour sum",
          "mappings": [],
          "thresholds": {
            "mode": "percentage",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "#EAB839",
                "value": 50
              },
              {
                "color": "light-red",
                "value": 75
              },
              {
                "color": "dark-red",
                "value": 80.0001
              }
            ]
          },
          "unit": "watth"
        },
        "overrides": [
          {
            "__systemRef": "hideSeriesFrom",
            "matcher": {
              "id": "byNames",
              "options": {
                "mode": "exclude",
                "names": [
                  "hour sum"
                ],
                "prefix": "All except:",
                "readOnly": true
              }
            },
            "properties": [
              {
                "id": "custom.hideFrom",
                "value": {
                  "legend": false,
                  "tooltip": false,
                  "viz": true
                }
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "hour sum"
            },
            "properties": [
              {
                "id": "color",
                "value": {
                  "fixedColor": "green",
                  "mode": "fixed"
                }
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 6,
        "w": 11,
        "x": 0,
        "y": 56
      },
      "id": 7,
      "options": {
        "legend": {
          "calcs": [
            "max",
            "mean",
            "sum"
          ],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "8.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "from(bucket: \"bktRP4GH\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePowerWP\")\n  //|> filter(fn: (r) => r[\"_field\"] == \"value\")\n  |> filter(fn: (r) => r[\"meter\"] == \"WPGH\")\n  |> filter(fn: (r) => r[\"mptype\"] == \"totalEnergy\")\n  |> aggregateWindow(every: 1h, fn: last)\n  |> difference()\n  |> filter(fn: (r) => r[\"_value\"] < 20000)\n  |> yield(name: \"sum\")",
          "refId": "A"
        }
      ],
      "thresholds": [
        {
          "colorMode": "critical",
          "op": "lt",
          "value": 100,
          "visible": true
        }
      ],
      "timeShift": "65m",
      "title": "GH WP Power Consumption hourly",
      "transformations": [],
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB-LOCAL}"
      },
      "description": "shows results for the whole time since start of the capture until now",
      "fieldConfig": {
        "defaults": {
          "color": {
            "fixedColor": "green",
            "mode": "thresholds",
            "seriesBy": "last"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "bars",
            "fillOpacity": 5,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineStyle": {
              "fill": "solid"
            },
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "displayName": "hour sum",
          "mappings": [],
          "thresholds": {
            "mode": "percentage",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "#EAB839",
                "value": 50
              },
              {
                "color": "light-red",
                "value": 75
              },
              {
                "color": "dark-red",
                "value": 80.0001
              }
            ]
          },
          "unit": "watth"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 6,
        "w": 11,
        "x": 11,
        "y": 56
      },
      "id": 44,
      "options": {
        "legend": {
          "calcs": [
            "max",
            "mean",
            "sum"
          ],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "8.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "from(bucket: \"cloudbktcp\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePower\")\n  |> filter(fn: (r) => r[\"eMeter\"] == \"VHWP\")\n  |> filter(fn: (r) => r[\"_field\"] == \"sumWh\")\n  |> aggregateWindow(every: 1h, fn: last)\n  |> difference()\n  |> filter(fn: (r) => r[\"_value\"] < 20000)\n  |> yield(name: \"sum\")",
          "refId": "A"
        }
      ],
      "title": "VH WP Power Consumption hourly",
      "transformations": [],
      "type": "timeseries"
    },
    {
      "collapsed": false,
      "datasource": {
        "type": "influxdb",
        "uid": "5YkhJsqMz"
      },
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 62
      },
      "id": 10,
      "panels": [],
      "title": "Laufzeiten",
      "type": "row"
    },
    {
      "datasource": {
        "type": "datasource",
        "uid": "-- Mixed --"
      },
      "description": "shows result for the actual Time Range",
      "fieldConfig": {
        "defaults": {
          "color": {
            "fixedColor": "blue",
            "mode": "fixed"
          },
          "custom": {
            "axisLabel": "Häufigkeit",
            "axisPlacement": "auto",
            "axisSoftMin": 0,
            "fillOpacity": 80,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineWidth": 1,
            "scaleDistribution": {
              "type": "linear"
            }
          },
          "displayName": "Display Name",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          },
          "unit": "none"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "_value"
            },
            "properties": [
              {
                "id": "unit",
                "value": "percentunit"
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 6,
        "w": 9,
        "x": 0,
        "y": 63
      },
      "id": 6,
      "options": {
        "barRadius": 0,
        "barWidth": 0.66,
        "groupWidth": 0.7,
        "legend": {
          "calcs": [],
          "displayMode": "hidden",
          "placement": "bottom"
        },
        "orientation": "auto",
        "showValue": "auto",
        "stacking": "none",
        "text": {},
        "tooltip": {
          "mode": "single",
          "sort": "none"
        },
        "xTickLabelRotation": 0,
        "xTickLabelSpacing": 0
      },
      "pluginVersion": "8.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB_RP4GH}"
          },
          "query": "import \"influxdata/influxdb/monitor\"\nfrom(bucket: \"statbkt\")\n  |> range(start: 2021-11-06T18:00:00Z, stop: now())\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePowerWP\")\n  |> filter(fn: (r) => r[\"_field\"] == \"value\")\n  //next steps are just for safety, if there a multiple tables\n |> group()\n |> sort(columns: [\"_time\"])\n |> monitor.stateChangesOnly()\n |> group()\n |> sort(columns: [\"_time\"])\n|>elapsed()\n//we want only the time between 2 off = info\n|> filter (fn: (r) => r[\"_level\"] == \"info\")\n|> sort(columns: [\"elapsed\"])\n|> filter (fn: (r) => r[\"elapsed\"] < 10000)\n|> keep (columns: [\"elapsed\"])\n|> rename(columns: {elapsed: \"_value\"})\n|> toFloat()\n|> histogram(\n       bins:[0.0, 60.0, 120.0, 300.0, 600.0, 1200.0, 1800.0, 2400.0, 3600.0, 7200.0, 43000.0],\n       normalize: true\n   )\n|> difference()",
          "refId": "A"
        }
      ],
      "title": "GHWP Laufzeit in s Histogram overall",
      "transformations": [
        {
          "id": "convertFieldType",
          "options": {
            "conversions": [
              {
                "destinationType": "string",
                "targetField": "le"
              }
            ],
            "fields": {}
          }
        }
      ],
      "type": "barchart"
    },
    {
      "datasource": {
        "type": "datasource",
        "uid": "-- Mixed --"
      },
      "description": "shows result for the actual Time Range",
      "fieldConfig": {
        "defaults": {
          "color": {
            "fixedColor": "green",
            "mode": "fixed"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "axisSoftMin": 0,
            "fillOpacity": 80,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineWidth": 1,
            "scaleDistribution": {
              "type": "linear"
            }
          },
          "displayName": "Starts",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          },
          "unit": "none"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 6,
        "w": 8,
        "x": 9,
        "y": 63
      },
      "id": 41,
      "options": {
        "barRadius": 0,
        "barWidth": 0.66,
        "groupWidth": 0.7,
        "legend": {
          "calcs": [
            "sum"
          ],
          "displayMode": "list",
          "placement": "bottom"
        },
        "orientation": "auto",
        "showValue": "auto",
        "stacking": "none",
        "text": {},
        "tooltip": {
          "mode": "single",
          "sort": "none"
        },
        "xTickLabelRotation": 0,
        "xTickLabelSpacing": 0
      },
      "pluginVersion": "8.2.2",
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "from(bucket: \"LiviusStats\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"vhwp_runs_from_total\")\n  |> filter(fn: (r) => r[\"_field\"] == \"sumWh\")\n  |>group()\n |> sort(columns: [\"_time\"])\n|> elapsed()\n|> filter (fn: (r) => r[\"_level\"] == \"info\")\n|> sort(columns: [\"elapsed\"])\n|> filter (fn: (r) => r[\"elapsed\"] < 10000)\n|> keep (columns: [\"elapsed\"])\n|> rename(columns: {elapsed: \"_value\"})\n|> toFloat()\n|> histogram(\n       bins:[0.0, 60.0, 120.0, 300.0, 600.0, 1200.0, 1800.0, 2400.0, 3600.0, 7200.0, float(v: \"+Inf\")]\n   )\n|> difference()\n",
          "refId": "A"
        }
      ],
      "title": "VHWP Laufzeit in s Histogram TimeRange",
      "transformations": [
        {
          "id": "convertFieldType",
          "options": {
            "conversions": [
              {
                "destinationType": "string",
                "targetField": "le"
              }
            ],
            "fields": {}
          }
        }
      ],
      "type": "barchart"
    },
    {
      "datasource": {
        "type": "influxdb",
        "uid": "${DS_INFLUXDB_RP4GH}"
      },
      "description": "shows result for the actual Time Range",
      "fieldConfig": {
        "defaults": {
          "color": {
            "fixedColor": "semi-dark-blue",
            "mode": "fixed"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "axisSoftMin": 0,
            "fillOpacity": 80,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineWidth": 1,
            "scaleDistribution": {
              "type": "linear"
            }
          },
          "displayName": "Starts",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 6,
        "w": 7,
        "x": 17,
        "y": 63
      },
      "id": 4,
      "options": {
        "barRadius": 0,
        "barWidth": 0.66,
        "groupWidth": 0.7,
        "legend": {
          "calcs": [
            "sum"
          ],
          "displayMode": "list",
          "placement": "bottom"
        },
        "orientation": "auto",
        "showValue": "auto",
        "stacking": "none",
        "text": {},
        "tooltip": {
          "mode": "single",
          "sort": "none"
        },
        "xTickLabelRotation": 0,
        "xTickLabelSpacing": 0
      },
      "pluginVersion": "8.2.2",
      "targets": [
        {
          "query": "import \"influxdata/influxdb/monitor\"\nfrom(bucket: \"statbkt\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePowerWP\")\n  |> filter(fn: (r) => r[\"_field\"] == \"value\")\n  //next steps are just for safety, if there a multiple tables\n |> group()\n |> sort(columns: [\"_time\"])\n |> monitor.stateChangesOnly()\n |> group()\n |> sort(columns: [\"_time\"])\n|>elapsed()\n//we want only the time between 2 off = info\n|> filter (fn: (r) => r[\"_level\"] == \"info\")\n|> sort(columns: [\"elapsed\"])\n|> filter (fn: (r) => r[\"elapsed\"] < 7200)\n|> keep (columns: [\"elapsed\"])\n|> rename(columns: {elapsed: \"_value\"})\n|> toFloat()\n|> histogram(\n       bins:[0.0, 60.0, 120.0, 300.0, 600.0, 1200.0, 1800.0, 2400.0, 3600.0, 7200.0, float(v: \"+Inf\")]\n   )\n|> difference()",
          "refId": "A",
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB_RP4GH}"
          }
        }
      ],
      "title": "GH WP RunTime Histogram TimeRange",
      "transformations": [
        {
          "id": "convertFieldType",
          "options": {
            "conversions": [
              {
                "destinationType": "string",
                "targetField": "le"
              }
            ],
            "fields": {}
          }
        }
      ],
      "type": "barchart"
    },
    {
      "datasource": {
        "type": "datasource",
        "uid": "-- Mixed --"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "celsius"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "weather value {dataset=\"temperature_air\", parameter=\"temperature_air_mean_200\", station_id=\"00433\"}"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Lufttemperatur in 2 m Höhe"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "count"
            },
            "properties": [
              {
                "id": "custom.axisPlacement",
                "value": "right"
              },
              {
                "id": "unit",
                "value": "none"
              },
              {
                "id": "custom.lineStyle",
                "value": {
                  "dash": [
                    0,
                    10
                  ],
                  "fill": "dot"
                }
              },
              {
                "id": "custom.drawStyle",
                "value": "line"
              },
              {
                "id": "custom.showPoints",
                "value": "always"
              },
              {
                "id": "custom.pointSize",
                "value": 5
              },
              {
                "id": "displayName",
                "value": "WP_GH Starts pro Tag"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "VHcount"
            },
            "properties": [
              {
                "id": "custom.drawStyle",
                "value": "line"
              },
              {
                "id": "custom.axisPlacement",
                "value": "right"
              },
              {
                "id": "custom.lineStyle",
                "value": {
                  "dash": [
                    0,
                    10
                  ],
                  "fill": "dot"
                }
              },
              {
                "id": "custom.showPoints",
                "value": "always"
              },
              {
                "id": "unit",
                "value": "none"
              },
              {
                "id": "displayName",
                "value": "WP_VH Starts pro Tag"
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 9,
        "w": 15,
        "x": 0,
        "y": 69
      },
      "id": 38,
      "interval": "1h",
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "from(bucket: \"dwdbkt\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"weather\")\n  //|> filter(fn: (r) => r[\"_field\"] == \"value\")\n  |> filter(fn: (r) => r[\"dataset\"] == \"temperature_air\")\n  |>drop (columns: [\"_start\",\"_stop\", \"quality\" ])\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> map(fn: (r) => ({\n        r with\n        _value: if r.dataset == \"precipitation\" \n                  then r._value\n                  else (r._value - 273.15) // Kelvin -> °C\n      }))\n  |> yield(name: \"mean\")",
          "refId": "A"
        },
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB_RP4GH}"
          },
          "hide": false,
          "query": "import \"influxdata/influxdb/monitor\"\nelapsed_tbl = from(bucket: \"statbkt\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePowerWP\")\n  |> filter(fn: (r) => r[\"_field\"] == \"value\")\n  //next steps are just for safety, if there a multiple tables\n |> group()\n |> sort(columns: [\"_time\"])\n |> monitor.stateChangesOnly()\n |> group()\n |> sort(columns: [\"_time\"])\n|>elapsed()\n//we want only the time between 2 off = info\n|> filter (fn: (r) => r[\"_level\"] == \"info\")\n|> filter (fn: (r) => r[\"elapsed\"] < 14400)\n//|> keep (columns: [\"elapsed\", \"_time\"])\n\n\nelapsed_tbl\n//|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\",fn: count)\n|> aggregateWindow(every: 1d, column: \"elapsed\",fn: count)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> rename(columns: {elapsed: \"count\"})\n|> yield (name: \"count\")",
          "refId": "B"
        },
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "hide": false,
          "query": "from(bucket: \"LiviusStats\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"vhwp_runs_from_total\")\n  |> filter(fn: (r) => r[\"_field\"] == \"sumWh\")\n  |>group()\n |> sort(columns: [\"_time\"])\n|> elapsed()\n|> filter (fn: (r) => r[\"_level\"] == \"info\")\n|> sort(columns: [\"elapsed\"])\n|> filter (fn: (r) => r[\"elapsed\"] < 10000)\n//|> keep (columns: [\"elapsed\"])\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\",fn: count)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> rename(columns: {elapsed: \"VHcount\"})\n|> yield (name: \"VHcount\")",
          "refId": "C"
        }
      ],
      "timeFrom": "now-60d/d",
      "title": "Aussen-Temperatur und tägliche WP Starts",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "datasource",
        "uid": "-- Mixed --"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineStyle": {
              "dash": [
                10,
                10
              ],
              "fill": "dash"
            },
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "celsius"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "weather value {dataset=\"temperature_air\", parameter=\"temperature_air_mean_200\", station_id=\"00433\"}"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Lufttemperatur in 2 m Höhe"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "mean"
            },
            "properties": [
              {
                "id": "custom.axisPlacement",
                "value": "right"
              },
              {
                "id": "unit",
                "value": "none"
              },
              {
                "id": "custom.lineStyle",
                "value": {
                  "dash": [
                    0,
                    10
                  ],
                  "fill": "dot"
                }
              },
              {
                "id": "custom.drawStyle",
                "value": "line"
              },
              {
                "id": "custom.showPoints",
                "value": "always"
              },
              {
                "id": "custom.pointSize",
                "value": 5
              },
              {
                "id": "displayName",
                "value": "durchschnittliche WP Laufzeit in s"
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 8,
        "w": 15,
        "x": 7,
        "y": 78
      },
      "id": 55,
      "interval": "1h",
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "from(bucket: \"dwdbkt\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"weather\")\n  //|> filter(fn: (r) => r[\"_field\"] == \"value\")\n  |> filter(fn: (r) => r[\"dataset\"] == \"temperature_air\")\n  |>drop (columns: [\"_start\",\"_stop\", \"quality\" ])\n  |> aggregateWindow(every: 1d, fn: mean, createEmpty: false)\n  |> map(fn: (r) => ({\n        r with\n        _value: if r.dataset == \"precipitation\" \n                  then r._value\n                  else (r._value - 273.15) // Kelvin -> °C\n      }))\n  |> yield(name: \"mean\")",
          "refId": "A"
        },
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB_RP4GH}"
          },
          "hide": false,
          "query": "import \"influxdata/influxdb/monitor\"\nelapsed_tbl = from(bucket: \"statbkt\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePowerWP\")\n  |> filter(fn: (r) => r[\"_field\"] == \"value\")\n  //next steps are just for safety, if there a multiple tables\n |> group()\n |> sort(columns: [\"_time\"])\n |> monitor.stateChangesOnly()\n |> group()\n |> sort(columns: [\"_time\"])\n|>elapsed()\n//we want only the time between 2 off = info\n|> filter (fn: (r) => r[\"_level\"] == \"info\")\n|> filter (fn: (r) => r[\"elapsed\"] < 14400)\n//|> keep (columns: [\"elapsed\", \"_time\"])\n\n\nelapsed_tbl\n//|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\",fn: mean)\n|> aggregateWindow(every: 1d, column: \"elapsed\",fn: mean)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> rename(columns: {elapsed: \"mean\"})\n|> yield (name: \"mean\")",
          "refId": "B"
        }
      ],
      "timeFrom": "now-60d/d",
      "title": "durchschnittliche Aussen-Temp und tägliche WP mean runtime",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "datasource",
        "uid": "-- Mixed --"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineStyle": {
              "dash": [
                10,
                10
              ],
              "fill": "dash"
            },
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "celsius"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "value"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Lufttemperatur in 2 m Höhe"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "count"
            },
            "properties": [
              {
                "id": "custom.axisPlacement",
                "value": "right"
              },
              {
                "id": "unit",
                "value": "none"
              },
              {
                "id": "custom.lineStyle",
                "value": {
                  "dash": [
                    0,
                    10
                  ],
                  "fill": "dot"
                }
              },
              {
                "id": "custom.drawStyle",
                "value": "line"
              },
              {
                "id": "custom.showPoints",
                "value": "always"
              },
              {
                "id": "custom.pointSize",
                "value": 5
              },
              {
                "id": "displayName",
                "value": "WP Starts pro Tag"
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 7,
        "w": 13,
        "x": 9,
        "y": 86
      },
      "id": 40,
      "interval": "1h",
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom"
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "targets": [
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB-LOCAL}"
          },
          "query": "from(bucket: \"dwdbkt\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"weather\")\n  //|> filter(fn: (r) => r[\"_field\"] == \"value\")\n  |> filter(fn: (r) => r[\"dataset\"] == \"temperature_air\")\n  |>drop (columns: [\"_start\",\"_stop\", \"quality\" ])\n  |> aggregateWindow(every: 1d, fn: mean, createEmpty: false)\n  |> map(fn: (r) => ({\n        r with\n        _value: if r.dataset == \"precipitation\" \n                  then r._value\n                  else (r._value - 273.15) // Kelvin -> °C\n      }))\n  |> yield(name: \"mean\")",
          "refId": "A"
        },
        {
          "datasource": {
            "type": "influxdb",
            "uid": "${DS_INFLUXDB_RP4GH}"
          },
          "hide": false,
          "query": "import \"influxdata/influxdb/monitor\"\nelapsed_tbl = from(bucket: \"statbkt\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"ePowerWP\")\n  |> filter(fn: (r) => r[\"_field\"] == \"value\")\n  //next steps are just for safety, if there a multiple tables\n |> group()\n |> sort(columns: [\"_time\"])\n |> monitor.stateChangesOnly()\n |> group()\n |> sort(columns: [\"_time\"])\n|>elapsed()\n//we want only the time between 2 off = info\n|> filter (fn: (r) => r[\"_level\"] == \"info\")\n|> filter (fn: (r) => r[\"elapsed\"] < 14400)\n//|> keep (columns: [\"elapsed\", \"_time\"])\n\n\nelapsed_tbl\n//|> aggregateWindow(every: 1d, column: \"elapsed\", timeSrc: \"_start\",fn: count)\n|> aggregateWindow(every: 1d, column: \"elapsed\",fn: count)\n|> keep (columns: [\"elapsed\", \"_time\"])\n|> rename(columns: {elapsed: \"count\"})\n|> yield (name: \"count\")",
          "refId": "B"
        }
      ],
      "timeFrom": "now-60d/d",
      "title": "durchschnittliche Aussen-Temp und tägliche WP Starts",
      "type": "timeseries"
    }
  ],
  "refresh": false,
  "schemaVersion": 36,
  "style": "dark",
  "tags": [],
  "templating": {
    "list": [
      {
        "current": {
          "selected": true,
          "text": "Primary",
          "value": "Primary"
        },
        "hide": 0,
        "includeAll": false,
        "label": "Daily Heating Option",
        "multi": false,
        "name": "Option1",
        "options": [
          {
            "selected": false,
            "text": "Costs",
            "value": "Costs"
          },
          {
            "selected": true,
            "text": "Primary",
            "value": "Primary"
          },
          {
            "selected": false,
            "text": "Heat",
            "value": "Heat"
          }
        ],
        "query": "Costs, Primary, Heat",
        "queryValue": "",
        "skipUrlSync": false,
        "type": "custom"
      }
    ]
  },
  "time": {
    "from": "now-24h",
    "to": "now"
  },
  "timepicker": {},
  "timezone": "",
  "title": "HZG Stats Livius",
  "uid": "GI9Zk85nk",
  "version": 357,
  "weekStart": "",
  "gnetId": 17109
}