Built-in Functions → min

min() is an aggregation function that returns the minimum valued element in a column.


min(double expr, [groupBy(...)])
  • expr : expression evaluating to double
  • groupBy : optional grouping function that specifies which group of data to operate over

If you use the groupBy function, you must include all the leading grouping dimensions in the Insight from the top-down to the level-based measure you want to evaluate. For more information, refer to Aggregation with a Level Based Measure.


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


  • Find the minimum number sold.
  • Find the minimum number sold, grouped by city.
min(Sales_Acme.Sales.AMOUNT_SOLD, groupBy(Sales_Acme.Sales.CITY))