I have a temperature sensor that, after every reboot, reports exactly 0 °C once during startup (obviously a false/init value). All other readings are valid.
How can I best filter out these invalid 0 °C values that only occur right after a reboot?
For example:
10°C
10,4°C
0°C
9,9°C
10°C
here I want to delete “0”
0,1°C
0,2°C
0,1°C
0°C
0,1°C
here I dont want to delete “0”
@user642 Is there any way to identify which 0s are init values and which aren’t? Is there a specific difference threshold that tells you it’s not an init value?
Not sure what you mean with “filter out”.
Reading? Writing?
I don’t think your issue is an Influxdb issue. Your sensor reported it, you have written it into the db.
Think you are looking at the wrong end.
If I was you, I’d be looking at your source data and “filter” there. Homeassistant?
Don’t write the wrong data in the first instance. This will make your life way easier.
