Learn how to use and combine different rounding functions in APL
Function Name | Description |
---|---|
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. |
bin()
function is used with summarize operator. If your set of values are disorderly, they will be grouped into fractions.
bin_auto()
function can only be used with the summarize operator by statement with the _time
column.
query_bin_auto_at
below Expression, shifted so that query_bin_auto_at
will be translated into itself.