Looker Studio Function: Floor
Category: Arithmetic function
The FLOOR function in Looker Studio is a powerful numerical tool that returns the greatest integer less than or equal to a given number. It rounds down decimal or floating-point values to the nearest whole number, making it essential for accurate data analysis and reporting.
Purpose of the Floor Function
1. Data Distribution Analysis :
The FLOOR function helps group continuous data into fixed intervals. This is especially useful in analyzing frequency distributions by simplifying numerical ranges into consistent bins for charts and dashboards.
2. Customer Segmentation :
FLOOR allows you to bucket customers based on numeric metrics such as age, purchase value, or transaction frequency. This simplifies building segments like “Customers who spend between $100 and $199,” improving marketing targeting.
3. Decision Making :
Using FLOOR in reports aids in creating clean, actionable dashboards by removing decimal noise. It helps decision-makers focus on trends and thresholds rather than exact but overly complex data points.
Type of Calculation:
| Use Case | Description |
|---|---|
| Performance Benchmark | Round performance scores or KPIs down to categorize into ranks or tiers. |
| Customer Segmentation | Bucket numeric metrics to create meaningful customer groups. |
| Time Series Analysis | Normalize time-related data into fixed intervals (e.g., every 5 minutes, hours, or days). |
FLOOR(number)
| Parameter | Type | Description |
|---|---|---|
| Number | Decimal | The numeric value you want to round down. |
How Does the Floor Function Work?
The FLOOR function evaluates the numeric value and rounds it down to the nearest whole number that is less than or equal to the input. It executes a simple mathematical rounding operation but plays a significant role in organizing data for deeper insights.
When Should You Use Floor?
Use the FLOOR function when you need:
Grouped intervals (for charts or data segments).
Simplified values for cleaner dashboards.
Data transformation before applying further calculations.
Example of Floor with Result
Example 1: Basic Usage
— Result: 10
Example 2: Column Usage
FLOOR(Sales_Amount)
— Rounds down values in the Sales_Amount column.
Example 3: Handling Decimals and Scientific Notation
FLOOR(5.99999) — Result: 5
FLOOR(1.23e2) — Result: 123
Example 4: Combining with Other Functions
FLOOR(SUM(Revenue)/100)
— Rounds down average revenue per 100 units
Tips and Tricks
Combine FLOOR with CASE statements for dynamic segmentation.
Use FLOOR to create time buckets (e.g.,
FLOOR(Hour(Timestamp)/3)*3for 3-hour blocks).It’s ideal for standardizing inconsistent data inputs in reports.
Avoid using FLOOR if upward rounding is needed—use CEIL instead.
FLOOR always rounds down, while ROUND can round up or down depending on the decimal.
Yes, FLOOR will round negative values down to the next lowest integer (more negative).
It removes decimal precision but enhances clarity and interpretability, especially in grouped data.
Yes, FLOOR can be used in calculated fields across all Looker Studio chart types.
Absolutely. Just wrap the aggregate function inside FLOOR like FLOOR(AVG(Score)).