Looker Studio's (formerly) CEIL function is a powerful mathematical tool designed to equip users with the ability to round up numbers to the nearest whole integer. The function guarantees precision and enables a user to present data more intuitively, especially when working with complex datasets that include fractions or decimal points.
The syntax for the CEIL function in Google Data Studio is quite straightforward:
Here, 'X' signifies a field or expression that encompasses at least one field. This function ensures that the output is always equal to or greater than the input 'X'.
On execution, the CEIL function rounds off the field or expression value to the nearest integer that is greater than, or equal to the provided value. This can be particularly beneficial in scenarios when data requires simplification for easier comprehension.
Let's take an example in the context of a sales-based business. Suppose you’re tracking the average number of units sold per transaction in your online store and the data yields a decimal value. Say, the value calculated equals 5.67 units. While the precise figure may be useful for analytical purposes, when it comes to reporting, it's sometimes beneficial to use the CEIL function to simplify the data for non-technical viewers.
In this case, by using the following syntax based on the CEIL function—
The result will be rounded up to 6. This is easier for stakeholders to understand: for every transaction, an average of roughly 6 units are being sold.
While certainly useful, it's important to recognize the inherent limitations of the CEIL function. It's particularly important to be aware that since CEIL rounds up values, using it could potentially result in overestimation.
When applied consciously, the CEIL function can be a powerful tool. Remember, it's all about context. When precision is key, it may be more useful to use raw, unrounded data. However, when your audience values simplicity and the differences aren't materially significant, CEIL can be your best friend.
In conclusion, whether you're creating customized reports in Google Data Studio or wrangling large datasets to provide more audience-friendly outputs, the CEIL function serves as a handy instrument in your data tool kit.
Become a Looker Studio expert
for free
Learn all the secrets of data analysis and create beautiful and effective dashboards thanks to our 30-second video courses! Join Catchr's community on YouTube.
Get more video lessons
All your data on Looker Studio
Build Looker Studio dashboard easily with your marketing data from all platforms and track your essential KPIs! No-code integration.
Start free trial now!
Optimize your data analysis
Get free Looker Studio dashboard template among a large collection of +50 stunning template! Elevate your data visualization.
Get free templates!.png)
