Extend numeric_state to match on above/below-or-equal

[MaJerle]

Describe the feature

I'd like to have the possibility for the numeric_state trigger and condition to support above or equal and below or equal.

It could be set with above_equal or below_equal:

  - trigger: numeric_state
    entity_id: sensor.number_of_trvs_to_heat
    above_equal: input_number.min_trvs_to_call_to_enable_pump

Use cases

Consider the automation for heating. One has a input number that defines number of thermostats to call for heating before automation turns on the main pump. There are 2 sensors:

• Input number, settable by user
• Template sensors, that counts the number of TRVs asking for heating

The target is to:

• When number of heating requests matches minimum, turn on pump
• When number of heating requests reaches zero, turn off pump
• When HA starts, to ensure everything is in order

Current workarounds

The current workaround is to use the template trigger with >= check and template conditions.

To trigger when value is equal or above:

  # Turn on pump event
  - trigger: template
    value_template: |-
      {{ states('sensor.number_of_trvs_to_heat')|int >=
          states('input_number.min_trvs_to_call_to_enable_pump')|int }}

  # Turn off pump state
  - trigger: numeric_state
    entity_id: sensor.number_of_trvs_to_heat
    below: 1

  # After the HA starts, control the state
  - trigger: homeassistant
    event: start

The same condition must then be executed in the automation actions part, because multiple triggers start the automation

Anything else?

No response

[Gazoonky]

Yes I am surprised that this feature, which has been requested on multiple previous occasions on the HA forums, can't be implemented. There are workarounds using templates or using values with several decimal places (like <2.001) but to do this for every condition can be tedious.
I have hundreds of these numeric state conditions and I always assumed that HA used a similar system to time conditions: if you set 'after' a time it is inclusive of that time, and if you set 'before' a time it is exclusive of that time. A similar but user modifiable system could presumably be used to include or exclude exact numeric state values?

[msavazzi]

Describe the feature

I have a Temp sensor and I want to use it in a trigger with multiple ranges
the first one is > 12, < 20
the second one should be >= 20 , < 30
In the configuration for events I do have above and below
but they are > and <
We are missing a flag to say equal or above
equal and below

Use cases

For all scenarios where I have a numeric state and have to define different actions depending on the value

Current workarounds

No easy workaround. One is to define the above / below values like above 24.9999 and below 25 but it creates a hole or an overlap
Is not what appropriate...

It's a workaround but it too randomic and depends on the precision of the numeric sensor.
I could write 19.99 and then I have a 0.01 gap

And If I write

    - trigger: numeric_state
      entity_id: sensor.temperature
      # At least one of the following required
      above: 19.99
      below: 25

    - trigger: numeric_state
      entity_id: sensor.temperature
      # At least one of the following required
      above: 12
      below: 20

I have a 0.01 overlap where both are true

[MaJerle]

With purpose specific triggers you should be now able to do this.