---
title: Aggregations
slug: aggregations
docTags: 
createdAt: 2024-09-23T11:38:53.379Z
---

You can use the `groupTransactions` and `groupAccountStates` endpoints to perform aggregation operations. These endpoints support various aggregation functions and allow for grouping, sorting, and filtering of results.

Example:

:::GraphiQL
```json
{
  "endpoint": "https://dton.io/graphql/",
  "query": "{\n  groupTransactions(\n    by: [\"parsed_dns_domain\"],\n    aggregations: [\n      {field: \"in_msg_value_grams\", operation: \"sum\"},\n      {operation: \"count\"}\n    ],\n    order_by: \"in_msg_value_grams__sum\",\n    order_desc: true,\n    page: 0,\n    page_size: 5000,\n    filter_by: {and__: [\n      {parsed_dns_domain__contains: \"ton\"},\n      {gen_utime__lt: \"2024-01-01 00:00:00\"}\n    ]}\n  ) {\n    parsed_dns_domain\n    count\n    in_msg_value_grams__sum\n  }\n}"
}
```
:::

### Explanation of Parameters

- `by`: List of Strings -  Fields by which to group the results.
  - You can use all fields of block, transactions and account states. Check out `raw_transactions` for all available fields in result.
  - For some fields, you can apply functions. 
    - For example, you want to group by month, you can use: by: `["gen_utime__toYYYYMM"]`
    - Currently, allowed functions: `['toYYYYMMDD', 'toYYYYMM', 'toYear']`
- `aggregations`: List of Aggregation Objects - Specifies the fields to aggregate and the operations to perform. Each object includes:
  - field: The field to aggregate on (optional for `count`).
  - operation: The aggregation operation (e.g., `sum`, `count`).
- `order_by`: String - The field to sort the results by. Can be a simple field name or an aggregation field in the format field\_\_operation.
- `order_desc`: Boolean - Specifies the sorting order. true for descending order, false for ascending order.
- `page`: Int - The page number for pagination (default is 0).
- `page_size`: Int - The number of results per page (default is 50).
- `filter_by`: Filtering Expression - A set of conditions to filter the data.

### Available Aggregation Operators

- `count`: Counts the number of items.
- `sum`: Sums the values of a field.
- `min`: Finds the minimum value of a field.
- `max`: Finds the maximum value of a field.
- `avg`: Calculates the average value of a field.
- `argMax`: Finds the value of another field corresponding to the maximum value of the target field.Comment
- `argMin`: Finds the value of another field corresponding to the minimum value of the target field.Comment
- `least`: Finds the least value among the specified fields.
- `quantile`: Calculates the quantile value of a field.

### Notes

Aggregation operations can be computationally expensive; consider limiting the scope using `filter_by` and pagination parameters (`page` and `page_size`).