aggregate
Group and aggregate data.
aggregate
Group and aggregate data.
Parameters
{
"data": list[dict], # Records to aggregate (required)
"group_by": str, # Field to group by (required)
"aggregations": dict # Field → function mapping (required)
}Aggregation Functions
sum: Sum valuesavg: Average valuescount: Count recordsmin: Minimum valuemax: Maximum value
Returns
{
"groups": list[dict], # Grouped results
"total_groups": int # Number of groups
}Example
result = client.invoke("analytics-mcp", "aggregate", token, {
"data": [
{"region": "US", "sales": 100},
{"region": "US", "sales": 150},
{"region": "EU", "sales": 200}
],
"group_by": "region",
"aggregations": {
"sales": "sum",
"region": "count"
}
})
for group in result["data"]["groups"]:
print(f"{group['region']}: {group['sales_sum']} total sales")