The filter transform lets you filter for certain things in your data.
How to use the filter transform
In my example, I want to see purchases that were over $150 on my website.
Go ahead and click the Add Transform button, then select Filter Data.
In the window that pulls up, click the blue Add Filter button. Here, we can select what column we want to filter and how we want to filter it.
There are three fields: Column, Operator, and Value.
The Column field is clearly to choose what column you would like to filter on. You use the Operator and Value fields to filter out any information that you don't want to see.
So for my example, I choose the column
Purchase in the column field. My operator is
Greater than and I set the value at
150. This then filters out any data where the purchase was less than $150.
And that's it for filtering!
One note: if the column you choose to filter on is a column with dates, be sure to check the "Treat as a date" checkbox below the column field. This will make sure that you get the right operators and values.
Filtering out rows
One thing that the filter transform helps with is removing rows.
One question we've had is how to remove blank rows. The way this was solved was by using a filter transform and setting it
not equal to blanks, or
"" . This will take out any rows that don't have any content.
Questions about the filter transform? Email us at firstname.lastname@example.org or chat in on the site.