floor function
The floor function returns each value of the column, rounded down to the next smaller integer unit of the column.
Parameters
floor(column)
Parameter | Description |
|---|---|
column | The attribute to round down. Its type must be numeral. The column parameter is mandatory. |
Example
The following example uses the Top Hits Spotify dataset.
This example isn’t based on a real scenario, it only explains how to use the function.
Description | Screenshot |
|---|---|
In this example, we want to round down the Tempo attribute. Add a new column, and write the following formula: |  |