New MAQL Logarithmic Functions

New MAQL Logarithmic and Exponential Functions

Four new mathematical functions in MAQL will now allow you to use exponents and logarithms while working with metrics, metric expressions, or numerical constants:

  • Logarithmic Function:  LOG( )
  • Natural Logarithmic Function:  LN( )
  • Exponential Function:  EXP( )
  • Power (Exponent) Function:  POWER( )

LOG( )

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

LOG(…)

SQRT(number, base)

Examples

SELECT LOG(10, 1/12)

SELECT LOG(SUM(Amount), 2)

SELECT LOG(Amount[Max]*400, Amount [Max])

LN( )

Description

LN(n) returns the natural logarithm of n, where n is greater than 0. A natural logarithm is the inverse of the EXP( ) function; LN( ) returns the logarithm of a number with base e, the constant 2.71828182845904. LN( ) takes as arguments any numeric data, including metrics, metrics expressions, and constants.

Syntax

LN(…)

LN(number)

Examples

SELECT LN(10)

SELECT LN(1/12)

SELECT LN(1.5)

SELECT LN(SUM(Amount))

EXP( )

Description

The inverse of the LN( ) function, EXP(n) returns the value of the constant e, 2.71828182845904, raised to the power of the positive real number, n, that is specified. EXP( ) takes as arguments any numeric data, including metrics, metrics expressions, and constants.

Syntax

EXP(…)

EXP(number)

Examples

SELECT EXP(10)

SELECT EXP(1/12)

SELECT EXP(1.5)

SELECT EXP(SUM(Amount))

POWER( )

Description

POWER( n , b ) returns n raised to the b power.

The base n and the exponent b accept any numeric data, including metrics, metric expressions, and constants.

Note: For fractional exponent (b) values, using fractions (e.g. 1/2) rather than decimals (e.g. 0.5) improves performance.

Syntax

POWER(…,…)

POWER(number , power)

Examples

SELECT POWER(10, 1/12)

SELECT POWER(SUM(Amount), 2)

SELECT POWER(1, Amount)

SELECT POWER(Amount * (1/2), Amount)

For a comprehensive look at how you can write custom metrics in GoodData, see the MAQL Reference Guide.

To learn more about  other recently added MAQL functions, see Introducing the Extensible Analytics Engine.

Have more questions? Submit a request

Comments

Powered by Zendesk