Strommix Deutschland als ApexChart in HomeAssistant

 

Installation: 

1. HACS öffnen und unter den benutzerdefinierten Repositories https://github.com/Philra94/homeassistant-energy-charts hinzufügen. 

2. Typ „Integration“ auswählen und Energy-Charts installieren. 

3. Home Assistant neu starten. 

4. Unter Einstellungen → Geräte & Dienste Energy-Charts hinzufügen. 

5. Land „Germany“, Aktualisierung 15 Minuten und historische Daten „Week“ auswählen. 

Datenaggregation:

Kleine Helfer-Sensoren erstellen, um die einzelnen Kategorien zusammenzufassen 

Strommix auf acht Erzeugungskategorien reduzieren.
Damit bleibt das Diagramm übersichtlich, ohne die wesentlichen Unterschiede zwischen den Energieträgern zu verlieren. 

 Füge folgende Definition in deine configuration.yaml ein. Falls du bereits einen template:-Abschnitt hast, ergänze nur den darunterliegenden - sensor:-Block.

 
template:
  - sensor:
      - name: "Strommix Solar"
        unique_id: strommix_solar
        unit_of_measurement: "MW"
        state_class: measurement
        state: >
          {{ states('sensor.energy_charts_germany_solar') | float(0) }}

      - name: "Strommix Wind"
        unique_id: strommix_wind
        unit_of_measurement: "MW"
        state_class: measurement
        state: >
          {{ states('sensor.energy_charts_germany_wind_total') | float(0) }}

      - name: "Strommix Wasser"
        unique_id: strommix_wasser
        unit_of_measurement: "MW"
        state_class: measurement
        state: >
          {{
            states('sensor.energy_charts_germany_hydro_run_of_river') | float(0)
            + states('sensor.energy_charts_germany_hydro_water_reservoir') | float(0)
          }}

      - name: "Strommix Sonstige EE"
        unique_id: strommix_sonstige_ee
        unit_of_measurement: "MW"
        state_class: measurement
        state: >
          {{
            states('sensor.energy_charts_germany_biomass') | float(0)
            + states('sensor.energy_charts_germany_geothermal') | float(0)
          }}

      - name: "Strommix Kohle"
        unique_id: strommix_kohle
        unit_of_measurement: "MW"
        state_class: measurement
        state: >
          {{
            states('sensor.energy_charts_germany_fossil_brown_coal_lignite') | float(0)
            + states('sensor.energy_charts_germany_fossil_hard_coal') | float(0)
            + states('sensor.energy_charts_germany_fossil_coal_derived_gas') | float(0)
          }}

      - name: "Strommix Gas und Oel"
        unique_id: strommix_gas_und_ol
        unit_of_measurement: "MW"
        state_class: measurement
        state: >
          {{
            states('sensor.energy_charts_germany_fossil_gas') | float(0)
            + states('sensor.energy_charts_germany_fossil_oil') | float(0)
          }}

      - name: "Strommix Atom"
        unique_id: strommix_atom
        unit_of_measurement: "MW"
        state_class: measurement
        state: >
          {{ states('sensor.energy_charts_germany_nuclear_production') | float(0) }}

      - name: "Strommix Sonstige"
        unique_id: strommix_sonstige
        unit_of_measurement: "MW"
        state_class: measurement
        state: >
          {{
            states('sensor.energy_charts_germany_hydro_pumped_storage') | float(0)
            + states('sensor.energy_charts_germany_waste') | float(0)
            + states('sensor.energy_charts_germany_others') | float(0)
          }}

ApexCart-Definition:

type: custom:apexcharts-card
graph_span: 7d
update_interval: 15min
stacked: true

header:
  show: true
  title: Strommix Deutschland – 7 Tage
  show_states: false

apex_config:
  chart:
    height: 400
    stacked: true
    stackType: 100%
    toolbar:
      show: false
  plotOptions:
    bar:
      columnWidth: 95%
      borderRadius: 0
  dataLabels:
    enabled: false
  stroke:
    width: 0
  legend:
    show: true
    position: bottom
  tooltip:
    shared: true
    intersect: false
    y:
      formatter: |
        EVAL:function(value) {
          return value.toFixed(0) + " MW";
        }

yaxis:
  - min: 0
    max: 100
    decimals: 0
    apex_config:
      title:
        text: "Anteil (%)"
      labels:
        formatter: |
          EVAL:function(value) {
            return value.toFixed(0) + " %";
          }

all_series_config:
  type: column
  group_by:
    func: avg
    duration: 1h
    fill: "null"
  show:
    legend_value: false

series:
  - entity: sensor.strommix_solar
    name: Solar
    color: "#FFD54F"

  - entity: sensor.strommix_wind
    name: Wind
    color: "#66BB6A"

  - entity: sensor.strommix_wasser
    name: Wasser
    color: "#2196F3"

  - entity: sensor.strommix_sonstige_ee
    name: Sonstige EE
    color: "#388E3C"

  - entity: sensor.strommix_kohle
    name: Kohle
    color: "#795548"

  - entity: sensor.strommix_gas_und_oel
    name: Gas und Öl
    color: "#FF9800"

  - entity: sensor.strommix_atom
    name: Atom
    color: "#9C27B0"

  - entity: sensor.strommix_sonstige
    name: Sonstige
    color: "#90A4AE"
 

Und wenn Daten drin sind, dann schaut die Grafik auch besser aus: