Most frequent sensor value?

Configuration
1

I am using an mqtt sensor to pick up 433 codes but it is very noisy (10 per second when a frequency is received).

I’m trying to find a way to filter but can’t seem to crack it.

Ideally I would like the mode/most frequent value in, say, a 10 second period. I’ve tried with average and median but that won’t work

For example if the sensor read

10, 35, 20, 20, 5, 35, 35

I would like the filter to show 35. Does anyone have any ideas on how to solve for that?

2

You may wish to use a Filter Sensor. You can do signal processing by applying various filters.

3

The use case here seems to be catch an integer value that is most common, not to time-smooth a signal, but I could be wrong. I don’t know an easy way to do this, but I would put in a feature request for mode to be added to the statistics sensor. This seems like a straightforward addition.

4

Hi all

@123 - yes, have been trying to use filter sensor but have only seen average and median, or first value in a given time period but that doesn’t help unfortunately unless someone knows how I can use it as the documentation is not the clearest

@MatthewFlamm exactly - I was hoping that I could identify the most common vs. time-smooth, averages etc. I may try the statistics sensor with a max age of 10 seconds and see if median works for my purposes (even if variance is high, so long as over 50% of values are the one I am looking for it might work), but yes probably a feature request if no existing capability

5

Did you find a way to do this? I am looking for the exact same thing…

1 Like
6

This!
I’m looking for a ‘mode’ sensor too. we have ‘mean’ and ‘median’ value in the statistics sensor but no mode!

Any help gratefully appreciated :slight_smile:

1 Like
7

Vote for a mode (most frequent) statistics sensor on this thread: Mode for statistics sensor

8

I used it to achieve this:

I had the same problem, sometimes my supersonic sensor returned incorrect measurements, now the sensor shows only correct results thanks to this query. Just change the sensor name and insert the code into configuration.yaml

Shows the most frequently occurring measurement result from the last 5 minutes

sql:
  - name: Szambo state
    query: >
      SELECT
        states.state, COUNT(*) AS category_count
      FROM
        states
        INNER JOIN states_meta ON
          states.metadata_id = states_meta.metadata_id
      WHERE
        states_meta.entity_id = 'sensor.poziom_zapelnienia_zbiornika'
        AND last_updated_ts >= strftime('%s', 'now', '-5 minutes')
      GROUP BY states.state  
      ORDER BY
        category_count DESC
      LIMIT
        1;
    column: "state"