Mqtt bizarre data in HA

Energy
1

Hi there,

For info
I use myelectricaData for consumptions, mosquito shows data and connection and broadcast to HA via Mqtt.
Also via Mqtt is my EVT800b micro converter in local mode connected.
I tried different ways to use the Data, sensors to make up my Energy Dashboard. Very often there is no data shown at all and when than the numbers are twice times different (so no mathematical error, Wh in kWh, ).
In my apexcard the sames sensors are listed even in the night with different values to the energy Dashboard and states of the developer tools.

I used different approaches via sensors and or templates but nothing worked so far.
I even consulted ChatGPT, but there you are like in the supermarket hundreds of offers and you don’t know which to pick.

I’m desperate for help.
Manfred

2

You explained your problem to some extent, but did not give any information to us what sensors you have, what you did, what the results were, what you expected. Without that there’s not much any of us can do to help.

3

Sorry I just thought that the bizzare behaviour is enough.
sensor.evt800b_solar_m1_power
sensor.evt800b_solar_m2_power

and this template

</
`template:

  • sensor:

    EVT800B Solar Power Filtered

    • name: “EVT800B Solar Power Filtered”
      unique_id: evt800b_solar_power_filtered
      unit_of_measurement: “W”
      device_class: power
      state_class: measurement
      availability: >
      {{ not is_state(‘sensor.evt800b_m1_power_W’, ‘unknown’)
      and not is_state(‘sensor.evt800b_m2_power_W’, ‘unknown’) }}
      state: >
      {% set m1 = states(‘sensor.evt800b_m1_power_W’) | float(0) %}
      {% set m2 = states(‘sensor.evt800b_m2_power_W’) | float(0) %}
      {{ m1 + m2 }}

    EVT800B Solar Energy Today (Integration)

    • name: “EVT800B Solar Production Today”
      unique_id: evt800b_solar_production_today
      unit_of_measurement: “kWh”
      device_class: energy
      state_class: total_increasing
      availability: >
      {{ not is_state(‘sensor.evt800b_solar_power_filtered’, ‘unknown’) }}
      integration:
      source: sensor.evt800b_solar_power_filtered
      method: trapezoidal
      unit_prefix: k
      round: 3>’
4

I can think of many ways to get bizarre data :wink:

Please formt the code properly, as explained in the post I linked before. It should be a preformatted text block (you find it in the editor menu). It is impossible to see if the yaml is correct if the forum mangles the indentation and other things.

One thing I can spot is that you should not use trapezoid for integral sensors. You should use left. If you don’t, you’ll get huge spikes, especially on solar. I know it is counterintuitive, but it is related to how Home Assistant stores information when the value does not change (such as when solar is 0 for a long time during the night).

5

Sorry for the non proper format.
I’m using my smartphone and here it is, at least for me, to get it right.
I checked the yaml the format there is correct.
I try the left instead of trapooiz.