### **`avg`**

The `avg` function returns the average of values within a numeric column. It
ignores `NULL` values during the calculation. It is often used
with `match` to calculate the averages within specific groups in the data.

| Syntax | Param data types | Return type |
|---|---|---|
| `avg(numericExpression)` | `NUMBER` | `NUMBER` |

#### Code Sample

- Find all the events where `target.ip` is not empty. For all the events that
  match on `principal.ip`, store the average of `metadata.event_timestamp.seconds`
  in a variable called `avg_seconds`.

      target.ip != ""
      match:
        principal.ip
      outcome:
        $avg_seconds = avg(metadata.event_timestamp.seconds)