$avg - Upstash Documentation

$avg computes the arithmetic mean of a field across matching documents.

If missing is provided, documents without the field are treated as if they had the missing value.

Field must be FAST.

Argument	Type	Required	Description
`field`	`string`	Yes	Field to aggregate.
`missing`	`number`	No	Fallback value for missing fields.

await index.aggregate({  aggregations: {    avg_price: { $avg: { field: "price", missing: 0 } },  },});

index.aggregate(    aggregations={"avg_price": {"$avg": {"field": "price", "missing": 0}}})

SEARCH.AGGREGATE products '{}' '{"avg_price": {"$avg": {"field": "price", "missing": 0}}}'

{ "avg_price": { "value": 40 } }

value is null when no values are available after filtering.