home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
ln

The ln function can be used in custom filters and table calculations to get the natural logarithm of a value.

Syntax

ln(value)

The ln function takes the logarithm of a value to the base of the mathematical constant e.

Examples

The ln function can be used to model exponential growth linearly by taking ln of the dependent variable. For example:

ln(order_items.growth_rate)

Things to know

ln can be used to give you the time needed to reach a certain level of growth. For instance, modeling growth exponentially as:

growth = etime

time can be determined using ln as follows:

ln(growth)
Top