# Aggregation Checks — Category Frequencies + Secondary-Measure Weighted Mean

> Aggregation Checks — Category Frequencies + Secondary-Measure Weighted Mean is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-10-24).

Computes category frequencies and a secondary-measure weighted mean for up to 200 rows of aggregation check records containing source_sum and aggregate_sum fields.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-17-109?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-24
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/aggregation-checks-category-frequencies-secondary-measure-weighted-mean-95dadc39
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_0bGPEGD_56b4Y_UU-t66Z

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability aggregation-checks-category-frequencies-secondary-measure-weighted-mean-95dadc39 -d '<json body>'
```

Example prompt: Can you run aggregation checks on my dataset — compute category frequencies and a weighted mean for source_sum weighted by aggregate_sum? I have rows with dataset_group values like 'group-a' and 'group-b', dates in 2026, and source_sum values ranging from 10 to 30.

## When to prefer this

Choose this endpoint when you need both category frequency analysis and a weighted mean computation on a batch of aggregation or reconciliation records in a single call. It is ideal for data quality pipelines where you want to inspect group distributions and weighted averages of source and aggregate sums together, without needing external lookups or live data connections. Best suited for small-to-medium datasets up to 200 rows where both reports are needed at once.

## Known failure modes

- Rows array empty or missing — API returns validation error
- More than 200 rows submitted — exceeds maxItems limit
- Invalid date format (not YYYY-MM-DD) — schema pattern validation failure
- source_sum or aggregate_sum out of allowed range (±1 trillion) — validation error
- Missing required fields (row_id, dataset_group, date) — schema error
- Invalid field enum value — rejected with schema validation error
- Payment not included or insufficient — x402 payment required response

## How this service works

Aggregation checks — Category frequencies + Secondary-measure weighted mean: Category frequencies + Secondary-measure weighted mean for supplied aggregation checks records (source_sum, aggregate_sum). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.

## Output

Two independent analytical reports: (1) frequency counts for each category/dataset_group in the supplied rows, and (2) a weighted mean of the selected numeric field (source_sum or aggregate_sum) weighted by the secondary measure — both computed locally from the submitted data, covering up to 200 rows.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "dataset_group",
     "date",
     "source_sum",
     "aggregate_sum"
    ],
    "properties": {
     "date": {
      "type": "string",
      "default": "",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
      "maxLength": 10
     },
     "row_id": {
      "type": "string",
      "default": "",
      "maxLength": 80,
      "minLength": 1
     },
     "source_sum": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "aggregate_sum": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "dataset_group": {
      "type": "string",
      "default": "",
      "maxLength": 80
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "row_id": "row-1",
     "source_sum": 10,
     "aggregate_sum": 1,
     "dataset_group": "group-a"
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "source_sum": 20,
     "aggregate_sum": 2,
     "dataset_group": "group-b"
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "source_sum": 15,
     "aggregate_sum": 3,
     "dataset_group": "group-a"
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "source_sum": 30,
     "aggregate_sum": 4,
     "dataset_group": "group-b"
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "source_sum",
    "aggregate_sum"
   ],
   "type": "string",
   "default": "source_sum"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/aggregation-checks-category-frequencies-secondary-measure-weighted-mean-95dadc39/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from market.datapackvibe.com](https://www.zero.xyz/host/market.datapackvibe.com/llms.txt)