Aggregate Queries with GraphQL

API v58.0 and later

Aggregating queries enables you to analyze the records in your result. The uiapi field includes the query and aggregate field. The aggregate field of RecordQueryAggregate type performs queries that group and aggregate over records.

You can roll up and summarize your results with aggregate functions, such as returning your data with these functions:

  • Average
  • Count
  • Distinct count
  • Grouping
  • Ordering
  • Minimum
  • Maximum
  • Sum

The aggregate functions don’t apply to all field types. For example, average and sum apply to currency and numeric values but not to string values. See Aggregate Functions for Field Types.