# Aggregation Checks — Trailing Mean Series + Secondary-Measure Weighted Mean

> Aggregation Checks — Trailing Mean Series + 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-15).

Computes a rolling trailing mean series and a secondary-measure weighted mean for user-supplied aggregation check records containing source_sum and aggregate_sum fields.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-17-151?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-15
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/aggregation-checks-trailing-mean-series-secondary-measure-weighted-mean-29824798
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_NhoHQESfBs1TD-DDixXwd

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-trailing-mean-series-secondary-measure-weighted-mean-29824798 -d '<json body>'
```

Example prompt: Run trailing mean and weighted mean analytics on my aggregation check records — I have up to 50 rows with source_sum and aggregate_sum fields grouped by dataset_group across dates in October 2026, using a window of 3 and focusing on source_sum as the primary field.

## When to prefer this

Choose this endpoint when you need dual statistical reports — a rolling trailing mean series and a weighted mean — on pre-supplied aggregation check data (source_sum vs aggregate_sum) without any external data lookup. Ideal for data reconciliation workflows, pipeline quality audits, and supply aggregation checks where you already have the rows locally and need lightweight batch computation at low cost ($0.01 USDC for two reports on up to 200 rows).

## Known failure modes

- Missing required fields (row_id, date, dataset_group, source_sum, aggregate_sum) causes validation error
- Exceeding 200 rows returns an error or truncation
- Window size outside the range 2–200 causes rejection
- Malformed date strings not matching YYYY-MM-DD pattern cause parsing errors
- Null values in both source_sum and aggregate_sum may produce undefined weighted mean output

## How this service works

Aggregation checks — Trailing mean series + Secondary-measure weighted mean: Trailing mean series + 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

Returns two independent analytical reports: (1) a trailing mean series computed over the specified rolling window for the chosen field (source_sum or aggregate_sum), and (2) a secondary-measure weighted mean across the supplied rows. Results cover up to 200 rows of user-supplied aggregation check data and are generated locally without external lookups or live data fetches.

## 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"
  },
  "window": {
   "type": "integer",
   "default": 2,
   "maximum": 200,
   "minimum": 2
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/aggregation-checks-trailing-mean-series-secondary-measure-weighted-mean-29824798/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)