count(...)Returns a count of a given set of records
Works with the following datatypes:
This function works with 2.0, 2.1, and 3.0 endpoint(s). What does this mean? »
The count(...) function is most commonly used in $select aggregations to return the count of a set of values. For example, to fetch the total number of employees of the City of Chicago:
The TryIt macro has been disabled until future notice while we upgrade this site to SODA3.
It can also be used in $group aggregations, like this one to get the count of employees by job type:
The TryIt macro has been disabled until future notice while we upgrade this site to SODA3.