Skip to content
  • Home
  • Aktuell
  • Tags
  • 0 Ungelesen 0
  • Kategorien
  • Unreplied
  • Beliebt
  • GitHub
  • Docu
  • Hilfe
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Standard: (Kein Skin)
  • Kein Skin
Einklappen
ioBroker Logo

Community Forum

donate donate
  1. ioBroker Community Home
  2. Deutsch
  3. Visualisierung
  4. Grafana Tagesverbrauch

NEWS

  • UPDATE 31.10.: Amazon Alexa - ioBroker Skill läuft aus ?
    apollon77A
    apollon77
    48
    3
    8.9k

  • Monatsrückblick – September 2025
    BluefoxB
    Bluefox
    13
    1
    2.3k

  • Neues Video "KI im Smart Home" - ioBroker plus n8n
    BluefoxB
    Bluefox
    16
    1
    3.4k

Grafana Tagesverbrauch

Geplant Angeheftet Gesperrt Verschoben Visualisierung
how-to
55 Beiträge 8 Kommentatoren 19.2k Aufrufe 10 Watching
  • Älteste zuerst
  • Neuste zuerst
  • Meiste Stimmen
Antworten
  • In einem neuen Thema antworten
Anmelden zum Antworten
Dieses Thema wurde gelöscht. Nur Nutzer mit entsprechenden Rechten können es sehen.
  • NegaleinN Offline
    NegaleinN Offline
    Negalein
    Global Moderator
    schrieb am zuletzt editiert von
    #20

    @crunchip

    Kannst du nochmal schauen?

    Diese DP werden jetzt befüllt.
    Seit Mitternacht auch im positiven Bereich für Sonntag.
    objects - ioBroker (6).png

    In Grafana hab ich es so eingetragen.
    Allgemein - Grafana (6).png

    Trotzdem steht "no Data".
    Allgemein - Grafana (7).png

    Trag ich als Query direkt den DP ein, kommt ein Balken.
    Allgemein - Grafana (9).png
    Allgemein - Grafana (8).png

    Was mach ich da falsch?

    Danke

    ° Node.js: 20.17.0 NPM: 10.8.2
    ° Proxmox, Ubuntu 22.04.3 LTS
    ° Fixer ---> iob fix

    crunchipC 1 Antwort Letzte Antwort
    0
    • NegaleinN Negalein

      @crunchip

      Kannst du nochmal schauen?

      Diese DP werden jetzt befüllt.
      Seit Mitternacht auch im positiven Bereich für Sonntag.
      objects - ioBroker (6).png

      In Grafana hab ich es so eingetragen.
      Allgemein - Grafana (6).png

      Trotzdem steht "no Data".
      Allgemein - Grafana (7).png

      Trag ich als Query direkt den DP ein, kommt ein Balken.
      Allgemein - Grafana (9).png
      Allgemein - Grafana (8).png

      Was mach ich da falsch?

      Danke

      crunchipC Abwesend
      crunchipC Abwesend
      crunchip
      Forum Testing Most Active
      schrieb am zuletzt editiert von crunchip
      #21

      @Negalein bist du sicher das die Bezeichnung richtig geschrieben ist? kommt mir irgendwie etwas komisch vor mit dem...hs100__0__10....(die doppelten unterstriche)

      umgestiegen von Proxmox auf Unraid

      NegaleinN 1 Antwort Letzte Antwort
      0
      • crunchipC crunchip

        @Negalein bist du sicher das die Bezeichnung richtig geschrieben ist? kommt mir irgendwie etwas komisch vor mit dem...hs100__0__10....(die doppelten unterstriche)

        NegaleinN Offline
        NegaleinN Offline
        Negalein
        Global Moderator
        schrieb am zuletzt editiert von
        #22

        @crunchip sagte in Grafana Tagesverbrauch:

        bist du sicher das die Bezeichnung richtig geschrieben ist? kommt mir irgendwie etwas komisch vor mit dem...hs100__0__10....(die doppelten unterstriche)

        Ja, gerade nochmal geschaut.

        So siehts in Source aus:
        objects - ioBroker (7).png

        Und so die DP:
        zB der sourceanalytix.0.hs100__0__10_0_1_80__power.Meter_Readings.Current_Reading
        objects - ioBroker (8).png

        ° Node.js: 20.17.0 NPM: 10.8.2
        ° Proxmox, Ubuntu 22.04.3 LTS
        ° Fixer ---> iob fix

        crunchipC 1 Antwort Letzte Antwort
        0
        • NegaleinN Negalein

          @crunchip sagte in Grafana Tagesverbrauch:

          bist du sicher das die Bezeichnung richtig geschrieben ist? kommt mir irgendwie etwas komisch vor mit dem...hs100__0__10....(die doppelten unterstriche)

          Ja, gerade nochmal geschaut.

          So siehts in Source aus:
          objects - ioBroker (7).png

          Und so die DP:
          zB der sourceanalytix.0.hs100__0__10_0_1_80__power.Meter_Readings.Current_Reading
          objects - ioBroker (8).png

          crunchipC Abwesend
          crunchipC Abwesend
          crunchip
          Forum Testing Most Active
          schrieb am zuletzt editiert von
          #23

          @Negalein mach mal ein neues dasboard füge die json ein...und natürlich deinen Datenpunkt anpassen

          {
           "__inputs": [
             {
               "name": "DS_INFLUXDB",
               "label": "InfluxDB",
               "description": "",
               "type": "datasource",
               "pluginId": "influxdb",
               "pluginName": "InfluxDB"
             }
           ],
           "__requires": [
             {
               "type": "panel",
               "id": "gauge",
               "name": "Gauge",
               "version": ""
             },
             {
               "type": "grafana",
               "id": "grafana",
               "name": "Grafana",
               "version": "6.5.2"
             },
             {
               "type": "panel",
               "id": "grafana-piechart-panel",
               "name": "Pie Chart",
               "version": "1.4.0"
             },
             {
               "type": "panel",
               "id": "graph",
               "name": "Graph",
               "version": ""
             },
             {
               "type": "datasource",
               "id": "influxdb",
               "name": "InfluxDB",
               "version": "1.0.0"
             },
             {
               "type": "panel",
               "id": "yesoreyeram-boomtheme-panel",
               "name": "Boom Theme",
               "version": "0.1.0"
             }
           ],
           "annotations": {
             "list": [
               {
                 "builtIn": 1,
                 "datasource": "-- Grafana --",
                 "enable": true,
                 "hide": true,
                 "iconColor": "rgba(0, 211, 255, 1)",
                 "name": "Annotations & Alerts",
                 "type": "dashboard"
               }
             ]
           },
           "editable": true,
           "gnetId": null,
           "graphTooltip": 0,
           "id": null,
           "links": [
             {
               "asDropdown": false,
               "icon": "dashboard",
               "tags": [
                 "Strom"
               ],
               "title": "Strom",
               "tooltip": "",
               "type": "dashboards"
             }
           ],
           "panels": [
             {
               "activeThemeId": 0,
               "datasource": "${DS_INFLUXDB}",
               "disableThemePicker": true,
               "gridPos": {
                 "h": 3,
                 "w": 24,
                 "x": 0,
                 "y": 0
               },
               "id": 12,
               "options": {},
               "targets": [
                 {
                   "groupBy": [
                     {
                       "params": [
                         "$__interval"
                       ],
                       "type": "time"
                     },
                     {
                       "params": [
                         "null"
                       ],
                       "type": "fill"
                     }
                   ],
                   "orderByTime": "ASC",
                   "policy": "default",
                   "refId": "A",
                   "resultFormat": "time_series",
                   "select": [
                     [
                       {
                         "params": [
                           "value"
                         ],
                         "type": "field"
                       },
                       {
                         "params": [],
                         "type": "mean"
                       }
                     ]
                   ],
                   "tags": []
                 }
               ],
               "themes": [
                 {
                   "name": "Night Theme",
                   "styles": [
                     {
                       "props": {
                         "theme": "default"
                       },
                       "type": "basetheme"
                     },
                     {
                       "props": {
                         "url": "https://images.unsplash.com/photo-1524334228333-0f6db392f8a1"
                       },
                       "type": "bgimage"
                     },
                     {
                       "props": {
                         "text": ".panel-container {\n    background-color: rgba(0,0,0,0.3);\n}"
                       },
                       "type": "style"
                     }
                   ]
                 },
                 {
                   "name": "Theme 2",
                   "styles": [
                     {
                       "props": {
                         "theme": "light"
                       },
                       "type": "basetheme"
                     },
                     {
                       "props": {
                         "url": "/public/img/hintergrund/energie.jpg"
                       },
                       "type": "bgimage"
                     },
                     {
                       "props": {
                         "text": ""
                       },
                       "type": "style"
                     }
                   ]
                 }
               ],
               "timeFrom": null,
               "timeShift": null,
               "title": "",
               "transparent": true,
               "type": "yesoreyeram-boomtheme-panel"
             },
             {
               "aliasColors": {
                 "Stromverbrauch": "semi-dark-green"
               },
               "bars": true,
               "dashLength": 10,
               "dashes": false,
               "datasource": "${DS_INFLUXDB}",
               "fill": 1,
               "fillGradient": 0,
               "gridPos": {
                 "h": 5,
                 "w": 21,
                 "x": 0,
                 "y": 3
               },
               "hiddenSeries": false,
               "id": 2,
               "interval": "10s",
               "legend": {
                 "avg": true,
                 "current": false,
                 "max": true,
                 "min": false,
                 "show": true,
                 "total": false,
                 "values": true
               },
               "lines": false,
               "linewidth": 1,
               "links": [],
               "nullPointMode": "null",
               "options": {
                 "dataLinks": []
               },
               "percentage": false,
               "pointradius": 2,
               "points": false,
               "renderer": "flot",
               "seriesOverrides": [],
               "spaceLength": 10,
               "stack": true,
               "steppedLine": false,
               "targets": [
                 {
                   "alias": "Stromverbrauch",
                   "groupBy": [
                     {
                       "params": [
                         "24h"
                       ],
                       "type": "time"
                     },
                     {
                       "params": [
                         "null"
                       ],
                       "type": "fill"
                     }
                   ],
                   "measurement": "wiffi-wz.0.root.192_168_178_33.w_counter_1",
                   "orderByTime": "ASC",
                   "policy": "default",
                   "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"wiffi-wz.0.root.10_1_30_10.w_counter_1\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')",
                   "rawQuery": true,
                   "refId": "A",
                   "resultFormat": "time_series",
                   "select": [
                     [
                       {
                         "params": [
                           "value"
                         ],
                         "type": "field"
                       },
                       {
                         "params": [],
                         "type": "mean"
                       }
                     ]
                   ],
                   "tags": []
                 }
               ],
               "thresholds": [],
               "timeFrom": null,
               "timeRegions": [],
               "timeShift": null,
               "title": "Strom",
               "tooltip": {
                 "shared": true,
                 "sort": 0,
                 "value_type": "cumulative"
               },
               "transparent": true,
               "type": "graph",
               "xaxis": {
                 "buckets": null,
                 "mode": "time",
                 "name": null,
                 "show": true,
                 "values": []
               },
               "yaxes": [
                 {
                   "format": "kwatth",
                   "label": null,
                   "logBase": 1,
                   "max": null,
                   "min": null,
                   "show": true
                 },
                 {
                   "format": "short",
                   "label": null,
                   "logBase": 1,
                   "max": null,
                   "min": null,
                   "show": true
                 }
               ],
               "yaxis": {
                 "align": false,
                 "alignLevel": null
               }
             },
             {
               "cacheTimeout": null,
               "datasource": "${DS_INFLUXDB}",
               "gridPos": {
                 "h": 5,
                 "w": 3,
                 "x": 21,
                 "y": 3
               },
               "id": 6,
               "links": [],
               "options": {
                 "fieldOptions": {
                   "calcs": [
                     "last"
                   ],
                   "defaults": {
                     "decimals": 2,
                     "mappings": [
                       {
                         "id": 0,
                         "op": "=",
                         "text": "N/A",
                         "type": 1,
                         "value": "null"
                       }
                     ],
                     "max": 150,
                     "min": 0,
                     "nullValueMode": "connected",
                     "thresholds": [
                       {
                         "color": "dark-green",
                         "value": null
                       },
                       {
                         "color": "dark-yellow",
                         "value": 80
                       },
                       {
                         "color": "dark-red",
                         "value": 120
                       }
                     ],
                     "unit": "currencyEUR"
                   },
                   "override": {},
                   "values": false
                 },
                 "orientation": "horizontal",
                 "showThresholdLabels": false,
                 "showThresholdMarkers": true
               },
               "pluginVersion": "6.5.2",
               "targets": [
                 {
                   "alias": "",
                   "groupBy": [
                     {
                       "params": [
                         "$__interval"
                       ],
                       "type": "time"
                     },
                     {
                       "params": [
                         "null"
                       ],
                       "type": "fill"
                     }
                   ],
                   "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.cost.03_current_month",
                   "orderByTime": "ASC",
                   "policy": "default",
                   "refId": "A",
                   "resultFormat": "time_series",
                   "select": [
                     [
                       {
                         "params": [
                           "value"
                         ],
                         "type": "field"
                       },
                       {
                         "params": [],
                         "type": "distinct"
                       }
                     ]
                   ],
                   "tags": []
                 }
               ],
               "timeFrom": null,
               "timeShift": null,
               "title": "Monatskosten",
               "transparent": true,
               "type": "gauge"
             },
             {
               "aliasColors": {
                 "Gasverbrauch": "semi-dark-red"
               },
               "bars": true,
               "dashLength": 10,
               "dashes": false,
               "datasource": "${DS_INFLUXDB}",
               "fill": 1,
               "fillGradient": 0,
               "gridPos": {
                 "h": 5,
                 "w": 21,
                 "x": 0,
                 "y": 8
               },
               "hiddenSeries": false,
               "id": 3,
               "interval": "10s",
               "legend": {
                 "avg": true,
                 "current": false,
                 "max": true,
                 "min": false,
                 "show": true,
                 "total": false,
                 "values": true
               },
               "lines": false,
               "linewidth": 1,
               "links": [],
               "nullPointMode": "null",
               "options": {
                 "dataLinks": []
               },
               "percentage": false,
               "pointradius": 2,
               "points": false,
               "renderer": "flot",
               "seriesOverrides": [],
               "spaceLength": 10,
               "stack": true,
               "steppedLine": false,
               "targets": [
                 {
                   "alias": "Gasverbrauch",
                   "groupBy": [
                     {
                       "params": [
                         "24h"
                       ],
                       "type": "time"
                     },
                     {
                       "params": [
                         "null"
                       ],
                       "type": "fill"
                     }
                   ],
                   "measurement": "wiffi-wz.0.root.10_1_30_10.w_counter_2",
                   "orderByTime": "ASC",
                   "policy": "default",
                   "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"wiffi-wz.0.root.10_1_30_10.w_counter_2\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')",
                   "rawQuery": true,
                   "refId": "B",
                   "resultFormat": "time_series",
                   "select": [
                     [
                       {
                         "params": [
                           "value"
                         ],
                         "type": "field"
                       },
                       {
                         "params": [],
                         "type": "mean"
                       }
                     ]
                   ],
                   "tags": []
                 }
               ],
               "thresholds": [],
               "timeFrom": null,
               "timeRegions": [],
               "timeShift": null,
               "title": "Heizung",
               "tooltip": {
                 "shared": true,
                 "sort": 0,
                 "value_type": "cumulative"
               },
               "transparent": true,
               "type": "graph",
               "xaxis": {
                 "buckets": null,
                 "mode": "time",
                 "name": null,
                 "show": true,
                 "values": []
               },
               "yaxes": [
                 {
                   "format": "m3",
                   "label": null,
                   "logBase": 1,
                   "max": null,
                   "min": null,
                   "show": true
                 },
                 {
                   "format": "short",
                   "label": null,
                   "logBase": 1,
                   "max": null,
                   "min": null,
                   "show": true
                 }
               ],
               "yaxis": {
                 "align": false,
                 "alignLevel": null
               }
             },
             {
               "cacheTimeout": null,
               "datasource": "${DS_INFLUXDB}",
               "gridPos": {
                 "h": 5,
                 "w": 3,
                 "x": 21,
                 "y": 8
               },
               "id": 7,
               "links": [],
               "options": {
                 "fieldOptions": {
                   "calcs": [
                     "last"
                   ],
                   "defaults": {
                     "decimals": 2,
                     "mappings": [
                       {
                         "id": 0,
                         "op": "=",
                         "text": "N/A",
                         "type": 1,
                         "value": "null"
                       }
                     ],
                     "max": 200,
                     "min": 0,
                     "nullValueMode": "connected",
                     "thresholds": [
                       {
                         "color": "dark-green",
                         "value": null
                       },
                       {
                         "color": "dark-yellow",
                         "value": 130
                       },
                       {
                         "color": "dark-red",
                         "value": 170
                       }
                     ],
                     "unit": "currencyEUR"
                   },
                   "override": {},
                   "values": false
                 },
                 "orientation": "horizontal",
                 "showThresholdLabels": false,
                 "showThresholdMarkers": true
               },
               "pluginVersion": "6.5.2",
               "targets": [
                 {
                   "alias": "",
                   "groupBy": [
                     {
                       "params": [
                         "$__interval"
                       ],
                       "type": "time"
                     },
                     {
                       "params": [
                         "null"
                       ],
                       "type": "fill"
                     }
                   ],
                   "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_2.cost.03_current_month",
                   "orderByTime": "ASC",
                   "policy": "default",
                   "refId": "A",
                   "resultFormat": "time_series",
                   "select": [
                     [
                       {
                         "params": [
                           "value"
                         ],
                         "type": "field"
                       },
                       {
                         "params": [],
                         "type": "distinct"
                       }
                     ]
                   ],
                   "tags": []
                 }
               ],
               "timeFrom": null,
               "timeShift": null,
               "title": "Monatskosten",
               "transparent": true,
               "type": "gauge"
             },
             {
               "aliasColors": {
                 "Wasserverbrauch": "semi-dark-blue"
               },
               "bars": true,
               "dashLength": 10,
               "dashes": false,
               "datasource": "${DS_INFLUXDB}",
               "fill": 1,
               "fillGradient": 0,
               "gridPos": {
                 "h": 5,
                 "w": 21,
                 "x": 0,
                 "y": 13
               },
               "hiddenSeries": false,
               "hideTimeOverride": false,
               "id": 4,
               "interval": "10s",
               "legend": {
                 "avg": true,
                 "current": false,
                 "hideEmpty": false,
                 "hideZero": false,
                 "max": true,
                 "min": false,
                 "show": true,
                 "total": false,
                 "values": true
               },
               "lines": false,
               "linewidth": 1,
               "links": [],
               "nullPointMode": "null",
               "options": {
                 "dataLinks": []
               },
               "percentage": false,
               "pointradius": 2,
               "points": false,
               "renderer": "flot",
               "seriesOverrides": [],
               "spaceLength": 10,
               "stack": true,
               "steppedLine": false,
               "targets": [
                 {
                   "alias": "Wasserverbrauch",
                   "groupBy": [
                     {
                       "params": [
                         "24h"
                       ],
                       "type": "time"
                     },
                     {
                       "params": [
                         "null"
                       ],
                       "type": "fill"
                     }
                   ],
                   "measurement": "wiffi-wz.0.root.10_1_30_10.w_counter_3",
                   "orderByTime": "ASC",
                   "policy": "default",
                   "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"wiffi-wz.0.root.10_1_30_10.w_counter_3\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')",
                   "rawQuery": true,
                   "refId": "A",
                   "resultFormat": "time_series",
                   "select": [
                     [
                       {
                         "params": [
                           "value"
                         ],
                         "type": "field"
                       },
                       {
                         "params": [],
                         "type": "mean"
                       }
                     ]
                   ],
                   "tags": []
                 }
               ],
               "thresholds": [],
               "timeFrom": null,
               "timeRegions": [],
               "timeShift": null,
               "title": "Wasser",
               "tooltip": {
                 "shared": true,
                 "sort": 0,
                 "value_type": "cumulative"
               },
               "transparent": true,
               "type": "graph",
               "xaxis": {
                 "buckets": null,
                 "mode": "time",
                 "name": null,
                 "show": true,
                 "values": []
               },
               "yaxes": [
                 {
                   "format": "m3",
                   "label": null,
                   "logBase": 1,
                   "max": null,
                   "min": null,
                   "show": true
                 },
                 {
                   "format": "short",
                   "label": null,
                   "logBase": 1,
                   "max": null,
                   "min": null,
                   "show": true
                 }
               ],
               "yaxis": {
                 "align": false,
                 "alignLevel": null
               }
             },
             {
               "cacheTimeout": null,
               "datasource": "${DS_INFLUXDB}",
               "gridPos": {
                 "h": 5,
                 "w": 3,
                 "x": 21,
                 "y": 13
               },
               "id": 8,
               "links": [],
               "options": {
                 "fieldOptions": {
                   "calcs": [
                     "last"
                   ],
                   "defaults": {
                     "decimals": 2,
                     "mappings": [
                       {
                         "id": 0,
                         "op": "=",
                         "text": "N/A",
                         "type": 1,
                         "value": "null"
                       }
                     ],
                     "max": 7,
                     "min": 0,
                     "nullValueMode": "connected",
                     "thresholds": [
                       {
                         "color": "dark-green",
                         "value": null
                       },
                       {
                         "color": "dark-yellow",
                         "value": 4.5
                       },
                       {
                         "color": "dark-red",
                         "value": 6
                       }
                     ],
                     "unit": "currencyEUR"
                   },
                   "override": {},
                   "values": false
                 },
                 "orientation": "horizontal",
                 "showThresholdLabels": false,
                 "showThresholdMarkers": true
               },
               "pluginVersion": "6.5.2",
               "targets": [
                 {
                   "alias": "",
                   "groupBy": [
                     {
                       "params": [
                         "$__interval"
                       ],
                       "type": "time"
                     },
                     {
                       "params": [
                         "null"
                       ],
                       "type": "fill"
                     }
                   ],
                   "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.cost.03_current_month",
                   "orderByTime": "ASC",
                   "policy": "default",
                   "refId": "A",
                   "resultFormat": "time_series",
                   "select": [
                     [
                       {
                         "params": [
                           "value"
                         ],
                         "type": "field"
                       },
                       {
                         "params": [],
                         "type": "distinct"
                       }
                     ]
                   ],
                   "tags": []
                 }
               ],
               "timeFrom": null,
               "timeShift": null,
               "title": "Monatskosten",
               "transparent": true,
               "type": "gauge"
             },
             {
               "aliasColors": {
                 "Heizung": "#E02F44",
                 "Strom": "#56A64B",
                 "Wasser": "#3274D9"
               },
               "breakPoint": "50%",
               "cacheTimeout": null,
               "combine": {
                 "label": "Others",
                 "threshold": "0"
               },
               "datasource": "${DS_INFLUXDB}",
               "fontSize": "100%",
               "format": "currencyEUR",
               "gridPos": {
                 "h": 8,
                 "w": 5,
                 "x": 0,
                 "y": 18
               },
               "id": 10,
               "interval": null,
               "legend": {
                 "percentage": true,
                 "show": true,
                 "values": true
               },
               "legendType": "On graph",
               "links": [],
               "maxDataPoints": 3,
               "nullPointMode": "connected",
               "options": {},
               "pieType": "pie",
               "pluginVersion": "6.5.2",
               "strokeWidth": 1,
               "targets": [
                 {
                   "alias": "Strom",
                   "groupBy": [
                     {
                       "params": [
                         "$__interval"
                       ],
                       "type": "time"
                     },
                     {
                       "params": [
                         "null"
                       ],
                       "type": "fill"
                     }
                   ],
                   "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.cost.03_current_month",
                   "orderByTime": "ASC",
                   "policy": "default",
                   "refId": "A",
                   "resultFormat": "time_series",
                   "select": [
                     [
                       {
                         "params": [
                           "value"
                         ],
                         "type": "field"
                       },
                       {
                         "params": [],
                         "type": "mean"
                       }
                     ]
                   ],
                   "tags": []
                 },
                 {
                   "alias": "Heizung",
                   "groupBy": [
                     {
                       "params": [
                         "$__interval"
                       ],
                       "type": "time"
                     },
                     {
                       "params": [
                         "null"
                       ],
                       "type": "fill"
                     }
                   ],
                   "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_2.cost.03_current_month",
                   "orderByTime": "ASC",
                   "policy": "default",
                   "refId": "B",
                   "resultFormat": "time_series",
                   "select": [
                     [
                       {
                         "params": [
                           "value"
                         ],
                         "type": "field"
                       },
                       {
                         "params": [],
                         "type": "mean"
                       }
                     ]
                   ],
                   "tags": []
                 },
                 {
                   "alias": "Wasser",
                   "groupBy": [
                     {
                       "params": [
                         "$__interval"
                       ],
                       "type": "time"
                     },
                     {
                       "params": [
                         "null"
                       ],
                       "type": "fill"
                     }
                   ],
                   "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.cost.03_current_month",
                   "orderByTime": "ASC",
                   "policy": "default",
                   "refId": "C",
                   "resultFormat": "time_series",
                   "select": [
                     [
                       {
                         "params": [
                           "value"
                         ],
                         "type": "field"
                       },
                       {
                         "params": [],
                         "type": "mean"
                       }
                     ]
                   ],
                   "tags": []
                 }
               ],
               "timeFrom": null,
               "timeShift": null,
               "title": "Pie Chart",
               "transparent": true,
               "type": "grafana-piechart-panel",
               "valueName": "current"
             }
           ],
           "schemaVersion": 21,
           "style": "dark",
           "tags": [
             "Monatsverbrauch"
           ],
           "templating": {
             "list": []
           },
           "time": {
             "from": "now/M",
             "to": "now"
           },
           "timepicker": {
             "refresh_intervals": [
               "5s",
               "10s",
               "30s",
               "1m",
               "5m",
               "15m",
               "30m",
               "1h",
               "2h",
               "1d"
             ],
             "time_options": [
               "5m",
               "15m",
               "1h",
               "6h",
               "12h",
               "24h",
               "2d",
               "7d",
               "30d"
             ]
           },
           "timezone": "",
           "title": "Monatsverbrauch",
           "uid": "_tteA1VZz",
           "version": 73
          }
          

          umgestiegen von Proxmox auf Unraid

          NegaleinN 1 Antwort Letzte Antwort
          0
          • crunchipC crunchip

            @Negalein mach mal ein neues dasboard füge die json ein...und natürlich deinen Datenpunkt anpassen

            {
             "__inputs": [
               {
                 "name": "DS_INFLUXDB",
                 "label": "InfluxDB",
                 "description": "",
                 "type": "datasource",
                 "pluginId": "influxdb",
                 "pluginName": "InfluxDB"
               }
             ],
             "__requires": [
               {
                 "type": "panel",
                 "id": "gauge",
                 "name": "Gauge",
                 "version": ""
               },
               {
                 "type": "grafana",
                 "id": "grafana",
                 "name": "Grafana",
                 "version": "6.5.2"
               },
               {
                 "type": "panel",
                 "id": "grafana-piechart-panel",
                 "name": "Pie Chart",
                 "version": "1.4.0"
               },
               {
                 "type": "panel",
                 "id": "graph",
                 "name": "Graph",
                 "version": ""
               },
               {
                 "type": "datasource",
                 "id": "influxdb",
                 "name": "InfluxDB",
                 "version": "1.0.0"
               },
               {
                 "type": "panel",
                 "id": "yesoreyeram-boomtheme-panel",
                 "name": "Boom Theme",
                 "version": "0.1.0"
               }
             ],
             "annotations": {
               "list": [
                 {
                   "builtIn": 1,
                   "datasource": "-- Grafana --",
                   "enable": true,
                   "hide": true,
                   "iconColor": "rgba(0, 211, 255, 1)",
                   "name": "Annotations & Alerts",
                   "type": "dashboard"
                 }
               ]
             },
             "editable": true,
             "gnetId": null,
             "graphTooltip": 0,
             "id": null,
             "links": [
               {
                 "asDropdown": false,
                 "icon": "dashboard",
                 "tags": [
                   "Strom"
                 ],
                 "title": "Strom",
                 "tooltip": "",
                 "type": "dashboards"
               }
             ],
             "panels": [
               {
                 "activeThemeId": 0,
                 "datasource": "${DS_INFLUXDB}",
                 "disableThemePicker": true,
                 "gridPos": {
                   "h": 3,
                   "w": 24,
                   "x": 0,
                   "y": 0
                 },
                 "id": 12,
                 "options": {},
                 "targets": [
                   {
                     "groupBy": [
                       {
                         "params": [
                           "$__interval"
                         ],
                         "type": "time"
                       },
                       {
                         "params": [
                           "null"
                         ],
                         "type": "fill"
                       }
                     ],
                     "orderByTime": "ASC",
                     "policy": "default",
                     "refId": "A",
                     "resultFormat": "time_series",
                     "select": [
                       [
                         {
                           "params": [
                             "value"
                           ],
                           "type": "field"
                         },
                         {
                           "params": [],
                           "type": "mean"
                         }
                       ]
                     ],
                     "tags": []
                   }
                 ],
                 "themes": [
                   {
                     "name": "Night Theme",
                     "styles": [
                       {
                         "props": {
                           "theme": "default"
                         },
                         "type": "basetheme"
                       },
                       {
                         "props": {
                           "url": "https://images.unsplash.com/photo-1524334228333-0f6db392f8a1"
                         },
                         "type": "bgimage"
                       },
                       {
                         "props": {
                           "text": ".panel-container {\n    background-color: rgba(0,0,0,0.3);\n}"
                         },
                         "type": "style"
                       }
                     ]
                   },
                   {
                     "name": "Theme 2",
                     "styles": [
                       {
                         "props": {
                           "theme": "light"
                         },
                         "type": "basetheme"
                       },
                       {
                         "props": {
                           "url": "/public/img/hintergrund/energie.jpg"
                         },
                         "type": "bgimage"
                       },
                       {
                         "props": {
                           "text": ""
                         },
                         "type": "style"
                       }
                     ]
                   }
                 ],
                 "timeFrom": null,
                 "timeShift": null,
                 "title": "",
                 "transparent": true,
                 "type": "yesoreyeram-boomtheme-panel"
               },
               {
                 "aliasColors": {
                   "Stromverbrauch": "semi-dark-green"
                 },
                 "bars": true,
                 "dashLength": 10,
                 "dashes": false,
                 "datasource": "${DS_INFLUXDB}",
                 "fill": 1,
                 "fillGradient": 0,
                 "gridPos": {
                   "h": 5,
                   "w": 21,
                   "x": 0,
                   "y": 3
                 },
                 "hiddenSeries": false,
                 "id": 2,
                 "interval": "10s",
                 "legend": {
                   "avg": true,
                   "current": false,
                   "max": true,
                   "min": false,
                   "show": true,
                   "total": false,
                   "values": true
                 },
                 "lines": false,
                 "linewidth": 1,
                 "links": [],
                 "nullPointMode": "null",
                 "options": {
                   "dataLinks": []
                 },
                 "percentage": false,
                 "pointradius": 2,
                 "points": false,
                 "renderer": "flot",
                 "seriesOverrides": [],
                 "spaceLength": 10,
                 "stack": true,
                 "steppedLine": false,
                 "targets": [
                   {
                     "alias": "Stromverbrauch",
                     "groupBy": [
                       {
                         "params": [
                           "24h"
                         ],
                         "type": "time"
                       },
                       {
                         "params": [
                           "null"
                         ],
                         "type": "fill"
                       }
                     ],
                     "measurement": "wiffi-wz.0.root.192_168_178_33.w_counter_1",
                     "orderByTime": "ASC",
                     "policy": "default",
                     "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"wiffi-wz.0.root.10_1_30_10.w_counter_1\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')",
                     "rawQuery": true,
                     "refId": "A",
                     "resultFormat": "time_series",
                     "select": [
                       [
                         {
                           "params": [
                             "value"
                           ],
                           "type": "field"
                         },
                         {
                           "params": [],
                           "type": "mean"
                         }
                       ]
                     ],
                     "tags": []
                   }
                 ],
                 "thresholds": [],
                 "timeFrom": null,
                 "timeRegions": [],
                 "timeShift": null,
                 "title": "Strom",
                 "tooltip": {
                   "shared": true,
                   "sort": 0,
                   "value_type": "cumulative"
                 },
                 "transparent": true,
                 "type": "graph",
                 "xaxis": {
                   "buckets": null,
                   "mode": "time",
                   "name": null,
                   "show": true,
                   "values": []
                 },
                 "yaxes": [
                   {
                     "format": "kwatth",
                     "label": null,
                     "logBase": 1,
                     "max": null,
                     "min": null,
                     "show": true
                   },
                   {
                     "format": "short",
                     "label": null,
                     "logBase": 1,
                     "max": null,
                     "min": null,
                     "show": true
                   }
                 ],
                 "yaxis": {
                   "align": false,
                   "alignLevel": null
                 }
               },
               {
                 "cacheTimeout": null,
                 "datasource": "${DS_INFLUXDB}",
                 "gridPos": {
                   "h": 5,
                   "w": 3,
                   "x": 21,
                   "y": 3
                 },
                 "id": 6,
                 "links": [],
                 "options": {
                   "fieldOptions": {
                     "calcs": [
                       "last"
                     ],
                     "defaults": {
                       "decimals": 2,
                       "mappings": [
                         {
                           "id": 0,
                           "op": "=",
                           "text": "N/A",
                           "type": 1,
                           "value": "null"
                         }
                       ],
                       "max": 150,
                       "min": 0,
                       "nullValueMode": "connected",
                       "thresholds": [
                         {
                           "color": "dark-green",
                           "value": null
                         },
                         {
                           "color": "dark-yellow",
                           "value": 80
                         },
                         {
                           "color": "dark-red",
                           "value": 120
                         }
                       ],
                       "unit": "currencyEUR"
                     },
                     "override": {},
                     "values": false
                   },
                   "orientation": "horizontal",
                   "showThresholdLabels": false,
                   "showThresholdMarkers": true
                 },
                 "pluginVersion": "6.5.2",
                 "targets": [
                   {
                     "alias": "",
                     "groupBy": [
                       {
                         "params": [
                           "$__interval"
                         ],
                         "type": "time"
                       },
                       {
                         "params": [
                           "null"
                         ],
                         "type": "fill"
                       }
                     ],
                     "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.cost.03_current_month",
                     "orderByTime": "ASC",
                     "policy": "default",
                     "refId": "A",
                     "resultFormat": "time_series",
                     "select": [
                       [
                         {
                           "params": [
                             "value"
                           ],
                           "type": "field"
                         },
                         {
                           "params": [],
                           "type": "distinct"
                         }
                       ]
                     ],
                     "tags": []
                   }
                 ],
                 "timeFrom": null,
                 "timeShift": null,
                 "title": "Monatskosten",
                 "transparent": true,
                 "type": "gauge"
               },
               {
                 "aliasColors": {
                   "Gasverbrauch": "semi-dark-red"
                 },
                 "bars": true,
                 "dashLength": 10,
                 "dashes": false,
                 "datasource": "${DS_INFLUXDB}",
                 "fill": 1,
                 "fillGradient": 0,
                 "gridPos": {
                   "h": 5,
                   "w": 21,
                   "x": 0,
                   "y": 8
                 },
                 "hiddenSeries": false,
                 "id": 3,
                 "interval": "10s",
                 "legend": {
                   "avg": true,
                   "current": false,
                   "max": true,
                   "min": false,
                   "show": true,
                   "total": false,
                   "values": true
                 },
                 "lines": false,
                 "linewidth": 1,
                 "links": [],
                 "nullPointMode": "null",
                 "options": {
                   "dataLinks": []
                 },
                 "percentage": false,
                 "pointradius": 2,
                 "points": false,
                 "renderer": "flot",
                 "seriesOverrides": [],
                 "spaceLength": 10,
                 "stack": true,
                 "steppedLine": false,
                 "targets": [
                   {
                     "alias": "Gasverbrauch",
                     "groupBy": [
                       {
                         "params": [
                           "24h"
                         ],
                         "type": "time"
                       },
                       {
                         "params": [
                           "null"
                         ],
                         "type": "fill"
                       }
                     ],
                     "measurement": "wiffi-wz.0.root.10_1_30_10.w_counter_2",
                     "orderByTime": "ASC",
                     "policy": "default",
                     "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"wiffi-wz.0.root.10_1_30_10.w_counter_2\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')",
                     "rawQuery": true,
                     "refId": "B",
                     "resultFormat": "time_series",
                     "select": [
                       [
                         {
                           "params": [
                             "value"
                           ],
                           "type": "field"
                         },
                         {
                           "params": [],
                           "type": "mean"
                         }
                       ]
                     ],
                     "tags": []
                   }
                 ],
                 "thresholds": [],
                 "timeFrom": null,
                 "timeRegions": [],
                 "timeShift": null,
                 "title": "Heizung",
                 "tooltip": {
                   "shared": true,
                   "sort": 0,
                   "value_type": "cumulative"
                 },
                 "transparent": true,
                 "type": "graph",
                 "xaxis": {
                   "buckets": null,
                   "mode": "time",
                   "name": null,
                   "show": true,
                   "values": []
                 },
                 "yaxes": [
                   {
                     "format": "m3",
                     "label": null,
                     "logBase": 1,
                     "max": null,
                     "min": null,
                     "show": true
                   },
                   {
                     "format": "short",
                     "label": null,
                     "logBase": 1,
                     "max": null,
                     "min": null,
                     "show": true
                   }
                 ],
                 "yaxis": {
                   "align": false,
                   "alignLevel": null
                 }
               },
               {
                 "cacheTimeout": null,
                 "datasource": "${DS_INFLUXDB}",
                 "gridPos": {
                   "h": 5,
                   "w": 3,
                   "x": 21,
                   "y": 8
                 },
                 "id": 7,
                 "links": [],
                 "options": {
                   "fieldOptions": {
                     "calcs": [
                       "last"
                     ],
                     "defaults": {
                       "decimals": 2,
                       "mappings": [
                         {
                           "id": 0,
                           "op": "=",
                           "text": "N/A",
                           "type": 1,
                           "value": "null"
                         }
                       ],
                       "max": 200,
                       "min": 0,
                       "nullValueMode": "connected",
                       "thresholds": [
                         {
                           "color": "dark-green",
                           "value": null
                         },
                         {
                           "color": "dark-yellow",
                           "value": 130
                         },
                         {
                           "color": "dark-red",
                           "value": 170
                         }
                       ],
                       "unit": "currencyEUR"
                     },
                     "override": {},
                     "values": false
                   },
                   "orientation": "horizontal",
                   "showThresholdLabels": false,
                   "showThresholdMarkers": true
                 },
                 "pluginVersion": "6.5.2",
                 "targets": [
                   {
                     "alias": "",
                     "groupBy": [
                       {
                         "params": [
                           "$__interval"
                         ],
                         "type": "time"
                       },
                       {
                         "params": [
                           "null"
                         ],
                         "type": "fill"
                       }
                     ],
                     "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_2.cost.03_current_month",
                     "orderByTime": "ASC",
                     "policy": "default",
                     "refId": "A",
                     "resultFormat": "time_series",
                     "select": [
                       [
                         {
                           "params": [
                             "value"
                           ],
                           "type": "field"
                         },
                         {
                           "params": [],
                           "type": "distinct"
                         }
                       ]
                     ],
                     "tags": []
                   }
                 ],
                 "timeFrom": null,
                 "timeShift": null,
                 "title": "Monatskosten",
                 "transparent": true,
                 "type": "gauge"
               },
               {
                 "aliasColors": {
                   "Wasserverbrauch": "semi-dark-blue"
                 },
                 "bars": true,
                 "dashLength": 10,
                 "dashes": false,
                 "datasource": "${DS_INFLUXDB}",
                 "fill": 1,
                 "fillGradient": 0,
                 "gridPos": {
                   "h": 5,
                   "w": 21,
                   "x": 0,
                   "y": 13
                 },
                 "hiddenSeries": false,
                 "hideTimeOverride": false,
                 "id": 4,
                 "interval": "10s",
                 "legend": {
                   "avg": true,
                   "current": false,
                   "hideEmpty": false,
                   "hideZero": false,
                   "max": true,
                   "min": false,
                   "show": true,
                   "total": false,
                   "values": true
                 },
                 "lines": false,
                 "linewidth": 1,
                 "links": [],
                 "nullPointMode": "null",
                 "options": {
                   "dataLinks": []
                 },
                 "percentage": false,
                 "pointradius": 2,
                 "points": false,
                 "renderer": "flot",
                 "seriesOverrides": [],
                 "spaceLength": 10,
                 "stack": true,
                 "steppedLine": false,
                 "targets": [
                   {
                     "alias": "Wasserverbrauch",
                     "groupBy": [
                       {
                         "params": [
                           "24h"
                         ],
                         "type": "time"
                       },
                       {
                         "params": [
                           "null"
                         ],
                         "type": "fill"
                       }
                     ],
                     "measurement": "wiffi-wz.0.root.10_1_30_10.w_counter_3",
                     "orderByTime": "ASC",
                     "policy": "default",
                     "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"wiffi-wz.0.root.10_1_30_10.w_counter_3\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')",
                     "rawQuery": true,
                     "refId": "A",
                     "resultFormat": "time_series",
                     "select": [
                       [
                         {
                           "params": [
                             "value"
                           ],
                           "type": "field"
                         },
                         {
                           "params": [],
                           "type": "mean"
                         }
                       ]
                     ],
                     "tags": []
                   }
                 ],
                 "thresholds": [],
                 "timeFrom": null,
                 "timeRegions": [],
                 "timeShift": null,
                 "title": "Wasser",
                 "tooltip": {
                   "shared": true,
                   "sort": 0,
                   "value_type": "cumulative"
                 },
                 "transparent": true,
                 "type": "graph",
                 "xaxis": {
                   "buckets": null,
                   "mode": "time",
                   "name": null,
                   "show": true,
                   "values": []
                 },
                 "yaxes": [
                   {
                     "format": "m3",
                     "label": null,
                     "logBase": 1,
                     "max": null,
                     "min": null,
                     "show": true
                   },
                   {
                     "format": "short",
                     "label": null,
                     "logBase": 1,
                     "max": null,
                     "min": null,
                     "show": true
                   }
                 ],
                 "yaxis": {
                   "align": false,
                   "alignLevel": null
                 }
               },
               {
                 "cacheTimeout": null,
                 "datasource": "${DS_INFLUXDB}",
                 "gridPos": {
                   "h": 5,
                   "w": 3,
                   "x": 21,
                   "y": 13
                 },
                 "id": 8,
                 "links": [],
                 "options": {
                   "fieldOptions": {
                     "calcs": [
                       "last"
                     ],
                     "defaults": {
                       "decimals": 2,
                       "mappings": [
                         {
                           "id": 0,
                           "op": "=",
                           "text": "N/A",
                           "type": 1,
                           "value": "null"
                         }
                       ],
                       "max": 7,
                       "min": 0,
                       "nullValueMode": "connected",
                       "thresholds": [
                         {
                           "color": "dark-green",
                           "value": null
                         },
                         {
                           "color": "dark-yellow",
                           "value": 4.5
                         },
                         {
                           "color": "dark-red",
                           "value": 6
                         }
                       ],
                       "unit": "currencyEUR"
                     },
                     "override": {},
                     "values": false
                   },
                   "orientation": "horizontal",
                   "showThresholdLabels": false,
                   "showThresholdMarkers": true
                 },
                 "pluginVersion": "6.5.2",
                 "targets": [
                   {
                     "alias": "",
                     "groupBy": [
                       {
                         "params": [
                           "$__interval"
                         ],
                         "type": "time"
                       },
                       {
                         "params": [
                           "null"
                         ],
                         "type": "fill"
                       }
                     ],
                     "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.cost.03_current_month",
                     "orderByTime": "ASC",
                     "policy": "default",
                     "refId": "A",
                     "resultFormat": "time_series",
                     "select": [
                       [
                         {
                           "params": [
                             "value"
                           ],
                           "type": "field"
                         },
                         {
                           "params": [],
                           "type": "distinct"
                         }
                       ]
                     ],
                     "tags": []
                   }
                 ],
                 "timeFrom": null,
                 "timeShift": null,
                 "title": "Monatskosten",
                 "transparent": true,
                 "type": "gauge"
               },
               {
                 "aliasColors": {
                   "Heizung": "#E02F44",
                   "Strom": "#56A64B",
                   "Wasser": "#3274D9"
                 },
                 "breakPoint": "50%",
                 "cacheTimeout": null,
                 "combine": {
                   "label": "Others",
                   "threshold": "0"
                 },
                 "datasource": "${DS_INFLUXDB}",
                 "fontSize": "100%",
                 "format": "currencyEUR",
                 "gridPos": {
                   "h": 8,
                   "w": 5,
                   "x": 0,
                   "y": 18
                 },
                 "id": 10,
                 "interval": null,
                 "legend": {
                   "percentage": true,
                   "show": true,
                   "values": true
                 },
                 "legendType": "On graph",
                 "links": [],
                 "maxDataPoints": 3,
                 "nullPointMode": "connected",
                 "options": {},
                 "pieType": "pie",
                 "pluginVersion": "6.5.2",
                 "strokeWidth": 1,
                 "targets": [
                   {
                     "alias": "Strom",
                     "groupBy": [
                       {
                         "params": [
                           "$__interval"
                         ],
                         "type": "time"
                       },
                       {
                         "params": [
                           "null"
                         ],
                         "type": "fill"
                       }
                     ],
                     "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.cost.03_current_month",
                     "orderByTime": "ASC",
                     "policy": "default",
                     "refId": "A",
                     "resultFormat": "time_series",
                     "select": [
                       [
                         {
                           "params": [
                             "value"
                           ],
                           "type": "field"
                         },
                         {
                           "params": [],
                           "type": "mean"
                         }
                       ]
                     ],
                     "tags": []
                   },
                   {
                     "alias": "Heizung",
                     "groupBy": [
                       {
                         "params": [
                           "$__interval"
                         ],
                         "type": "time"
                       },
                       {
                         "params": [
                           "null"
                         ],
                         "type": "fill"
                       }
                     ],
                     "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_2.cost.03_current_month",
                     "orderByTime": "ASC",
                     "policy": "default",
                     "refId": "B",
                     "resultFormat": "time_series",
                     "select": [
                       [
                         {
                           "params": [
                             "value"
                           ],
                           "type": "field"
                         },
                         {
                           "params": [],
                           "type": "mean"
                         }
                       ]
                     ],
                     "tags": []
                   },
                   {
                     "alias": "Wasser",
                     "groupBy": [
                       {
                         "params": [
                           "$__interval"
                         ],
                         "type": "time"
                       },
                       {
                         "params": [
                           "null"
                         ],
                         "type": "fill"
                       }
                     ],
                     "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.cost.03_current_month",
                     "orderByTime": "ASC",
                     "policy": "default",
                     "refId": "C",
                     "resultFormat": "time_series",
                     "select": [
                       [
                         {
                           "params": [
                             "value"
                           ],
                           "type": "field"
                         },
                         {
                           "params": [],
                           "type": "mean"
                         }
                       ]
                     ],
                     "tags": []
                   }
                 ],
                 "timeFrom": null,
                 "timeShift": null,
                 "title": "Pie Chart",
                 "transparent": true,
                 "type": "grafana-piechart-panel",
                 "valueName": "current"
               }
             ],
             "schemaVersion": 21,
             "style": "dark",
             "tags": [
               "Monatsverbrauch"
             ],
             "templating": {
               "list": []
             },
             "time": {
               "from": "now/M",
               "to": "now"
             },
             "timepicker": {
               "refresh_intervals": [
                 "5s",
                 "10s",
                 "30s",
                 "1m",
                 "5m",
                 "15m",
                 "30m",
                 "1h",
                 "2h",
                 "1d"
               ],
               "time_options": [
                 "5m",
                 "15m",
                 "1h",
                 "6h",
                 "12h",
                 "24h",
                 "2d",
                 "7d",
                 "30d"
               ]
             },
             "timezone": "",
             "title": "Monatsverbrauch",
             "uid": "_tteA1VZz",
             "version": 73
            }
            

            NegaleinN Offline
            NegaleinN Offline
            Negalein
            Global Moderator
            schrieb am zuletzt editiert von Negalein
            #24

            @crunchip sagte in Grafana Tagesverbrauch:

            mach mal ein neues dasboard füge die json ein...und natürlich deinen Datenpunkt anpassen

            kommt auch "no Data"
            Monatsverbrauch - Grafana.png
            Monatsverbrauch - Grafana (1).png

            ° Node.js: 20.17.0 NPM: 10.8.2
            ° Proxmox, Ubuntu 22.04.3 LTS
            ° Fixer ---> iob fix

            crunchipC 1 Antwort Letzte Antwort
            0
            • NegaleinN Negalein

              @crunchip sagte in Grafana Tagesverbrauch:

              mach mal ein neues dasboard füge die json ein...und natürlich deinen Datenpunkt anpassen

              kommt auch "no Data"
              Monatsverbrauch - Grafana.png
              Monatsverbrauch - Grafana (1).png

              crunchipC Abwesend
              crunchipC Abwesend
              crunchip
              Forum Testing Most Active
              schrieb am zuletzt editiert von
              #25

              @Negalein auch die richtige Datenbank ausgewählt? oder hast du nur eine

              umgestiegen von Proxmox auf Unraid

              NegaleinN 1 Antwort Letzte Antwort
              0
              • crunchipC crunchip

                @Negalein auch die richtige Datenbank ausgewählt? oder hast du nur eine

                NegaleinN Offline
                NegaleinN Offline
                Negalein
                Global Moderator
                schrieb am zuletzt editiert von
                #26

                @crunchip sagte in Grafana Tagesverbrauch:

                auch die richtige Datenbank ausgewählt? oder hast du nur eine

                Ja, hab nur eine

                ° Node.js: 20.17.0 NPM: 10.8.2
                ° Proxmox, Ubuntu 22.04.3 LTS
                ° Fixer ---> iob fix

                1 Antwort Letzte Antwort
                0
                • NegaleinN Offline
                  NegaleinN Offline
                  Negalein
                  Global Moderator
                  schrieb am zuletzt editiert von
                  #27

                  wähle ich "nur" den DP als Query aus, kommen Daten.

                  Verwende ich aber
                  SELECT non_negative_difference(last(cumulative_sum))FROM ( SELECT cumulative_sum(non_negative_difference(last("value"))) FROM "sourceanalytix.0.hs100__0__10_0_1_80__power.Meter_Readings.Current_Reading" WHERE $timeFilter GROUP BY time(1d) ) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')
                  kommt "no Data".

                  ° Node.js: 20.17.0 NPM: 10.8.2
                  ° Proxmox, Ubuntu 22.04.3 LTS
                  ° Fixer ---> iob fix

                  crunchipC 1 Antwort Letzte Antwort
                  0
                  • NegaleinN Negalein

                    wähle ich "nur" den DP als Query aus, kommen Daten.

                    Verwende ich aber
                    SELECT non_negative_difference(last(cumulative_sum))FROM ( SELECT cumulative_sum(non_negative_difference(last("value"))) FROM "sourceanalytix.0.hs100__0__10_0_1_80__power.Meter_Readings.Current_Reading" WHERE $timeFilter GROUP BY time(1d) ) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')
                    kommt "no Data".

                    crunchipC Abwesend
                    crunchipC Abwesend
                    crunchip
                    Forum Testing Most Active
                    schrieb am zuletzt editiert von crunchip
                    #28

                    @Negalein klick mal rechts auf Query Inspector >>Expand All
                    vllt kann man da etwas erkennen
                    45591baf-0646-4e80-9edf-aec81ab5acb5-image.png

                    umgestiegen von Proxmox auf Unraid

                    NegaleinN 1 Antwort Letzte Antwort
                    0
                    • crunchipC crunchip

                      @Negalein klick mal rechts auf Query Inspector >>Expand All
                      vllt kann man da etwas erkennen
                      45591baf-0646-4e80-9edf-aec81ab5acb5-image.png

                      NegaleinN Offline
                      NegaleinN Offline
                      Negalein
                      Global Moderator
                      schrieb am zuletzt editiert von
                      #29

                      @crunchip sagte in Grafana Tagesverbrauch:

                      klick mal rechts auf Query Inspector >>Expand All

                      Object
                      xhrStatus:"complete"
                      request:Object
                      method:"GET"
                      url:"api/datasources/proxy/1/query"
                      params:Object
                      db:"iobroker"
                      q:"SELECT non_negative_difference(last(cumulative_sum))FROM ( SELECT cumulative_sum(non_negative_difference(last("value"))) FROM "sourceanalytix.0.hs100__0__10_0_1_80__power.Meter_Readings.Current_Reading" WHERE time >= 1583017200000ms GROUP BY time(1d) ) WHERE time >= 1583017200000ms GROUP BY time(1d) tz('Europe/Berlin')"
                      epoch:"ms"
                      data:null
                      precision:"ms"
                      response:Object
                      results:Array[1]
                      0:Object
                      statement_id:0
                      

                      ° Node.js: 20.17.0 NPM: 10.8.2
                      ° Proxmox, Ubuntu 22.04.3 LTS
                      ° Fixer ---> iob fix

                      crunchipC 1 Antwort Letzte Antwort
                      0
                      • NegaleinN Negalein

                        @crunchip sagte in Grafana Tagesverbrauch:

                        klick mal rechts auf Query Inspector >>Expand All

                        Object
                        xhrStatus:"complete"
                        request:Object
                        method:"GET"
                        url:"api/datasources/proxy/1/query"
                        params:Object
                        db:"iobroker"
                        q:"SELECT non_negative_difference(last(cumulative_sum))FROM ( SELECT cumulative_sum(non_negative_difference(last("value"))) FROM "sourceanalytix.0.hs100__0__10_0_1_80__power.Meter_Readings.Current_Reading" WHERE time >= 1583017200000ms GROUP BY time(1d) ) WHERE time >= 1583017200000ms GROUP BY time(1d) tz('Europe/Berlin')"
                        epoch:"ms"
                        data:null
                        precision:"ms"
                        response:Object
                        results:Array[1]
                        0:Object
                        statement_id:0
                        
                        crunchipC Abwesend
                        crunchipC Abwesend
                        crunchip
                        Forum Testing Most Active
                        schrieb am zuletzt editiert von
                        #30

                        @Negalein mehr kommt da nicht?

                        umgestiegen von Proxmox auf Unraid

                        NegaleinN 2 Antworten Letzte Antwort
                        0
                        • crunchipC crunchip

                          @Negalein mehr kommt da nicht?

                          NegaleinN Offline
                          NegaleinN Offline
                          Negalein
                          Global Moderator
                          schrieb am zuletzt editiert von
                          #31

                          @crunchip sagte in Grafana Tagesverbrauch:

                          mehr kommt da nicht?

                          Nein, ist alles

                          ° Node.js: 20.17.0 NPM: 10.8.2
                          ° Proxmox, Ubuntu 22.04.3 LTS
                          ° Fixer ---> iob fix

                          crunchipC 1 Antwort Letzte Antwort
                          0
                          • crunchipC crunchip

                            @Negalein mehr kommt da nicht?

                            NegaleinN Offline
                            NegaleinN Offline
                            Negalein
                            Global Moderator
                            schrieb am zuletzt editiert von
                            #32

                            @crunchip sagte in Grafana Tagesverbrauch:

                            mehr kommt da nicht?

                            verwende ich nur den DP im Query kommt viel mehr.
                            new 11.txt

                            ° Node.js: 20.17.0 NPM: 10.8.2
                            ° Proxmox, Ubuntu 22.04.3 LTS
                            ° Fixer ---> iob fix

                            1 Antwort Letzte Antwort
                            0
                            • NegaleinN Negalein

                              @crunchip sagte in Grafana Tagesverbrauch:

                              mehr kommt da nicht?

                              Nein, ist alles

                              crunchipC Abwesend
                              crunchipC Abwesend
                              crunchip
                              Forum Testing Most Active
                              schrieb am zuletzt editiert von crunchip
                              #33

                              @Negalein ich würde mal sagen du musst noch nen Tag warten :woman-facepalming:
                              was soll denn auch berechnet werden, wenn erst ein 1 Wert vorhanden ist...wenn ma es logisch betrachtet

                              dieser Part kann ja erst am folgeTag errechnet werden GROUP BY time(1d)

                              SELECT non_negative_difference(last(cumulative_sum))FROM (
                              SELECT cumulative_sum(non_negative_difference(last("value")))
                              

                              umgestiegen von Proxmox auf Unraid

                              NegaleinN 1 Antwort Letzte Antwort
                              0
                              • crunchipC crunchip

                                @Negalein ich würde mal sagen du musst noch nen Tag warten :woman-facepalming:
                                was soll denn auch berechnet werden, wenn erst ein 1 Wert vorhanden ist...wenn ma es logisch betrachtet

                                dieser Part kann ja erst am folgeTag errechnet werden GROUP BY time(1d)

                                SELECT non_negative_difference(last(cumulative_sum))FROM (
                                SELECT cumulative_sum(non_negative_difference(last("value")))
                                
                                NegaleinN Offline
                                NegaleinN Offline
                                Negalein
                                Global Moderator
                                schrieb am zuletzt editiert von
                                #34

                                @crunchip sagte in Grafana Tagesverbrauch:

                                ich würde mal sagen du musst noch nen Tag warten
                                was soll denn auch berechnet werden, wenn erst ein 1 Wert vorhanden ist...wenn ma es logisch betrachtet
                                dieser Part kann ja erst am folgeTag errechnet werden

                                Ah, ok. Also warte ich mal bis morgen.
                                Dachte, da ich es schon vor Mitternacht aktiviert habe, funktioniert es schon nach Mitternacht .

                                ° Node.js: 20.17.0 NPM: 10.8.2
                                ° Proxmox, Ubuntu 22.04.3 LTS
                                ° Fixer ---> iob fix

                                crunchipC 1 Antwort Letzte Antwort
                                0
                                • NegaleinN Negalein

                                  @crunchip sagte in Grafana Tagesverbrauch:

                                  ich würde mal sagen du musst noch nen Tag warten
                                  was soll denn auch berechnet werden, wenn erst ein 1 Wert vorhanden ist...wenn ma es logisch betrachtet
                                  dieser Part kann ja erst am folgeTag errechnet werden

                                  Ah, ok. Also warte ich mal bis morgen.
                                  Dachte, da ich es schon vor Mitternacht aktiviert habe, funktioniert es schon nach Mitternacht .

                                  crunchipC Abwesend
                                  crunchipC Abwesend
                                  crunchip
                                  Forum Testing Most Active
                                  schrieb am zuletzt editiert von
                                  #35

                                  @Negalein na da hatte ich jetzt auch nicht dran gedacht...warte mal noch nen Tag ab, dann sollte da auch was erscheinen

                                  umgestiegen von Proxmox auf Unraid

                                  NegaleinN 1 Antwort Letzte Antwort
                                  0
                                  • crunchipC crunchip

                                    @Negalein na da hatte ich jetzt auch nicht dran gedacht...warte mal noch nen Tag ab, dann sollte da auch was erscheinen

                                    NegaleinN Offline
                                    NegaleinN Offline
                                    Negalein
                                    Global Moderator
                                    schrieb am zuletzt editiert von
                                    #36

                                    @crunchip sagte in Grafana Tagesverbrauch:

                                    na da hatte ich jetzt auch nicht dran gedacht

                                    kein Problem

                                    warte mal noch nen Tag ab, dann sollte da auch was erscheinen

                                    Ich melde mich wieder :)

                                    ° Node.js: 20.17.0 NPM: 10.8.2
                                    ° Proxmox, Ubuntu 22.04.3 LTS
                                    ° Fixer ---> iob fix

                                    1 Antwort Letzte Antwort
                                    1
                                    • NegaleinN Offline
                                      NegaleinN Offline
                                      Negalein
                                      Global Moderator
                                      schrieb am zuletzt editiert von
                                      #37

                                      @crunchip

                                      neuer Tag, leider kein neues Glück.

                                      Steht noch immer "no Data".

                                      Ich versuch es jetzt mal mit diesen DP aus Source (für jeden Tag ein Query).
                                      Mal schaun, ob die Balken dann nebeneinander liegen.

                                      objects - ioBroker (11).png

                                      ° Node.js: 20.17.0 NPM: 10.8.2
                                      ° Proxmox, Ubuntu 22.04.3 LTS
                                      ° Fixer ---> iob fix

                                      crunchipC 1 Antwort Letzte Antwort
                                      0
                                      • NegaleinN Negalein

                                        @crunchip

                                        neuer Tag, leider kein neues Glück.

                                        Steht noch immer "no Data".

                                        Ich versuch es jetzt mal mit diesen DP aus Source (für jeden Tag ein Query).
                                        Mal schaun, ob die Balken dann nebeneinander liegen.

                                        objects - ioBroker (11).png

                                        crunchipC Abwesend
                                        crunchipC Abwesend
                                        crunchip
                                        Forum Testing Most Active
                                        schrieb am zuletzt editiert von
                                        #38

                                        @Negalein seltsam, sollte normalerweise funktionieren

                                        ja wenn du die einzelnen, pro Tag loggst, geht es auf jeden Fall....aber sollte ja auch anders funktionieren

                                        umgestiegen von Proxmox auf Unraid

                                        NegaleinN 1 Antwort Letzte Antwort
                                        0
                                        • crunchipC crunchip

                                          @Negalein seltsam, sollte normalerweise funktionieren

                                          ja wenn du die einzelnen, pro Tag loggst, geht es auf jeden Fall....aber sollte ja auch anders funktionieren

                                          NegaleinN Offline
                                          NegaleinN Offline
                                          Negalein
                                          Global Moderator
                                          schrieb am zuletzt editiert von
                                          #39

                                          @crunchip sagte in Grafana Tagesverbrauch:

                                          seltsam, sollte normalerweise funktionieren
                                          ja wenn du die einzelnen, pro Tag loggst, geht es auf jeden Fall....aber sollte ja auch anders funktionieren

                                          Ja, ist komisch.

                                          Die Beispiele, die ich im Netz gefunden habe, zielten auch alle auf deinen Weg hin.

                                          So schauts jetzt mal aus.

                                          New dashboard - Grafana (2).png
                                          New dashboard - Grafana (3).png

                                          ° Node.js: 20.17.0 NPM: 10.8.2
                                          ° Proxmox, Ubuntu 22.04.3 LTS
                                          ° Fixer ---> iob fix

                                          crunchipC 1 Antwort Letzte Antwort
                                          0
                                          Antworten
                                          • In einem neuen Thema antworten
                                          Anmelden zum Antworten
                                          • Älteste zuerst
                                          • Neuste zuerst
                                          • Meiste Stimmen


                                          Support us

                                          ioBroker
                                          Community Adapters
                                          Donate

                                          789

                                          Online

                                          32.4k

                                          Benutzer

                                          81.6k

                                          Themen

                                          1.3m

                                          Beiträge
                                          Community
                                          Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen | Einwilligungseinstellungen
                                          ioBroker Community 2014-2025
                                          logo
                                          • Anmelden

                                          • Du hast noch kein Konto? Registrieren

                                          • Anmelden oder registrieren, um zu suchen
                                          • Erster Beitrag
                                            Letzter Beitrag
                                          0
                                          • Home
                                          • Aktuell
                                          • Tags
                                          • Ungelesen 0
                                          • Kategorien
                                          • Unreplied
                                          • Beliebt
                                          • GitHub
                                          • Docu
                                          • Hilfe