Skip to main content
Use rounding functions to adjust numeric values to specific boundaries or intervals. These functions are essential for data binning, time-series aggregation, and converting continuous values to discrete buckets.

​
List of functions

FunctionDescription
ceilingRounds a number up to the smallest integer greater than or equal to the input.
binRounds values down to an integer multiple of a specified bin size.
bin_autoRounds datetime values down to a fixed-size bin with automatic size selection.
floorRounds a number down to the largest integer less than or equal to the input.