Energy / Power in Grafana & influxdb

Configuration
1

Hi all,

I have a question regarding the presentation of energy sensors in Grafana. In below screenshot I display the solar production for one week, and the solar production in one month.
Remarkably, the sensor for week (look at yesterday) mentions the right production, but when I look at the day state in solar this month, it mentions only 1.5 KWH on the 01/30 iest of this month.

image
image458Ă—529 22.6 KB

The config for the weekly is as follows:

image
image747Ă—276 18.9 KB

The config of the monthly is as follows:

image

Has onyone got a clue ?

Thanks in advance !

Kr,

Bart

2

Just averaging Power to guesstimate Energy is bound to give strange results…

1 Like
3

Yeah what you want is:

Screenshot 2022-01-31 at 20-50-48 Grafana – Home Assistant

Integrating power with respect to time gives energy.

4

Thanks alot Tom,

But when I enter the integral, I got wishfull thinking values :slight_smile:

I make more than 1 MW :slight_smile:

image
image1363Ă—314 18.1 KB

Has it to do with grouping on 1 day ?

image
image1353Ă—312 20.8 KB

The view is set on Last 30 days

5

TBH I have never used the integral aggregation.

As you want kWh try grouping by 1h.

Also if you are grouping by day you should enter the timezone information or you will cross midnight boundaries with your data.

6

Yeah,

I want to be able to show per day, like in above chart, the total consumption for 1 day plotted on a month

7

Just found an example:

Click the pencil icon:

c02bcbd174ac16e5d3734ca2e408afe15698abc2_2_690x159

8

Seems to work, but still, I’m getting results in MW. I used the integral subquery and results are like this:

image
image897Ă—308 14.9 KB

Where code is:

SELECT SUM("integral") AS sum
From (
    SELECT INTEGRAL("mean", 5m) AS integral
   FROM (
      SELECT mean("value") FROM "W" WHERE ("entity_id" = 'solaredge_current_power') AND $timeFilter GROUP BY time(5m) fill(null)
    )
)
GROUP BY time(1d)

The values of the current power solaredge are stored in Watt

1 Like
9

You can select the axis unit under Standard Options:

Untitled

10

Hi Tom,

The units are already filed as Kwh, now their displayed as 200 MWh …

Seems like I need to divide by something, but not sure what

11

That was just an example from my Grafana energy graphs to show you where the setting was.

Try setting it to Wh. Because:

12

It remains in MWH because of the high figures. One single bar represents between 120 & 150 MWh, which is not the case (of course)

13

If you have energy sensors this is a lot easier to do with utility meters in Home Assistant. You can then import the sensors into Infludb/grafana and select “max” for the cycle (day/week).

If you don;t have energy sensors you can create them: