Filters & Operators

Overview

Filters let you narrow down data to specific segments. Trodo provides a visual query builder with AND/OR logic and type-specific operators for precise filtering.

Filter Types

You can filter by these categories:

Filter Type	Description	Example
Event Filters	Filter by event name and properties	Events where `event_name = "agent_run_completed"`
User Profile Filters	Filter by user properties	Users where `plan = "pro"`
Time Filters	Filter by date/time ranges	Events in `last 30 days`
Cohort Filters	Filter by cohort membership	Users in `"Power Users"` cohort

Query Builder

Trodo uses a visual query builder with AND/OR logic:

Filter where:
├── event_name = "agent_run_completed"
├── AND outcome = "success"
└── OR (
    ├── duration_seconds > 120
    └── AND plan = "enterprise"
)

Combine conditions with:

AND: All conditions must be true
OR: At least one condition must be true
Grouping: Nest conditions for complex logic

String Operators

For text properties like country, browser_name, event_name:

Operator	Description	Example
`is`	Exact match	`country is "US"`
`is_not`	Does not equal	`country is_not "US"`
`contains`	Contains substring	`email contains "@gmail"`
`does_not_contain`	Does not contain substring	`email does_not_contain "test"`
`is_set`	Property has any value	`email is_set`
`is_not_set`	Property has no value	`email is_not_set`

String Examples

# Exact match
country is "United States"

# Exclude specific value
browser_name is_not "Safari"

# Partial match
current_url contains "/workflows"
page_title contains "Dashboard"

# Check existence
email is_set
workspace_id is_not_set

Number Operators

For numeric properties like amount_usd, session_count, duration_seconds:

Operator	Description	Example
`equal`	Equals	`amount equal 100`
`not_equal`	Does not equal	`amount not_equal 0`
`greater_than`	Greater than	`amount greater_than 100`
`greater_than_equal`	Greater than or equal	`amount greater_than_equal 100`
`less_than`	Less than	`amount less_than 1000`
`less_than_equal`	Less than or equal	`amount less_than_equal 1000`
`between`	In range (inclusive)	`amount between 100 and 1000`
`not_between`	Outside range	`amount not_between 100 and 1000`
`is_numeric`	Has a numeric value	`price is_numeric`
`is_not_numeric`	Not a number (null/NaN)	`price is_not_numeric`

Number Examples

# Exact value
successful_runs equal 0            # Never completed a run

# Comparisons
seat_count greater_than 10         # Larger workspaces
duration_seconds less_than 5       # Very fast runs

# Range filtering
mrr_usd between 100 and 10000      # Mid-market accounts

# Existence checks
trial_end_date is_numeric

Boolean Operators

For true/false properties like has_completed_onboarding, is_paying_customer:

Operator	Description	Example
`is_true`	Property is true	`has_completed_onboarding is_true`
`is_false`	Property is false	`has_completed_onboarding is_false`

Boolean Examples

has_completed_onboarding is_true
is_paid_customer is_false
beta_opt_in is_true

Datetime Operators

For date/time properties like timestamp, created_at, last_seen:

Operator	Description	Example
`last`	Within the last N days/hours	`timestamp last 7 days`
`not_in_the_last`	Not within the last N days	`timestamp not_in_the_last 7 days`
`between`	Between two dates	`timestamp between Jan 1 and Jan 31`
`not_between`	Outside date range	`timestamp not_between Jan 1 and Jan 31`
`on`	On specific date	`timestamp on Jan 15`
`not_on`	Not on specific date	`timestamp not_on Jan 1`
`before_the_last`	Before the last N days	`timestamp before_the_last 30 days`
`before`	Before specific date	`timestamp before Jan 1, 2024`
`since`	Since specific date	`timestamp since Jan 1, 2024`
`in_the_next`	Within the next N days	`expiry_date in_the_next 7 days`

Datetime Examples

# Relative time filters
timestamp last 30 days             # Last month's activity
timestamp last 24 hours            # Today's events
created_at not_in_the_last 90 days # Older users only

# Date range
timestamp between "2024-01-01" and "2024-01-31"
timestamp not_between "2024-12-24" and "2024-12-26"  # Exclude holidays

# Specific date
timestamp on "2024-01-15"          # Single day
timestamp not_on "2024-01-01"      # Exclude New Year

# Before/after
timestamp before "2024-06-01"      # Before June
timestamp since "2024-01-01"       # This year only
first_seen before_the_last 365 days  # Users over a year old

# Future dates (for expiry, subscription end, etc.)
subscription_end in_the_next 30 days  # Expiring soon

List Operators

For array properties like enabled_integrations, feature_flags, tags:

Operator	Description	Example
`any_in_list`	Any item matches	`enabled_integrations any_in_list ["slack", "notion"]`
`all_in_list`	All items match	`required_tags all_in_list ["verified", "active"]`

List operators can be combined with nested operators based on item type:

List with String Items

# Any integration is slack OR notion
enabled_integrations any_in_list where item is "slack" OR item is "notion"

# Feature flag prefix
feature_flags any_in_list where item contains "beta_"

# All tags must be from approved list
tags all_in_list where item is "verified" OR item is "premium"

List with Number Items

# Any invoice line over $1000
invoice_line_amounts any_in_list where item greater_than 1000

# Seat counts per workspace all above zero
workspace_seats all_in_list where item greater_than 0

Filter Combinations

AND Logic

All conditions must be true:

Events where:
├── event_name is "agent_run_completed"
├── AND outcome is "success"
├── AND duration_seconds greater_than 10
└── AND timestamp last 7 days

→ Successful runs taking more than 10s in the last week

OR Logic

At least one condition must be true:

Users where:
├── plan is "pro"
└── OR successful_runs greater_than 100

→ Pro users OR very heavy users

Nested Groups

Combine AND/OR with grouping:

Events where:
├── event_name is "agent_run_completed"
└── AND (
    ├── workflow_id is "weekly_report"
    └── OR workflow_id is "crm_sync"
)
└── AND (
    ├── duration_seconds greater_than 60
    └── OR plan is "enterprise"
)

→ Long-running or enterprise runs for key workflows

Event Filters

Filter events by name and properties:

Events:
├── event_name is "agent_run_completed"
├── Properties:
│   ├── outcome is "success"
│   └── AND duration_seconds less_than 60

Common Event Filters

Filter	Use Case
`event_name is "signup_completed"`	Signup conversions
`event_name is "agent_run_completed"`	Completed runs
`custom_properties.campaign is "summer"`	Campaign-specific events

User Profile Filters

Filter by user attributes:

Users:
├── plan is "pro"
├── AND country is "US"
└── AND has_completed_onboarding is_true

Common User Filters

Filter	Use Case
`plan is "enterprise"`	Enterprise accounts
`first_seen last 30 days`	New users
`session_count greater_than 10`	Engaged users
`workspace_id is_set`	Workspace members

Cohort Filters

Filter by cohort membership:

Users:
├── IN cohort "Power Users"
└── AND NOT IN cohort "Churned Users"

Cohort filters are particularly useful for:

Comparing behavior across segments
Excluding specific user groups
Analyzing high-value users

Time Filters

Every report supports time range selection:

Time Range: Last 30 days
Granularity: Daily

OR

Custom Range: Jan 1, 2024 - Jan 31, 2024
Granularity: Weekly

See Time Controls for detailed time range options.

Saved Filters

Save frequently used filters for reuse:

Build your filter combination
Click Save Filter
Name it descriptively: “US Pro activated users”
Apply to any report with one click

Best Practices

Be Specific

✅ Good: event_name is "agent_run_completed" AND outcome is "success"
❌ Vague: event_name contains "run"

Use Appropriate Operators

✅ For exact match: is / equal
✅ For ranges: between / greater_than
✅ For text search: contains

❌ Using contains for exact values
❌ Using is for partial matches

Test Filter Results

Before building complex reports, verify your filters:

Apply filter to simple metric (total events)
Check count makes sense
Spot-check sample records if possible

Document Complex Filters

For complex nested logic, add comments:

# High-engagement paying customers
Users where:
├── plan is "pro"
└── OR (
    ├── successful_runs greater_than 20
    └── AND session_count greater_than 50
)

REPORTS

ORGANIZATION

FEATURES

Filters & Operators

Overview

Filter Types

Query Builder

String Operators

String Examples

Number Operators

Number Examples

Boolean Operators

Boolean Examples

Datetime Operators

Datetime Examples

List Operators

List with String Items

List with Number Items

Filter Combinations

AND Logic

OR Logic

Nested Groups

Event Filters

Common Event Filters

User Profile Filters

Common User Filters

Cohort Filters

Time Filters

Saved Filters

Best Practices

Be Specific

Use Appropriate Operators

Test Filter Results

Document Complex Filters

Next Steps

Breakdowns

Time Controls

REPORTS

ORGANIZATION

FEATURES

​Overview

​Filter Types

​Query Builder

​String Operators

​String Examples

​Number Operators

​Number Examples

​Boolean Operators

​Boolean Examples

​Datetime Operators

​Datetime Examples

​List Operators

​List with String Items

​List with Number Items

​Filter Combinations

​AND Logic

​OR Logic

​Nested Groups

​Event Filters

​Common Event Filters

​User Profile Filters

​Common User Filters

​Cohort Filters

​Time Filters

​Saved Filters

​Best Practices

​Be Specific

​Use Appropriate Operators

​Test Filter Results

​Document Complex Filters

​Next Steps

Breakdowns

Time Controls

Overview

Filter Types

Query Builder

String Operators

String Examples

Number Operators

Number Examples

Boolean Operators

Boolean Examples

Datetime Operators

Datetime Examples

List Operators

List with String Items

List with Number Items

Filter Combinations

AND Logic

OR Logic

Nested Groups

Event Filters

Common Event Filters

User Profile Filters

Common User Filters

Cohort Filters

Time Filters

Saved Filters

Best Practices

Be Specific

Use Appropriate Operators

Test Filter Results

Document Complex Filters

Next Steps