Number
AQL's number type holds integers, floats, and doubles for use as a dimension or measure, with comparison operators and number formatting in definitions.
Definition
A numeric value, represented as an numeric, integer, float, or double. It can be used as dimension or measure type. The number type can include positive and negative values, as well as decimal points.
dimension order_value {
label: "Order Value"
type: "number"
}
measure revenue {
label: "Revenue"
type: "number"
}Number Operator
| Operator | Example | Description |
|---|---|---|
== is | order_items.discount == 0.5order_items.discount is 0.5 | Equal to |
!=is not | order_items.discount != 1order_items.discount is not 1 | Not equal to |
> | order_items.discount > 0.5 | Greater than |
< | order_items.discount < 0.5 | Less than |
is null | order_items.discount is null | Include if null |
not null | order_items.discount not null | Include if not null |
Number Format
For the number formating in the dimension/measure defintion, please refer to AML Number Format
Text
AQL's text type stores strings of any characters, with operators for equality, pattern matching (like and ilike), list membership, and null checks in filters.
Date
Reference for AQL's Date type: what it represents, operators for filtering by periods or exact timestamps, and how to format dates in dimension definitions.