min

Returns the minimum valued element in a column.

Examples

Find the minimum number sold.

min(Sales_Acme.Sales.AMOUNT_SOLD)

Find the minimum number sold, grouped by city.

min(Sales_Acme.Sales.AMOUNT_SOLD, groupBy(Sales_Acme.Sales.CITY))

Syntax

min(double expr, [groupBy(...)])

• expr : expression evaluating to double

• groupBy : optional grouping function

  Returns

  double or as many doubles as there are groups if groupBy is used.

Notes

You must include all the leading grouping dimensions in the Insight from the top-down to the level-based measure you want to evaluate. See Aggregation with Level Based Measure in Aggregating Functions.