Power consumption in thousand kilowatthours

Grafana Bar Chart Panel
1

Hello,

Any tips on how to express a home’s electricity consumption in the common unit of thousands of kilowatt-hours?

Thank you and best regards,
Chris

2

Hello

Might this help?

image

3

No, it does not help:

grafik
grafik1894×286 22.9 KB

I think I have the correct unit “Wh” selected, but Grafana changes the unit by itself from Wh to MWh:

grafik
grafik1890×291 23.7 KB

I don’t like “2.489 MWh”, I would like to see “2489 kWh” (the same unit as usual on my power meter and my power bill)

1 Like
4

Please share your datasource?

5

My data source is a JSON adapter

grafik
grafik1488×806 39.3 KB

I guess this is the JSON?!:

{
  "request": {
    "url": "api/datasources/proxy/1/query",
    "data": {
      "app": "dashboard",
      "requestId": "Q112",
      "timezone": "browser",
      "panelId": 11,
      "dashboardId": 15,
      "dashboardUID": "Jbjv0ekgk",
      "publicDashboardAccessToken": "",
      "range": {
        "from": "2020-07-24T22:00:00.000Z",
        "to": "2022-12-20T10:01:00.288Z",
        "raw": {
          "from": "2020-07-24T22:00:00.000Z",
          "to": "now"
        }
      },
      "timeInfo": "",
      "interval": "12h",
      "intervalMs": 43200000,
      "targets": [
        {
          "datasource": {
            "type": "simpod-json-datasource",
            "uid": "q4xFP1zRk"
          },
          "payload": {
            "options": "consumption",
            "group": "year"
          },
          "refId": "Strom Haus",
          "target": "89c0c960-8e59-11e6-81d7-efe19b94c4aa"
        },
        {
          "datasource": {
            "type": "simpod-json-datasource",
            "uid": "q4xFP1zRk"
          },
          "hide": false,
          "payload": {
            "options": "consumption",
            "group": "year"
          },
          "refId": "Strom Wärmepumpe HT",
          "target": "b672f2c0-8e59-11e6-be34-2f0c157b74af"
        },
        {
          "datasource": {
            "type": "simpod-json-datasource",
            "uid": "q4xFP1zRk"
          },
          "hide": false,
          "payload": {
            "options": "consumption",
            "group": "year"
          },
          "refId": "Strom Wärmepumpe NT",
          "target": "0f619f10-97e7-11e6-88bd-e79ee73590e6"
        }
      ],
      "maxDataPoints": 1488,
      "scopedVars": {
        "__interval": {
          "text": "12h",
          "value": "12h"
        },
        "__interval_ms": {
          "text": "43200000",
          "value": 43200000
        }
      },
      "startTime": 1671530460288,
      "rangeRaw": {
        "from": "2020-07-24T22:00:00.000Z",
        "to": "now"
      },
      "adhocFilters": [],
      "endTime": 1671530465455
    },
    "method": "POST",
    "withCredentials": false,
    "hideFromInspector": false
  },
  "response": [
    {
      "target": "Strom Haus",
      "datapoints": [
        [
          3219300,
          1640991363000
        ],
        [
          2938300,
          1671530125000
        ]
      ]
    },
    {
      "target": "Strom Wärmepumpe Haupttarif",
      "datapoints": [
        [
          2675800,
          1640990513000
        ],
        [
          2309400,
          1671529862000
        ]
      ]
    },
    {
      "target": "Strom Wärmepumpe Nebentarif",
      "datapoints": [
        [
          2758200,
          1640989413000
        ],
        [
          2493500,
          1671530074000
        ]
      ]
    }
  ]
}
6

I think that is the actual jaon dashboard.

We need an actual sample json data you are trying to visualize

The electric usage data

7

Any hint were I can find/access them? Can they be found within Grafana somewhere?

8

I tried this but I got no answer?!

grafik
grafik1281×605 28.6 KB

9

how is the data stored in in the database? looks like it is mWh. if this is the case please try to set the unit to mWh, then you should get the correct result.