Filter a query to include or exclude users who meet a certain condition. You can filter on event properties, user properties, or user segments. There is no limit to the number of filters you can apply to a single query row.
In the following example, PetBox wants to exclude any users who downloaded their app on Android. Therefore, the user selects the filter where function, and creates a filter where device type is not equal to Android.
In addition to is not equal to, you may filter a property in the following ways:
- Is equal to
- Is not equal to
- Does not contain
- Is defined
- Is not defined