Returns the ceiling for the time series described by the expression, by rounding any data values with decimals up to the nearest integer.
|expression||Expression describing the time series to return ceiling values for.|
ceil() function returns the ceiling for each data value in the time series described by the expression.
The ceiling of a data value is the smallest integer that is greater than or equal to that value:
|Sample query with ceil()||Sample result||Input data value||Returned value (ceiling)|
| ||2||Positive, with fractional part||Next higher integer|
|-1||Negative, with fractional part||Integer part of the input value|
|1||Positive integer||Same as the input value|
|-1||Negative integer||Same as the input value|
ceil() 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
ceil() to our original query. Notice that the values below 1 are mapped to 1, and the values from 1 to 1.2 are mapped to 2.