Grafana Tagesverbrauch

Negalein

@crunchip sagte in Grafana Tagesverbrauch:

trag es mal so ein

leider kein Unterschied.
Immer noch "no Data"

@Malaus sagte in Grafana Tagesverbrauch:

bei mir sieht das so aus:

So würde ich es auch gerne haben.
Mit Sourceanalytics komm ich nicht klar. Da schreibt er mir einen Minuswert.

Malaus

@Negalein hast du es mal unabhängig von Sourceanalytics so eingestellt?

crunchip

@Negalein ich nehme den Wert aus meinem Pulscounter, also den Gesamtzählerwert, den Rest macht ja Grafana.
du hast ja

Ich hab 2 DP zur Verfügung:
hs100.0.10_0_1_80.power = der aktuelle Verbrauch
hs100.0.10_0_1_80.totalNow = der Tagesverbrauch

Negalein

@Malaus sagte in Grafana Tagesverbrauch:

hast du es mal unabhängig von Sourceanalytics so eingestellt?

Du hast für jeden Tag der Woche einen eigenen Query?
Das geht dann nur mit Sourceanalytics.

In Source hab ich den DP so eingestellt.
objects - ioBroker (2).png

Meter reading at day start hab ich den Wert vom DP übernommen, zu dem Zeitpunkt als ich Source aktiviert habe.

DP in den Objekten bei Source schaut so aus.
Zu sehen der Minus-Wert.
objects - ioBroker (3).png

Negalein

@crunchip sagte in Grafana Tagesverbrauch:

ich nehme den Wert aus meinem Pulscounter, also den Gesamtzählerwert, den Rest macht ja Grafana.

Monatsverbrauch hätt ich noch als DP dieser Dose.
Wird aber auch nicht viel bringen?

crunchip

@Negalein trag deinen Wert überall ein, kommende Woche passt sich dann der Wert Woche automatisch an, zum Monatsanfang passt sich dann der Wert Monat automatisch an usw...
das "Umwandeln "Watt" in "kWh" ...gab´s Probleme soviel ich weiss, keine Ahnung ob das schon 100% funktioniert

Negalein

@crunchip sagte in Grafana Tagesverbrauch:

trag deinen Wert überall ein, kommende Woche passt sich dann der Wert Woche automatisch an, zum Monatsanfang passt sich dann der Wert Monat automatisch an usw...

Ok, danke.
Hab einen Fehler gesehen. Muss ja nicht 1224 sondern 1.224 eintragen.

Und der Tageswert kommt jetzt von Tag zu Tag dazu.

Negalein

@crunchip sagte in Grafana Tagesverbrauch:

trag deinen Wert überall ein

Gerade noch gesehen, dass ich bei zB Meter reading at week start den Wert ja nicht weiß.

crunchip

@Negalein
sourceanalytix.0.xyz.Meter_Readings.current_year.this_week siehst du deinen fortlaufenden Verbrauch
sourceanalytix.0.xyz.consumption.current_year.this_week deinen täglichen Verbrauch

crunchip

@Negalein musst du ja nicht, du startest mit dem jetzigen Wert, ab Montag startet die Berechnung für die neue Woche automatisch

crunchip

@Negalein du müsstest dann sourceanalytix.0.xyz.Meter_Readings.Current_Reading für deinen Grafana Datenpunkt nehmen

Negalein

@crunchip sagte in Grafana Tagesverbrauch:

musst du ja nicht, du startest mit dem jetzigen Wert, ab Montag startet die Berechnung für die neue Woche automatisch

Ok, ich dachte du meinst ich muss den Wert überall eintragen.

@crunchip sagte in Grafana Tagesverbrauch:

du müsstest dann sourceanalytix.0.xyz.Meter_Readings.Current_Reading für deinen Grafana Datenpunkt nehmen

Und so die Formel dann verwenden?
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')

Dann bekomm ich für jeden Tag einen eigenen Balken?

crunchip

@Negalein sagte in Grafana Tagesverbrauch:

Dann bekomm ich für jeden Tag einen eigenen Balken

ja
hier ein Beispiel,
jeden Tag kommt ein Balken dazu...am Monatsanfang beginnt es wieder mit einem Balken

Negalein

@crunchip sagte in Grafana Tagesverbrauch:

ja

Danke

Dann warte ich mal auf Morgen :)

crunchip

@Negalein einzelne Geräte oder auch über sourceanalytix kannst du dann so einstellen
Beispiel

Negalein

@crunchip sagte in Grafana Tagesverbrauch:

einzelne Geräte oder auch über sourceanalytix kannst du dann so einstellen

so schaut derzeit mein Dashboard aus

Allgemein - Grafana (5).png

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

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)

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

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
}

Community Forum

NEWS

Grafana Tagesverbrauch

Support us

909

32.4k

81.5k

1.3m