Float-type attributes
Float attributes support specific operators and conditions. The underlying data type is a float64 (double-precision floating-point format).
| Operators | Description | Example |
|---|---|---|
= |
Equal-to | amount_spent = 10.99 |
!= |
Not-equal-to | amount_spent != 10.99 |
> |
Greater than | amount_spent > 10.99 |
>= |
Greater than or equal to | amount_spent >= 10.99 |
< |
Less than | amount_spent < 10.99 |
<= |
Less than or equal to | amount_spent <= 10.99 |
BETWEEN {value1} AND {value2} |
Equivalent to value1 <= n <= value2 |
amount_spent BETWEEN 100 AND 1000.99 |
IN |
Allows you to specify multiple values in a WHERE clause |
amount_spent IN (10.99,11.99,12.99) |
Conditions accept float (
float64) and integer numbers.Integers automatically get converted to floating point (ie.
99=>99.0).Operators and functions returning a
Float, for exampleCOUNT,SUM,MAX, andMEDIAN, aren't supported for querying segments.
Formatting and separators
Anchor link to section titled "Formatting and separators"A decimal point (
.) is used as a decimal separator, by default.Thousand separators, such as commas and spaces, aren't supported.
Language-sensitive formatted numbers aren't supported.