Sometimes sensors sends bad data and spikes… which make the charts unreadable like the attached.
My question is : How to delete the bad values
Here in my example I can list my bad data by entering > select * from GardenT where value <0 my bad values are negative most of the time.
I have tried many options… none no success
Thanks for your help