User Guide Getting Started Help Center Documentation Community Training
Looker
  
English
Français
Deutsch
日本語
ln

Back to Functions and Operators

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