ceil function

The ceil function returns each value of the column, rounded up to its next bigger integer unit.


Parameters

ceil(column)

Parameter

Description

column

The attribute to round up. Its type must be numeral. The column parameter is mandatory.


Example

The following example uses the Top Hits Spotify dataset.

Description

Screenshot

In this example, we want to round up the data in the tempo column.

Add a new attribute, then type the following formula: ceil($"Tempo")