How to create an entity that holds the max temperature of the last 24 hours?

Configuration
9

You can use a statistics sensor like Stephan is showing above, probably the easiest way. That being said you should be aware that statistics sensors reset at restart. It will either show you the maximum value since 7 days ago OR since the last restart of HA, whichever datetime is later.

Wanted to point that out to you since I assume that’s different then how your SQL sensor works. It’s unlikely your SQL query is affected by HA restart.

If this bothers you I’m not sure there’s a good alternative to an SQL sensor. You might just have to turn down the log level for that component.

10

I guess I didn’t provide enough details, for the sensor I’m trying to create, I’d like to find the average of the maximum temperature for 4-5 days. In other words if it’s over 100 degree for more than 4-5 days in a row, then change the irrigation schedule. That’s why I wanted one value per day.

For the SQL sensor, it’s not just that it logs an error, it doesn’t update when the error occurs, which makes it pretty useless in my case. I’ve tried changing the time it executes as well as lowering the count of the dataset the query runs against but it still randomly errors.

11

Wild thought, how about an automation that updates an input number only if the current sensor value is greater than the current input number value, then use the input number value as the trigger for your irrigation automation if it’s above 100 for x amount of time in your case 4-5 days, then reset the input number?

12

I do something similar to what coolie101 suggested above.

I use the hass-variables custom integration but I think you could do the same thing using an input number except I also record the time as an attribute that the input_number can’t do.

then I save that data every day to another variable so I have a daily history.

here are the variables:

variable:
  lowest_temp_so_far:
    value: '100.0'
    restore: true
    attributes:
      icon: 'mdi:thermometer'
      unit_of_measurement: '°F'
      time: '00:00:00'
      friendly_name: 'Todays Lowest Temperature So Far'
  highest_temp_so_far:
    value: '0.0'
    restore: true
    attributes:
      icon: 'mdi:thermometer'
      unit_of_measurement: '°F'
      time: '00:00:00'
      friendly_name: 'Todays Highest Temperature So Far'
  lowest_temp_history:
    value: '55.0'
    restore: true
    attributes:
      icon: 'mdi:thermometer'
      unit_of_measurement: '°F'
      date: '1971-01-01'
      friendly_name: 'Actual Lowest Temperature History'
  highest_temp_history:
    value: '85.0'
    restore: true
    attributes:
      icon: 'mdi:thermometer'
      unit_of_measurement: '°F'
      date: '1971-01-01'
      friendly_name: 'Actual Highest Temperature History'

here are the automations:

  - alias: Env Set Lowest Temp So Far
    trigger:
      - platform: state
        entity_id: sensor.dark_sky_temperature
      - platform: time
        at: '00:00:00'
    action:
      - choose:
          - conditions:
              condition: template
              value_template: "{{ trigger.platform == 'time' }}"
            sequence:
              service: variable.set_variable
              data:
                variable: lowest_temp_so_far
                value: "{{ states('sensor.dark_sky_temperature') | float }}"
                attributes:
                  time: "{{ states('sensor.time') }}"
        default:
          service: variable.set_variable
          data:
            variable: lowest_temp_so_far
            value: >
              {% if states('sensor.dark_sky_temperature') not in ['unavailable', 'unknown'] and (states('sensor.dark_sky_temperature') | float < states('variable.lowest_temp_so_far') | float) %}
                {{ states('sensor.dark_sky_temperature') | float }}
              {% else %}
                {{ states('variable.lowest_temp_so_far') }}
              {% endif %}
            attributes:
              time: >
                {% if states('sensor.dark_sky_temperature') not in ['unavailable', 'unknown'] and (states('sensor.dark_sky_temperature') | float < states('variable.lowest_temp_so_far') | float) %}
                  {{ states('sensor.time') }}
                {% else %}
                  {{ state_attr('variable.lowest_temp_so_far', 'time') }}
                {% endif %}
                                
  - alias: Env Set Highest Temp So Far
    trigger:
      - platform: state
        entity_id: sensor.dark_sky_temperature
      - platform: time
        at: '00:00:00'
    action:
      - choose:
          - conditions:
              condition: template
              value_template: "{{ trigger.platform == 'time' }}"
            sequence:
              service: variable.set_variable
              data:
                variable: highest_temp_so_far
                value: "{{ states('sensor.dark_sky_temperature') | float }}"
                attributes:
                  time: "{{ states('sensor.time') }}"
        default:
          service: variable.set_variable
          data:
            variable: highest_temp_so_far
            value: >
              {% if states('sensor.dark_sky_temperature') not in ['unavailable', 'unknown'] and (states('sensor.dark_sky_temperature') | float > states('variable.highest_temp_so_far') | float) %}
                {{ states('sensor.dark_sky_temperature') | float }}
              {% else %}
                {{ states('variable.highest_temp_so_far') }}
              {% endif %}
            attributes:
              time: >
                {% if states('sensor.dark_sky_temperature') not in ['unavailable', 'unknown'] and (states('sensor.dark_sky_temperature') | float > states('variable.highest_temp_so_far') | float) %}
                  {{ states('sensor.time') }}
                {% else %}
                  {{ state_attr('variable.highest_temp_so_far', 'time') }}
                {% endif %}
                
  - alias: Env Set Actual Daily Lowest Temp
    trigger:
      - platform: time
        at: '23:59:00'
    action:
      - service: variable.set_variable
        data:
          variable: lowest_temp_history
          value: "{{ states('variable.lowest_temp_so_far') }}"
          attributes:
            date: "{{ states('sensor.date') }}"
                              
  - alias: Env Set Actual Daily Highest Temp
    trigger:
      - platform: time
        at: '23:59:00'
    action:
      - service: variable.set_variable
        data:
          variable: highest_temp_history
          value: "{{ states('variable.highest_temp_so_far') }}"
          attributes:
            date: "{{ states('sensor.date') }}"

it’s a bit long winded but it works for my needs.

13

Input number wouldnt work. If the value hadnt increased in 5 days then you’d have a problem. The value is no longer the max in the past 5 days since it’s older then that. And you have no idea what the next highest value is since you aren’t tracking that.

What finity showed works though since you still have the history. Although come to think of it you can also just do that with a single trigger template sensor since those restore state now.

1 Like
14

Try the ha-average integration. You can specify a date range like the last 7 days as you want and will provide an average, min and max. I do a similar thing in my own project to get a five day moving average temperature for a similar purpose. See here for the implementation.

1 Like
15

Problem?, isn’t the requirement the highest value over that period of time?, so if it’s 20 on Mon, 25 on Tues, and 15 the rest of the week, then you’ll still have the highest value?

16

Right, and then? What happens when you hit the following Monday? If you had a sensor which was “highest value in the past 5 days” and your readings were this:
6/1 - 20
6/2 - 25
6/3 - 15
6/4 - 16
6/5 - 15
6/6 - 14
6/7 - 15
6/8 - 14

Then the input number approach breaks on 6/8. By those readings the sensor should have value 20 on 6/1, 25 on 6/2 - 6/7 and then 16 on 6/8. Because on 6/8 the 25 reading is more then 5 days old so it is no longer “the highest value in the past 5 days”. The highest reading in the past 5 days on 6/8 is 16 which occurred on 6/4.

See the problem here? If you only track the highest value it only works if the value keeps going up. As soon as the value peaks for 5+ days that approach breaks.

17

Got it, I assumed the tracking required was for a 5 day period, then reset, then start over for the following 5 days.

18

Thanks for all the input everyone. I’m still pondering the best path forward. I’ve seen the solution from @finity and it seems to be closest to my needs out of the box.

19

There are probably other good solutions suggested but I found the statistics sensor did what I needed. I marked @stevemann as the solution as the second example he posted is effectively what I needed. Adjust the sampling_size and max_age appropriately. Keep in mind sampling_size needs to be larger than the daily number of updates from the original entity_id.

20

Hi
How to do it for the day from midnight to midnight, and not for the last 24 hours?
I want to show the minimum and maximum temperature of the day.

21

See my code above

22

Create a Trigger-based Template Sensor that reports the highest temperature and resets its value at 00:00.

template:
  - trigger:
      - platform: time
        at: '00:00:00'
      - platform: state
        entity_id: sensor.outdoor_temperature
    sensor:
      - name: 'Temperature Daily Max'
        unique_id: 'temperature_daily_max'
        unit_of_measurement: '°C'
        device_class: temperature
        state: >
          {% set t_new = states('sensor.outdoor_temperature') | float(-50) %}
          {{ [t_new, this.state | float(-50)] | max if trigger.platform != 'time' else t_new }}
1 Like
23

ok,
thank you @finity and @123. I’ll be testing.

24

Hello @123,

I’m a noob so excuse the stupid questions, but:

  1. will your code work for minimal temp if I simply replaxe max in the last line with min?
  2. How would this code look like to get the min/max temperature of last 72h?

Thx very much and cheers,
zavjah

25

Yes, you can replace max with min. If you do that then you should also consider changing the default value in the float filter.

Regarding ‘last 72 hours’, that’s possible but the sensor should also report (in an attribute) the date when it starts a 72-hour period. Otherwise you won’t know if the sensor’s reported minimum value is for the last one, two, or three days.

26

Hello @123 ,

thx for your answers. I’ll change the default temp for min to 50, that should do it.

Regarding the 72h min/max: I think I understand your point, but - to be honest - I have no clue how the code should look like. Could you help me out?

Thx in advance,
Zavjah

27

Here’s something to get you started:

template:
  - trigger:
      - platform: time
        at: '00:00:00'
      - platform: state
        entity_id: sensor.outdoor_temperature
    sensor:
      - name: 'Temperature 3 day Min'
        unique_id: 'temperature_3_day_min'
        unit_of_measurement: '°C'
        device_class: temperature
        state: >
          {% set t_new = states('sensor.outdoor_temperature') | float(50) %}
          {{ [t_new, this.state | float(50)] | min if trigger.platform != 'time' 
            else t_new if ((now() - as_datetime(0)).days % 3) is odd else this.state }}
        attributes:
          start_date: >
            {{ now().isoformat() if ((now() - as_datetime(0)).days % 3) is odd else this.attributes.start_date | default(now().isoformat(), true) }}
28

thx @123, I’ll look into this.