ceil

Description

Returns the smallest integer greater than or equal to a number. For example, 1.5 becomes 2, and 8.1 becomes 9.

Syntax

Like many functions in DataPrime, ceil supports two notations, function and method notation. These interchangeable forms allow flexibility in how you structure expressions.

ceil(number: number): number

(number: number).ceil(): number

Arguments

Example

Use case: Calculate required SaaS licenses

When averaging license usage over time, results may include decimals. Since fractional licenses cannot be purchased, ceil ensures the number is rounded up to the nearest integer.

Example data

{
    "total_licenses": 100,
    "licenses_in_use": 31,
    "timestamp": "2024-10-10T21:00:00Z"
},
{
    "total_licenses": 100,
    "licenses_in_use": 35,
    "timestamp": "2024-10-11T21:00:00Z"
},
{
    "total_licenses": 100,
    "licenses_in_use": 22,
    "timestamp": "2024-10-12T21:00:00Z"
},
{
    "total_licenses": 100,
    "licenses_in_use": 54,
    "timestamp": "2024-10-13T21:00:00Z"
}

Example query

aggregate ceil(avg(total_licenses)) as licenses_needed

aggregate total_licenses.avg().ceil() as licenses_needed

Example output

{
    "licenses_needed": 36
}