Computes the logarithm of the first argument with a base of the second argument.

Numeric literal example:

derive type:single value: LOG(49, 7)

Output: Generates a column containing the value of 7x = 49, which evaluates to 2.

Column reference example:

derive type:single value: LOG(MyValue, 5) as: 'log_MyValue'

Output: Generates the new log_MyValue column containing the exponent that raises 5 to yield the MyValue column. 

derive type:single value: LOG(result_numeric_value, base_numeric_value)

ArgumentRequired?Data TypeDescription
result_numeric_valueYstring, decimal, or integerName of column or Decimal or Integer literal that is generated by the LOG function
base_numeric_valueYstring, decimal, or integerName of column or Decimal or Integer literal that serves as the base for computing the LOG function

result_numeric_value

Name of the column or numeric literal. Value must be greater than 0.

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal49

base_numeric_value

Name of the column or Integer literal that is used for the exponential calculation. 

NOTE: This base value must be a positive integer. If this value is not specified, 10 is used as the base value.

Required?Data TypeExample Value
NoString (column reference) or Integer or Decimal literal7

Example - Exponential functions