I have influxdb and grafana on a Raspberry Pi and it has been working for some time and have 6 different temperature sensors on one graph working well. However, due to sensor power glitches I have a value of -3000 in one of them and +6000 in another.
Accordingly the graphs are flatlining as all the other inputs are between zero and 30c.
Sadly comparisons simply will not work. When I open the relevant panel I have SELECT field(value) WHERE and a + sign.
If I add any comparison like value < 100 or field(value) < 100 the line for that graph simply disappears…
Am I missing the point - seems a fairly straight forward comparison?
I understand there is no DELETE in influxDB unlike other databases so I don’t know how to delete bad figures.