# AVG

Returns the average value of a set of numbers.

The `AVG` function calculates the average value of a numeric field.

## Syntax

````AVG(value)`

```

### Parameters

• `value` - a field or expression that evaluates to an unaggregated number.

## How the AVG function works

The `AVG` function takes 1 parameter, which must be the name of a numeric field, or a numeric expression. `AVG` returns the average for all values of that field or expression.

You can't apply this function to a pre-aggregated field (Aggregation equals `Auto`), or to an expression which is the result of another aggregation function. For example, a formula such as `AVG(SUM(x)) `will produce an error.

There are 2 other ways to apply this function:

## AVG Examples

In these examples, the parameters passed to AVG are unaggregated numeric dimensions (i.e., they have an Aggregation type of `None`).

`AVG(Latency)`
```AVG(CASE WHEN My Dimension < 1 THEN .5 WHEN My Dimension >= 1 AND My Dimension < 5 THEN 1 ELSE 2 END)```