---
title: "Get aggregated statistics"
method: GET
path: "/table/{tableId}/aggregation"
tags: ["aggregation"]
---

# Get aggregated statistics

`GET /table/{tableId}/aggregation`

Returns statistical aggregations of table data based on specified functions and grouping criteria

## Path parameters

- `tableId` string, required

## Response `200`

Returns aggregations list.

- object[]
  - `aggregations` object[]
    - `fieldId` string, required — The id of the field.
    - `total` object, nullable, required — Aggregations by all data in field
      - `value` union, required
        - string
        - number
        - unknown
      - `aggFunc` 'count' | 'empty' | 'filled' | 'unique' | 'max' | 'min' | 'sum' | 'average' | 'checked' | 'unChecked' | 'percentEmpty' | 'percentFilled' | 'percentUnique' | 'percentChecked' | 'percentUnChecked' | 'earliestDate' | 'latestDate' | 'dateRangeOfDays' | 'dateRangeOfMonths' | 'totalAttachmentSize', required
    - `group` object, nullable — Aggregations by grouped data in field

---

[API](https://skmtc.net/teable/apis/teable-app.md) · [All operations](https://skmtc.net/teable/apis/teable-app/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/teable/teable-app/versions/7515f3b33d79/schema)