less_than

Filters numeric fields for values strictly less than a specified number. Returns rows where the field value is < the specified value.

Syntax

<numeric_field>:
  less_than: <number>

numeric_field

string

required

The numeric field to filter on, specified in the format view_name.field_name.

less_than

number

required

The maximum value (exclusive). Returns rows where the field value is < this number. Decimals are supported.

Total price is 99.99 or less

orders.total_price:
  less_than: 100.00

Age is 19 or more

users.age:
  not_less_than: 18

⌘I