MicroStrategy ONE
Log (Logarithm)
Returns the logarithm of a given number in a specified base. This is a single-value function.
Syntax
Where:
Argument is a metric representing a list of positive real numbers.
Base is the base of the logarithm.
Example
This simple example illustrates the results of the Log function.
| Function/Result | Calculation |
|
Log(9, 3) = 2 |
9 = 3x where x is the base-3 logarithm; 9 = 32 |
|
Log(4, 4) = 1 |
4 = 4x where x is the base-4 logarithm; 4 = 41 |
|
Log (7776, 6) = 5 |
7776 = 6x where x is the base-6 logarithm; 7776 = 65 |