How can be filter by condition on field value

We have an option in transform (Filter by name) where we can reduce the field using a regular expression pattern. Can we do the same thing but depending on the field value? eg. if the field value is null

I have 5 gauge meters in one panel. I need to remove the gauge meter if it has a value 0.

It should remove temp and NO2.

what is your data source? though you could use filter data by values transformation

I used this transformation but as the data is one row. Therefore this removes the entire row. So what I did is I used 2 transforms:

  1. transposed the table using reduce.
  2. Then used Data by value to remove the rows.
1 Like