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.
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:
- transposed the table using reduce.
- Then used Data by value to remove the rows.