MicroStrategy ONE
Greatest
Returns the larger of two or more values. The Greatest function differs from the Max function, which returns the largest value in a single value list. Greatest can take multiple lists as input and compare the elements in the lists. It is used for comparisons between metrics.
Syntax
Greatest(Argument1, Argument2,..., ArgumentN)
Where:
The arguments must be metrics.
Example
This simple example illustrates how data is returned by the Greatest function.
Given two value lists, the function compares the values in each position in the list and returns a list containing the highest numbers from each position.
| List 1 | List 2 | Result List |
|
21 |
50 |
50 |
|
18 |
3 |
18 |
|
42 |
22 |
42 |
|
30 |
6 |
30 |
|
7 |
20 |
20 |