Mattie
(Mattias)
November 1, 2020, 7:45pm
1
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
tom_l
November 1, 2020, 9:01pm
2
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
Mattie
(Mattias)
November 1, 2020, 9:36pm
3
thanks! exactly what I needed