Filter out 0 in results in flux

InfluxDB 2
1

I have some data that has some random erronious values I’d like to filter out. The source of the data sends the anomolies and isn’t going to change anytime soon so I’m hoping to filter the result.

Basically, there’s a value field that has numbers usually in the 1,000 to 100,000,000,000 range. Sometimes I get a 0 come in that is invalid.

I want a ‘where _value not 0’ filter but I can’t figure out how to write this.

This is just for graphing and the stray numbers blow up the graph scales.

Thanks.

2

Hi @Dan_Denson

Maybe this?

from(bucket: "your-bucket")
  |> range(start: -1h)
  |> filter(fn: (r) => r._value != 0.0)
and then the rest of your filters....
2 Likes
3

yeah, I eventually found that. I was trying to overcomplicate things.