Page tree
Skip to end of metadata
Go to start of metadata

Description
The LOG(n,b) function returns the logarithm, base b, of n where: 

  • n is any positive value
  • The base, b, is any positive value other than 0 or 1

This function takes as arguments any numeric data, including constants, metrics, or metric expressions. If no base is specified, the default base of 10 is applied.

Syntax
SELECT LOG(…)  
SELECT SQRT(number, base)

Examples
SELECT LOG(10, 1/12)
SELECT LOG(SUM(Amount), 2)
SELECT LOG(Amount[Max] * 400, Amount[Max])

  • No labels