# DISTINCTAVGMV

Returns the average of distinct row values in a group

## Signature

> DISTINCTAVGMV(colName)

## Usage Examples

These examples are based on the [Hybrid Quick Start](https://docs.pinot.apache.org/release-1.0.0/basics/getting-started/quick-start#hybrid).

```sql
SELECT DISTINCTAVGMV(DivLongestGTimes) AS VALUE
FROM airlineStats
WHERE arraylength(DivLongestGTimes) > 1
```

| VALUE |
| ----- |
| 32.4  |