Minimum Subset

Contents[Hide]

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

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.
  • Alignment (Optional) - A hierarchy placeholder to be used as the alignment axis. If an alignment hierarchy is not indicated, the subset is applied to the whole result.

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