[FR] ref_entity update 2

[Ole1509]

Please describe the idea

Dear cataseven,

I have another feature request regarding ref_entity and aggregation.

I have two separate solar production sensors, one for my GoodWe inverter and one for my SolarEdge inverter. I would like to combine their daily production values and then have the card calculate the sum of those combined daily values for each month when using the year view.

In other words:

Daily production = GoodWe production + SolarEdge production

And in the year view:

January = sum of all daily GoodWe + SolarEdge production values in January
February = sum of all daily values in February
etc.

I would like the result to be displayed as monthly bars in the year view, so I can see the total solar production per month from both inverters combined.

Thanks in advance!

My graph and code:

(yes, my solaredge inverter wasn't producing for the last few month but will be back running in the next month)

type: custom:statistics-graph-chart-card
card_header: Opwek jaar
card_background_color: " rgba(36, 37, 41, 0.3)"
card_border: false
brush_zoom: false
stacked: true
tooltip_match_axis: false
tooltip_order: default
height: 200
graph_start_hour: 0
show_full_period: true
lower_bound: "0"
y_axis_font_size: 11
y_axis_font_opacity: 1
x_axis_font_opacity: 1
x_grid_style: dashed
y_grid_style: dashed
show_date_picker: true
date_picker_default_mode: year
date_picker_modes:
  - year
align_header: center
state_layout: horizontal
group_by: month
entities:
  - entity: sensor.goodwe_today_s_pv_generation
    statistic_id: null
    name: Totaal
    color: "#36ec22"
    graph_type: bar
    line_width: 2
    show_line: false
    show_state_last: true
    show_trend_icon: false
    state_color: "#ffffff"
    primary_state_as: sum
    show_graph: false
    show_extrema: never
    name_position: below
    show_color_dot: false
    show_fill: false
    ref_entity: sensor.solaredge_opwek_vandaaag
    ref_op: add
    aggregate_func: sum
  - entity: sensor.goodwe_today_s_pv_generation
    statistic_id: null
    name: Goodwe
    color: "#1fac0f"
    graph_type: bar
    line_width: 2
    show_line: false
    aggregate_func: sum
    show_state_last: true
    show_trend_icon: false
    state_color: "#ffffff"
    primary_state_as: sum
    show_extrema: never
    name_position: below
    align_state: center
  - entity: sensor.solaredge_opwek_vandaag
    statistic_id: null
    name: Solaredge
    color: "#61f051"
    graph_type: bar
    line_width: 2
    show_line: false
    aggregate_func: sum
    show_state_last: true
    show_trend_icon: false
    state_color: "#ffffff"
    primary_state_as: sum
    show_extrema: never
    name_position: below
    align_state: right
annotations: []
grid_options:
  columns: 12
  rows: auto