You're viewing version 2.19 of the OpenSearch documentation. For the latest version, see the current documentation. For information about OpenSearch version maintenance, see Release Schedule and Maintenance Policy.

Minimum aggregations

The min metric is a single-value metric that returns the minimum value of a field.

The min aggregation compares numeric fields using a double (double-precision) representation. Results should be considered approximate for fields containing long or unsigned_long integers with absolute values greater than 2⁵³ because the number of significant bits in a double mantissa is 53.

Parameters

The min aggregation takes the following parameters.

Example

This following example request finds the least expensive item—the item with the minimum value of the base_unit_price—in the OpenSearch Dashboards e-commerce sample data:

GET opensearch_dashboards_sample_data_ecommerce/_search
{
  "size": 0,
  "aggs": {
    "min_base_unit_price": {
      "min": {
        "field": "products.base_unit_price"
      }
    }
  }
}

Example response

As shown in the following example response, the aggregation returns the minimum value of products.base_unit_price:

{
  "took": 15,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 4675,
      "relation": "eq"
    },
    "max_score": null,
    "hits": []
  },
  "aggregations": {
    "min_base_unit_price": {
      "value": 5.98828125
    }
  }
}

You can use the aggregation name (min_base_unit_price) as a key to retrieve the aggregation from the response.

Missing values

You can assign a value to missing instances of the aggregated field. See Missing aggregations for more information.

Missing values are normally ignored by min. If you use missing to assign a value lower than any existing value, min returns this replacement value as the minimum value.