For the complete documentation index, see llms.txt. This page is also available as Markdown.

floor

Use the floor() function to convert a field containing a number and return an integer rounded down to the nearest whole number.

Syntax

floor (<number>)

Parameters

Name
Type
Required
Description

number

integer, float

Yes

The numeric value to round down.

Returns

The floor() function returns an integer representing the input number rounded down to the nearest whole number.

Usage notes

  • The function accepts a field that contains a number, meaning it can take integers or floating-point numbers as input.

  • The function explicitly rounds the number down to the nearest whole integer.

  • For positive numbers, this behavior truncates the decimal part (for example, 1.9 becomes 1).

  • For negative numbers, it rounds to the next more negative integer (for example, -2.5 becomes -3).

Examples

Example 1: Round down positive floating-point field

Goal: Round the duration_seconds field down to the nearest integer.

XQL code:

Explanation: This query creates a new field, floored_duration, by taking the duration_seconds (for example, 1.5, 0.8) and rounding it down. For 1.5, it becomes 1; for 0.8, it becomes 0.

Output:

EVENT_ID
DURATION_SECONDS
FLOORED_DURATION

101

1.5

1

102

0.8

0

103

10.2

10

Example 2: Round down calculated floating-point value

Goal: Round the result of a division operation on an integer field.

XQL code:

Explanation: Here, event_id (for example, 101) is divided by 3, resulting in 33.666.... The floor() function then rounds this down to 33.

Output:

EVENT_ID
DIVIDED_EVENT_ID
FLOORED_DIVIDED_ID

101

33.666666

33

102

34.0

34

103

34.333333

34

Example 3: Round down negative number

Goal: Round a negative number extracted from an array field to demonstrate rounding towards negative infinity.

XQL code:

Explanation: For event_id 101, first_numeric_code is -47. The floor() of -47 is still -47 as it's an integer. If a negative float like -2.5 were present, floor() would convert it to -3.

Output:

EVENT_ID
NUMERIC_CODES
FIRST_NUMERIC_CODE
FLOORED_NEGATIVE_CODE

101

[13, -47, 29, 82, -15]

-47

-47

102

[-21, 56, 13, -88, 42]

56

56

103

[90, -33, 7, 51, -62, 18]

-33

-33

Example 4: Round down number extracted from JSON

Goal: Round a numeric value extracted from a JSON field.

XQL code:

Explanation: This query extracts the size_gb value from the simple_json_data field (for example, "500" for event_id 110). The query then converts this string to a number and applies floor(), which for an integer like 500 would result in 500.

Output:

EVENT_ID
SIMPLE_JSON_DATA
JSON_SIZE_NUMBER
FLOORED_JSON_SIZE

110

{"backup_id": "DB-005", "size_gb": 500}

500

500

Last updated

Was this helpful?