Minimum Subset
The Minimum Subset function returns the smallest or bottom value(s) in an input data series.
When used in a formula visualization, you can specify a count of more than one, for example to return the 3 smallest values.
1. Syntax
BOTTOM(d0,s0,Alignment)
2. Input
The Minimum Subset function requires the following input:
- d0 - Input data values - The set of data values for which the Minimum Subset is calculated.
3. Parameters
The Minimum Subset function accepts the following parameters:
- s0 - Minimum Subset Count (Optional) - The number of values to be returned by the formula. Default value is 1.
- Alignment (Optional) – Hierarchy placeholder to be used as the alignment axis. Specify a hierarchy to return the bottom input value(s) corresponding to that hierarchy's values: e.g., BOTTOM($Measure$, 1, $Year$) will return the year with the smallest value within each grouping of years under another hierarchy's values such as Country. If an alignment hierarchy is not indicated, the subset is applied to the whole result.
When you use the BOTTOM function within a metric set, it can only return a single value (s0 must be 1). In order to return the bottom 3 values, for example, you must use a formula visualization. This applies to the other subset functions as well.
4. Output
The Minimum Subset function generates the following output:
- Minimum Subset - The Minimum Subset result set.
Tip
When used in a formula visualization, you can effectively filter the result to the bottommost value(s), optionally grouped by an alignment hierarchy.