Statistics for the rain level within the last 7 days - value not correct

Configuration
,
1

Hello together,

I have created an input_value which will be daily at 23:59 be filled with the current value of the day.
My goal is to have a sensor with the sum of the last 7 days to steer my irrigation system.

My code looks like the following:

sensor:
  - platform: statistics
    unique_id: niederschlag_letzte_7_tage_in_mm
    name: "Niederschlag letzte 7 Tage in mm"
    entity_id: input_number.niederschlag_gestern_in_mm
    state_characteristic: sum
    max_age:
      days: 7
    sampling_size: 7

Within the last week there was only one day with rain:

Screenshot 2023-05-05 at 17.28.29
Screenshot 2023-05-05 at 17.28.292426×1180 180 KB

But the sensor shows the following:

Screenshot 2023-05-05 at 17.30.33
Screenshot 2023-05-05 at 17.30.332448×1250 197 KB

Screenshot 2023-05-05 at 17.31.05
Screenshot 2023-05-05 at 17.31.051142×1056 45.7 KB

What am I doing wrong?
I have also the feeling that after home assistant reboot the value is changing …
Thank you!

2

Have you looked at using a Riemann sum integral sensor Helper?

It would do well on the addition of multiple days values.

3

You means this?

No not until now because I want to avoid to install additional things because my opinion is that the statistics is exactly what I need.

4

Show how you are automating this. Share your automation config.

Very likely. You probably need a better trigger or a condition to prevent restarts altering the sum.

5

There is not much in it:

- id: '1676360064217'
  alias: Log - Niederschlag
  description: ''
  trigger:
  - platform: time
    at: '23:58:00'
  condition: []
  action:
  - service: input_number.set_value
    data:
      value: '{{ states(''input_number.niederschlag_gestern_in_mm'') }}'
    target:
      entity_id: input_number.niederschlag_vorgestern_in_mm
  - delay:
      hours: 0
      minutes: 1
      seconds: 0
      milliseconds: 0
  - service: input_number.set_value
    data:
      value: '{{ states(''sensor.esszimmer_esszimmer_esszimmer_regenmesser_rain_today'')
        }}'
    target:
      entity_id: input_number.niederschlag_gestern_in_mm
  mode: single

Crazy, I had now installed the update, and now the value is fine again.

6

Just right now had a look ro utility meter and riemann…

I see no chance to use this for a 7 day period.

I think with riemann this is just not possible and with utility meter it will be ressetted to 0 after a period of time.

7

It won’t reset if you don’t define a cycle.

8

Yes thats true, but I need for my automation always the value from the last 7 days.
Do you have a recommendation maybe?
I are not 100% precent working.

With my current I think it is the best, but afte rebooting HA I got the feeling that the valuie is added twice.
Like when it is switching again from 0/null or unavailable to the last value and this is added again and so the statistics calculates it.

I just checked again, the intitial value is - initial: null

Is there a possibility to avoid that?

9

No, the initial value will be unknown until it is restored.

The statistics sensor needs to be fixed to ignore unknown → some value transitions.

You can open a new issue here:

10

Those aren‘t sensors.
All I am using are input_numbers which I am filling each night once with the last values.
I am doing this because my sensor are sending not constant updstes and so it is hard to define a valid statistics.
With 7 values within 7 days for an input_number I thoughtbit is more robust.

What I am triing also now is to create an input_number in parallel with initial=0 to avoid the double adding.

Need some weeks to test this. Because my feeling will bw that i have now less values.

11

Does not matter, input_numbers are restored too.

12

Think I got it solved!
Via initial=0

Thanks.