MicroStrategy ONE
Max (maximum)
Max returns the largest value in a list of values. For example, it can be used on a list of prices to determine the maximum cost of an item. This is a group-value function.
To compare the highest values in multiple lists of values, use the Greatest function.
Syntax
Max <FactID
Where:
Argumentis an attribute, fact or metric representing a list of numbers.FactIDis a parameter that forces a calculation to take place on a fact table that contains the selected fact.
Example
This example shows a dashboard grid displaying the sales range of items within a subcategory (Aisle). The Max function is used to determine the highest sales of an item within a subcategory. The metric, Maximum Sale, is defined as follows:
Max (Sales){~}
The metric is placed on the grid with the attributes Department and Aisle and the metrics Sale Total and Minimum Sale. The resulting grid appears as follows:
