# avg()

`avg(col)` returns the average (mean) of the values in the provided column.

Non-numeric values are ignored. If the provided column does not have any numeric values or the column does not exist, `avg` will return `null`.

## Returns

A table with one row and one column, called `@q.avg`.

## Example

Compute the averaged elapsed time in milliseconds for requests in the **checkout\_api** service, aggregated by **host**.

```python
kubernetes.container_name: "checkout_api"
| stats avg(log.%kv.elapsed_ms) by host
```