Can influx ignore values with x difference from last value?

Would be nice to prevent specific entities from sending the value to influx if the difference in value is greater than X.

For example this below messed up my Montly kWh meter after a reboot of some sort

hard to see the image but the value jumped down to 1600 from 5000 for a few minutes. Then my utilitymeters went crazy =) And as a result of that influx went crazy also. Either if I can prevent it in hassio or somewhere else

You can prevent it from displaying in the Grafana query. Here’s one I use:

SELECT min("value") FROM "MB" WHERE ("entity_id" = 'influxdb_db_size') and ("value" > 15) AND $timeFilter GROUP BY time(1d) fill(null)

The and ("value" > 15) bit is the bit you want to insert.

However it would probably be better if you sanitised the data before it was stored. You can do that in home assistant with the outlier filter.

1 Like

thanks! exactly what I needed :+1: