Problems with Energy Dashboard and template sensor

[Ricky85it]

Hi all,
i’m trying to create two template sensor for imported and exported from grid.
I can’t use a shelly em or similar on the cables so i have to calculate this two values

I have total consumption and panel production values, now im’ using this templates

    - name: prelievo
      unique_id: "0a7476cc-d6c1-40ba-8ae1-606516c3497e"
      unit_of_measurement: kWh
      device_class: energy
      state_class: total_increasing
      state: >-
        {% if ((states('sensor.em_consumo_energy') | float | round(3))-(states('sensor.em_pannelli_energy')| float | round(3)))> 0 %}
          {{(states('sensor.em_consumo_energy') | float | round(3) - (states('sensor.em_pannelli_energy')) | float | round(3))| round(3)}}
        {% else %}
        0
        {%endif%}
    - name: immissione
      unique_id: "0a7476cc-d6c1-40ba-8ae1-6063a8c5496b"
      unit_of_measurement: kWh
      device_class: energy
      state_class: total_increasing
      state: >-
        {% if ((states('sensor.em_pannelli_energy') | float | round(3))-(states('sensor.em_consumo_energy')| float | round(3)))> 0 %}
          {{(states('sensor.em_pannelli_energy') | float | round(3) - (states('sensor.em_consumo_energy')) | float | round(3))| round(3)}}
        {% else %}
        0
        {%endif%}

The problem is, i don’t want negative values, i need negatives becomes 0.
If i try the code on “models” in “developer tools” seems all ok, if i have a negative number i get back 0, but if i use the “prelievo” sensor on energy dashboard it ignores it and save the negative value.

How can i solve this issue?
Thanks

[tom_l]

    - name: prelievo
      unique_id: "0a7476cc-d6c1-40ba-8ae1-606516c3497e"
      unit_of_measurement: kWh
      device_class: energy
      state_class: total_increasing
      state: >
        {% if ( states('sensor.em_consumo_energy') | float - states('sensor.em_pannelli_energy') | float ) | round(3) > 0 %}
          {{ ( states('sensor.em_consumo_energy') | float - states('sensor.em_pannelli_energy') | float ) | round(3) }}
        {% else %}
          0
        {% endif %}
      availability: >
        {{ has_value('sensor.em_consumo_energy') and has_value('sensor.em_pannelli_energy') }}

    - name: immissione
      unique_id: "0a7476cc-d6c1-40ba-8ae1-6063a8c5496b"
      unit_of_measurement: kWh
      device_class: energy
      state_class: total_increasing
      state: >
        {% if ( states('sensor.em_pannelli_energy') | float - states('sensor.em_consumo_energy')| float ) | round(3) > 0 %}
          {{ ( states('sensor.em_pannelli_energy') | float - states('sensor.em_consumo_energy') | float ) | round(3) }}
        {% else %}
          0
        {% endif %}
      availability: >
        {{ has_value('sensor.em_consumo_energy') and has_value('sensor.em_pannelli_energy') }}

[Ricky85it]

Thanks, but no way.
I have the same problem.

[tom_l]

Show your current config and the history graphs for the two source sensors.

[Ricky85it]

Here the two source sensors

[Ricky85it]

And there is another problem… the “immissione” sensor is ALWAYS 0

[thusassistint (Ed)]

@Ricky85it

i’m trying to create two template sensor for imported and exported from grid.

@Ricky85it

I have total consumption and panel production values

It looks like there is a misconception going on here about how to calculate the imported and exported amount of energy.
You cannot just subtract the total_increasing values of the solar produced energy and total consumed energy to calculate these.
To calculate the respectively imported and exported energy in kWh you have to subtract the instantaneous power values in W or kW, and integrate the results to get the energy in kWh.
The integration can for instance be done with the Integration integration.
The resultant imported and exported energy values in kWh can then be used to feed the energy dashboard.
Do you also have sensors that give the instantaneous power consumption and produced solar power in W or kW?

[Ricky85it]

Yes i have instantaneous power consumption and produced sensors,
so how can i do it?

[thusassistint (Ed)]

@Ricky85it

so how can i do it?

Start with exchanging these power senors with the current energy sensors in your templates, and see what the result is.
You should get two values for both the imported and exported instantanious power.

[Ricky85it]

I just have a sensor template that calculate inport/export power, but is for “power” not “energy” so i can’t use it on Energy Dashboard because is instantaneous value.

[thusassistint (Ed)]

@Ricky85it

is for “power” not “energy” so i can’t use it on Energy Dashboard because is instantaneous value.

Correct. Now you can use the Integration integration to calculate the energy for these two power sensors.

[Ricky85it]

Ok Thanks,
and now i can use that “integration” like a sensor in my sensor template?

[thusassistint (Ed)]

@Ricky85it

now i can use that “integration” like a sensor in my sensor template?

When you have these two total_increasing energy sensors in kWh, one for imported and one for exported energy, you can directly feed those two in the energy dashboard.

[Ricky85it]

I done it correctly (it seems watching the graphs), but i can’t use this entity for Energy Dashboard

[thusassistint (Ed)]

@Ricky85it

(post deleted by author)

To summarize:
You have the instantaneous solar panel production power S in [W] or [kW].
You have the instantaneous consumed power C in [W or [kW].
You can subtract these two values to get the either imported or exported instantaneous power G in [W] or [kW].
So G = C – S in [W] or [kW].
If G is positive it is instantaneous imported power, so if you Integrate this value you get the total_increasing amount of imported energy in [Wh] or [kWh].
And if G is negative it is instantaneous exported power, so the absolute value can be used with the Integration to get the total_increasing amount of exported energy in [Wh] or [kWh].

[thusassistint (Ed)]

@Ricky85it

i can’t use this entity for Energy Dashboard

It will take some time for the Integration sensors to be populated because it is an integration over time.
If you show your yaml code for the sensors and the resultant graph we can have a look at it.

[Ricky85it]

I understand that, but for Energy Dashboard i need two different entities (one for inported and one for exported) and it accept only positive values and not negative.

Doing this method i have only one entities with positive and negative and can’t use it on Energy Dashboard

Sorry, i’m a little bit stupid but i want to understand

[Ricky85it]

That’s the situation, he don’t like negatives values

[thusassistint (Ed)]

@Ricky85it

i have only one entities with positive and negative and can’t use it on Energy Dashboard

You have to “split” the “G” Grid power sensor from my example, using template sensors similar to what you did with your prelievo and immissione sensor code in you first post.
Only in this case these are not energy but power sensors, but that does not make a difference for the method.
When the value is negative you can take the absolute value to convert it to a positive value.
So the result is two instantaneous power sensors with positive values (one import and one export) that can then be integrated to get the energy sensors with total increasing positive values.

@Ricky85it

i want to understand

Good for you: I agree that it is always more satisfying when you really understand something instead of just coping code from someone else.

[Ricky85it]

That’s the first trouble, i’ve not found a working code to set to zero the negative values.
I always receive positive and negative values.
The actual codes are this:

    - name: power_prelievo
      unique_id: "0a7476cc-d6c1-40ba-8ae1-6054fa43497e"
      unit_of_measurement: kW
      device_class: power
      state_class: measurement
      state: >-
        {% if ( states('sensor.em_consumo_power') | float - states('sensor.em_pannelli_power') | float ) | round(3) > 0 %}
          {{ ( states('sensor.em_consumo_power') | float - states('sensor.em_pannelli_power') | float ) | round(3) }}
        {% else %}
          0
        {% endif %}
      availability: >
        {{ has_value('sensor.em_consumo_power') and has_value('sensor.em_pannelli_power') }}

    - name: power_immissione
      unique_id: "0a7476cc-d6c1-40ba-8ae1-60544543497e"
      unit_of_measurement: kW
      device_class: power
      state_class: measurement
      state: >-
        {% if ( states('sensor.em_pannelli_power') | float - states('sensor.em_consumo_power') | float ) | round(3) > 0 %}
          {{ ( states('sensor.em_pannelli_power') | float - states('sensor.em_consumo_power') | float ) | round(3) }}
        {% else %}
          0
        {% endif %}
      availability: >
        {{ has_value('sensor.em_pannelli_power') and has_value('sensor.em_consumo_power') }}