Summarize rows
rows_summarizeCount rows, and sum, average, min and max number columns (min and max of dates), for the rows matching filters, overall and per value of group_by: one call instead of paging through every row. Filters work as in rows_query. Free.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table": "<table>"
},
"name": "rows_summarize"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| match | No | all | |
| table | Yes | The table's name (or its table_id). | |
| columns | No | Number or date columns to measure. | |
| filters | No | ||
| group_by | No | A column to group the rows by. |