Condition Expressions

Condition Expressions let you apply advanced filters for your explore with complex logic leveraging AQL.

When to use Condition Expressions

• Apply nested filtering - Filter based on the results of another calculation (e.g., find customers who made their first purchase in a specific category, then analyze their subsequent behavior). Learn more.
• Filter across multiple models - Apply conditions to fields from different data models simultaneously (e.g., filter both buyer and seller attributes in a transaction dataset). Learn more.
• Build complex AND/OR logic - Combine multiple conditions with advanced logic that goes beyond simple filters. See example.

How to add a Condition Expression

In data exploration interface, in condition, choose Add custom expression to add your custom filter expression using AQL syntax.

Example

Here's a simple example filtering for female users or users from Vietnam:

users.gender == 'female' or countries.name == 'Vietnam'

Learn more

For detailed syntax and in-depth examples including Nested Filtering and Filtering multiple fields from different models, see AQL Condition Reference.