Total of each bar in a stacked graph?

[droidgren]

Is possible, somehow, to show a label of the total of each bar in a stacked graph?

I am using this code

title: Cost per day
entities:
  - entity: sensor.dagens_varmekostnad
    name: Värme
    unit_of_measurement: SEK
    texttemplate: ' %{y:.0f}'
    type: bar
    statistic: sum
    period: day
    filters:
      - delta
      - filter: i>0
    marker:
      color: '#FF9800'
  - entity: sensor.dagens_laddkostnad
    name: Laddkostnad
    unit_of_measurement: SEK
    texttemplate: ' %{y:.0f}'
    type: bar
    statistic: sum
    period: day
    filters:
      - delta
      - filter: i>0
    marker:
      color: '#3498DB'
  - entity: sensor.dagens_kostnad_ovrigt
    name: Övrigt
    unit_of_measurement: SEK
    texttemplate: ' %{y:.0f}'
    type: bar
    statistic: sum
    period: day
    filters:
      - delta
      - filter: i>0
    marker:
      color: '#E74C3C'
hours_to_show: 9d
refresh_interval: 10
autorange_after_scroll: true
ticklabeloverflow: allow
layout:
  barmode: stack
  xaxis:
    tickformat: '%a'
    tickangle: -45
    hoverformat: '%B %Y'
    autorange: true
    dticks: 86400000
    nticks: 9
  yaxis:
    autorange: true
    griddash: dot
    overlaying: false
    visible: true
    showgrid: true
defaults:
  yaxes:
    fixedrange: true

[dbuezas]

You could add another trace, set it to transparent, hide it from the legend, add all values together using $ex and use the text attribute to make it show the totals

[droidgren]

Do you mean another entity? Do you have an example how to sum using $ex? I have never done that. Thanks!

[dbuezas]

Yes, another entity.

something like:

type: custom:plotly-graph
entities:
  - entity: sensor.energy_backofen
    type: bar
    filters:
      - resample
      - force_numeric
      - store_var: a
      
  - entity: sensor.energy_beamer
    type: bar
    filters:
      - resample
      - force_numeric
      - store_var: b
      
  - entity: ""
    type: bar
    name: sum
    unit_of_measurement: kWh
    text: $ex vars.a.ys.map((y,i) =>(y+vars.b.ys[i]).toFixed(2))
    showlegend: false
    marker:
      color: transparent
    filters:
      - load_var: a
      - map_y: 1
      
layout:
  barmode: stack

[droidgren]

Thanks works pretty well, except that autorange doesn't take the extra entity account. Is that possible to solve?
I tried specify fixed range options but does not seem to work.

type: custom:plotly-graph
title: Cost per day
entities:
  - entity: sensor.dagens_varmekostnad
    name: Värme
    unit_of_measurement: SEK
    texttemplate: ' %{y:.0f}'
    type: bar
    statistic: sum
    period: day
    filters:
      - delta
      - filter: i>0
      - force_numeric
      - store_var: a
    marker:
      color: '#FF9800'
  - entity: sensor.dagens_laddkostnad
    name: Laddkostnad
    unit_of_measurement: SEK
    texttemplate: ' %{y:.0f}'
    type: bar
    statistic: sum
    period: day
    filters:
      - delta
      - filter: i>0
      - force_numeric
      - store_var: b
    marker:
      color: '#3498DB'
  - entity: sensor.dagens_kostnad_ovrigt
    name: Övrigt
    unit_of_measurement: SEK
    texttemplate: ' %{y:.0f}'
    type: bar
    statistic: sum
    period: day
    filters:
      - delta
      - filter: i>0
      - force_numeric
      - store_var: c
    marker:
      color: '#E74C3C'
  - entity: ''
    type: bar
    name: sum
    unit_of_measurement: SEK
    text: $ex vars.a.ys.map((y,i) =>(y+vars.b.ys[i]+vars.c.ys[i]).toFixed(0))
    showlegend: false
    marker:
      color: transparent
    filters:
      - load_var: a
      - map_y: 1
hours_to_show: 9d
refresh_interval: 10
autorange_after_scroll: true
ticklabeloverflow: allow
layout:
  barmode: stack
  xaxis:
    tickformat: '%a'
    tickangle: -45
    hoverformat: '%B %Y'
    autorange: true
    dticks: 86400000
    nticks: 9
  yaxis:
    fixedrange: true
    range:
      - 10
      - 90
    griddash: dot
    overlaying: false
    visible: true
    showgrid: true

[dbuezas]

Just make map_y: 1 bigger

[droidgren]

Thanks! Would never have guessed that. :)