Skip to content
  • Home
  • Recent
  • Tags
  • 0 Unread 0
  • Categories
  • Unreplied
  • Popular
  • 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

  • Default (No Skin)
  • No Skin
Collapse
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

Scheduled Pinned Locked Moved Visualisierung
how-to
55 Posts 8 Posters 19.2k Views 10 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • 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 Away
    crunchipC Away
    crunchip
    Forum Testing Most Active
    wrote on last edited by 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 Reply Last reply
    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
      wrote on last edited by
      #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 Reply Last reply
      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 Away
        crunchipC Away
        crunchip
        Forum Testing Most Active
        wrote on last edited by
        #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 Reply Last reply
        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
          wrote on last edited by 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 Reply Last reply
          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 Away
            crunchipC Away
            crunchip
            Forum Testing Most Active
            wrote on last edited by
            #25

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

            umgestiegen von Proxmox auf Unraid

            NegaleinN 1 Reply Last reply
            0
            • crunchipC crunchip

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

              NegaleinN Offline
              NegaleinN Offline
              Negalein
              Global Moderator
              wrote on last edited by
              #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 Reply Last reply
              0
              • NegaleinN Offline
                NegaleinN Offline
                Negalein
                Global Moderator
                wrote on last edited by
                #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 Reply Last reply
                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 Away
                  crunchipC Away
                  crunchip
                  Forum Testing Most Active
                  wrote on last edited by 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 Reply Last reply
                  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
                    wrote on last edited by
                    #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 Reply Last reply
                    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 Away
                      crunchipC Away
                      crunchip
                      Forum Testing Most Active
                      wrote on last edited by
                      #30

                      @Negalein mehr kommt da nicht?

                      umgestiegen von Proxmox auf Unraid

                      NegaleinN 2 Replies Last reply
                      0
                      • crunchipC crunchip

                        @Negalein mehr kommt da nicht?

                        NegaleinN Offline
                        NegaleinN Offline
                        Negalein
                        Global Moderator
                        wrote on last edited by
                        #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 Reply Last reply
                        0
                        • crunchipC crunchip

                          @Negalein mehr kommt da nicht?

                          NegaleinN Offline
                          NegaleinN Offline
                          Negalein
                          Global Moderator
                          wrote on last edited by
                          #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 Reply Last reply
                          0
                          • NegaleinN Negalein

                            @crunchip sagte in Grafana Tagesverbrauch:

                            mehr kommt da nicht?

                            Nein, ist alles

                            crunchipC Away
                            crunchipC Away
                            crunchip
                            Forum Testing Most Active
                            wrote on last edited by 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 Reply Last reply
                            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
                              wrote on last edited by
                              #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 Reply Last reply
                              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 Away
                                crunchipC Away
                                crunchip
                                Forum Testing Most Active
                                wrote on last edited by
                                #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 Reply Last reply
                                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
                                  wrote on last edited by
                                  #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 Reply Last reply
                                  1
                                  • NegaleinN Offline
                                    NegaleinN Offline
                                    Negalein
                                    Global Moderator
                                    wrote on last edited by
                                    #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 Reply Last reply
                                    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 Away
                                      crunchipC Away
                                      crunchip
                                      Forum Testing Most Active
                                      wrote on last edited by
                                      #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 Reply Last reply
                                      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
                                        wrote on last edited by
                                        #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 Reply Last reply
                                        0
                                        • NegaleinN Negalein

                                          @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

                                          crunchipC Away
                                          crunchipC Away
                                          crunchip
                                          Forum Testing Most Active
                                          wrote on last edited by
                                          #40

                                          @Negalein ist doch schon mal was
                                          hast du es nochmal mit dem json vom ganzen dashboard getestet, das ich gestern reingestellt hatte

                                          umgestiegen von Proxmox auf Unraid

                                          NegaleinN 2 Replies Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          Support us

                                          ioBroker
                                          Community Adapters
                                          Donate

                                          588

                                          Online

                                          32.5k

                                          Users

                                          81.6k

                                          Topics

                                          1.3m

                                          Posts
                                          Community
                                          Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen | Einwilligungseinstellungen
                                          ioBroker Community 2014-2025
                                          logo
                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Home
                                          • Recent
                                          • Tags
                                          • Unread 0
                                          • Categories
                                          • Unreplied
                                          • Popular
                                          • GitHub
                                          • Docu
                                          • Hilfe