Minimum Subset


The Minimum Subset function returns a specified number of the smallest values in an input data series. For example, the function can be used to return the 3 smallest values.

1. Syntax


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.
  • Alignment (Optional) - A hierarchy placeholder to be used as the alignment axis.

3. Parameters

The Minimum Subset function requires the following parameter:

  • s0 - Minimum Subset Count - The number of values to be returned by the formula. Default value is 1.

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.

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri