​
Rounding functions

Function NameDescription
ceiling()Calculates the smallest integer greater than, or equal to, the specified numeric expression.
bin()Rounds values down to an integer multiple of a given bin size.
bin_auto()Rounds values down to a fixed-size “bin”, with control over the bin size and starting point provided by a query property.
floor()Calculates the largest integer less than, or equal to, the specified numeric expression.

​
ceiling()

Calculates the smallest integer greater than, or equal to, the specified numeric expression.

​
Arguments

  • x: A real number.

​
Returns

  • The smallest integer greater than, or equal to, the specified numeric expression.

​
Examples

ceiling(x)

ceiling(25.43) == 26

Run in Playground

​
bin()

Rounds values down to an integer multiple of a given bin size.

The bin() function is used with summarize operator. If your set of values are disorderly, they will be grouped into fractions.

​
Arguments

  • value: A date, number, or timespan
  • roundTo: The “bin size”, a number or timespan that divides value.

​
Returns

The nearest multiple of roundTo below value.

​
Examples

bin(value,roundTo)

bin(25.73, 4) == 24

Run in Playground

​
bin_auto()

Rounds values down to a fixed-size “bin”, the bin_auto() function can only be used with the summarize operator by statement with the _time column.

​
Arguments

  • Expression: A scalar expression of a numeric type indicating the value to round.

​
Returns

The nearest multiple of query_bin_auto_at below Expression, shifted so that query_bin_auto_at will be translated into itself.

​
Example

summarize count() by bin_auto(_time)

Run in Playground

​
floor()

Calculates the largest integer less than, or equal to, the specified numeric expression.

​
Arguments

  • number: A real number.

​
Returns

  • The largest integer greater than, or equal to, the specified numeric expression.

​
Examples

floor(number)

floor(25.73) == 25

Run in Playground