The filter transform lets you filter for certain things in your data.
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.
Questions about the filter transform? Email us at email@example.com or chat in on the site.