DROP SERIES in FLUX

I need to remove series that contain a _value of zero. Is that possible?

From my previous question, here are the details of what caused the issue:

|> aggregateWindow(every: 10s, fn: mean)  
|>fill(column: "_value", usePrevious: true)

After filling forward using Previous, I often end up with null values at the beginning of my data table. I would like to remove those first few rows. How can I do that?

@randymy Depending on which version of Flux you’re working with, you can use the exists operator to check if a column exists or if it’s value is null. You can use it to filter out rows that have null values. Here’s a guide from the InfluxDB 2.0 docs:

https://v2.docs.influxdata.com/v2.0/query-data/guides/exists/