show daily energy consumption as a bar graph

[Jn115759]

I am new using this fantastic plotly integration and was hoping someone could help me with the issue above.
I defined a utility meter helper "sensor.helper_elektriciteit_aanvoer_net" which resets daily. Values are shown in the graph below in blue.

Now I would like to see the daily consumption as a bar graph.
According to the documentation this should be fairly simple.

I used the code below.

type: custom:plotly-graph
entities:
  - entity: sensor.helper_elektriciteit_aanvoer_net
    statistic: max
    period: day
hours_to_show: 144
refresh_interval: 30
title: Energy

Unfortunately this only results in a flat line.

Would appreciate some hints to learn what I am doing wrong.
Many thanks.

[dbuezas]

From here, you probably need to use 'state' instead of max, but we didn't implement that.
Can you try with 'sum' ? If that should something, then I'll add 'state' later today.

[Jn115759]

Many thanks for your superswift reply and for helping out on this !
I added "sum" and I think this is working :-). The graph now shows the cummulative result of course.

type: custom:plotly-graph
entities:
  - entity: sensor.helper_elektriciteit_aanvoer_net
    statistic: sum
    period: day
hours_to_show: 144
refresh_interval: 30
title: Energy

[dbuezas]

Fixed in v1.4.8! see #93

type: custom:plotly-graph-dev
entities:
  - entity: sensor.electricity_total
    statistic: state

[dbuezas]

BTW, you can do bar charts too, see #28

[Jn115759]

Many thanks for helping me out. All is working fine!
Below the final result.

Just 1 specific issue I can't explain : the current day is shown with 2 bars. Any idea ? Would help me to better understand how all is working.

type: custom:plotly-graph
entities:
  - entity: sensor.helper_elektriciteit_aanvoer_net
    statistic: state
    period: day
    type: bar
hours_to_show: 288
refresh_interval: 30
title: Energy

[dbuezas]

I introduced a bug in v1.5.0, I'll make a new release today and ask you to confirm if this issue remains

[Jn115759]

Hi there, I just updated to version 1.5.3 and to be certain also restarted HA, but the double value still is present.

[dbuezas]

@Jn115759 stick around, the next version should fix this :)

[trianglesis]

I can't get why the bar chart shows a lower value on Nov 8

Tried different filters, and none can show a real number.

Can only show "bar" with true values like this:

[kppr0]

I guess you need to include period: day and filters: - delta:

[dbuezas]

You could try the integration filter

[trianglesis]

You could try the integration filter

It's already that way with template sensors:

inverter battery power usage sensor -> integration sensor -> utility meter

So I only wanted to show peaks of battery consumption over time, to know when the last time it was discharged more than usual and how often.

[dbuezas]

For peaks you could use the max statistic

[trianglesis]

For peaks you could use the max statistic

It works pretty weirdly, not showing half of the records.

Max | Min | State

Code:

Code is the same, only statistics method changes

title: sensor.invertor_discharging_kwh_2
type: custom:plotly-graph
entities:
  - entity: sensor.invertor_discharging_kwh_2
    statistic: max
    period: day
    type: bar
    texttemplate: "%{y:0.1f}"
    filters:
      - filter: i>=1
hours_to_show: 14d
refresh_interval: 60
grid_options:
  columns: full
layout:
  dragmode: pan
  height: 350
  margin:
    b: 90
  legend:
    itemwidth: 50
  xaxis:
    rangeselector:
      "y": "-.3"
      buttons:
        - count: 1
          step: day
        - count: 2
          step: day
        - count: 7
          step: day
        - count: 14
          step: day
        - count: 30
          step: day
        - count: 90
          step: day
config:
  scrollZoom: true
  doubleClickDelay: 600

Oh, there is also a DT problem, for cases when the battery is discharging during the night, 23:59 till the next day 00:01.
So the history data is now split between days, so I must not rely on the date in such statistics but rather on the period when the utility meter was calibrated to 0 zero value (when the battery is fully charged).

It's not the ultimate issue, but could I build the graph like that?

For example:
0-0-0-0-0-1-2-3-4-5-0-0-0-0-0-1-2-3-4-0-0-0-0

• 0 zeros is a period when the main grid is present and the battery is charged 100% so the utility meter resets to zero and stays zero till the next blackout
• 1-2-3-4-5 are new history points when the battery was in use, and how many watts it gives back into the system

Ideally, bars should indicate maximum battery discharge for n periods of blackouts (not counting days, but blackouts between zero values)

[dbuezas]

I'd suggest setting the period to day.
Otherwise you could make a custom filter:

entity: sensor.xxx
filters:
  - map_y: 'y > ys[i+1] || i === ys.length ? y : null'
  - force_numeric