avg(...)Returns the average of a given set of numbers
Works with the following datatypes:
This function works with 2.0 and 2.1 endpoint(s). What does this mean? »
The avg(...) function is most commonly used in $select aggregations to return the average of a set of numeric values (Numbers). For example, to fetch the average salary of all of the employees at the City of Chicago:
https://data.cityofchicago.org/resource/tt4n-kn4t.json?$select=avg(annual_salary)
It can also be used in $group aggregations, like this one to get the average salary by job type: