Last Subset

Contents[Hide]

The Last Subset function returns the value(s) appearing last in an input data series.

When used in a formula visualization, you can specify a count of more than one, e.g, to return the last 3 values.

1. Syntax

LAST(d0,s0,Alignment)

2. Input

The Last Subset function requires the following input:

  • d0 - Input data values - The set of data values for which the Last Subset is calculated.

3. Parameters

The Last Subset function accepts the following parameters:

  • s0 - Last Subset Count (Optional) - The number of values to be returned by the function. Default value is 1.
  • Alignment (Optional) – Hierarchy placeholder to be used as the alignment axis. Specify a hierarchy to return the last input value(s) corresponding to that hierarchy's values: e.g., LAST($Measure$, 1, $Year$) will return the last year within each grouping of years under another hierarchy's values such as Country.

When you use the LAST function within a metric set, it can only return a single value (s0 must be 1). In order to return the last 3 values, for example, you must use a formula visualization. This applies to the other subset functions as well.

4. Output

The Last Subset function generates the following output:

  • Last Subset - The Last Subset result set.

Tip
When used in a formula visualization, you can effectively filter the result to the last value(s), optionally grouped by an alignment hierarchy.

5. See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

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