Returns the floor for the time series described by the expression, by rounding any data values with decimals down to the nearest integer.
|expression||Expression describing the time series to return floor values for.|
floor() function returns the floor for each data value in the time series described by the expression.
The floor of a data value is the greatest integer that is less than or equal to that value:
|Sample query with floor()||Sample result||Input data value||Returned value (floor)|
| ||1||Positive, with fractional part||Integer part of the input value|
|-2||Negative, with fractional part||Next lower integer|
|1||Positive integer||Same as the input value|
|-1||Negative integer||Same as the input value|
floor() returns a separate series of results for each time series described by the expression.
Here’s a query that returns a time series that reports positive fractional values between .2 and 1.2.
Now we apply
floor() to our original query. Notice that the values below 1 are mapped to 0, and the values from 1 to 1.2 are mapped to 1.