# Join Coverage — Trailing Mean Series + Base-100 Series

> Join Coverage — Trailing Mean Series + Base-100 Series 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-19).

Computes a trailing moving average series and a base-100 indexed series for join coverage metrics (matched_rows, source_rows) across up to 200 supplied rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-147?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-19
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/join-coverage-trailing-mean-series-base-100-series-f2a60cf6
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_5NjFGGSxl0dGT4IpiGv-5

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 join-coverage-trailing-mean-series-base-100-series-f2a60cf6 -d '<json body>'
```

Example prompt: Analyze my join coverage data for group-a and group-b across October 2026 — compute both a trailing mean series with a window of 3 and a base-100 series starting from index 0 for the matched_rows field across these 4 rows.

## When to prefer this

Choose this endpoint when you have already-collected join coverage data (matched_rows, source_rows) and need two complementary time-series analytics — rolling average smoothing and base-100 normalization — computed together in a single call for up to 200 rows. It is ideal for data engineers monitoring pipeline join health over time who want trend smoothing and relative baseline comparison without any external data fetching or predictions.

## Known failure modes

- Missing required fields (row_id, date, dataset_group, matched_rows, source_rows) cause validation errors
- More than 200 rows submitted — request rejected at schema limit
- Window size larger than number of rows may produce incomplete trailing means for early rows
- base_index out of bounds for the provided row count
- Malformed date strings not matching YYYY-MM-DD pattern fail schema validation
- Null values in matched_rows or source_rows may affect series continuity

## How this service works

Join coverage — Trailing mean series + Base-100 series: Trailing mean series + Base-100 series for supplied join coverage records (matched_rows, source_rows). 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 analytical report series for the supplied join coverage rows: (1) a trailing mean series over the chosen field (matched_rows or source_rows) using the specified rolling window, and (2) a base-100 indexed series anchored at the chosen base index row — both computed locally from user-supplied data with no external lookup.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "dataset_group",
     "date",
     "matched_rows",
     "source_rows"
    ],
    "properties": {
     "date": {
      "type": "string",
      "default": "",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
      "maxLength": 10
     },
     "row_id": {
      "type": "string",
      "default": "",
      "maxLength": 80,
      "minLength": 1
     },
     "source_rows": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "matched_rows": {
      "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_rows": 1,
     "matched_rows": 10,
     "dataset_group": "group-a"
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "source_rows": 2,
     "matched_rows": 20,
     "dataset_group": "group-b"
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "source_rows": 3,
     "matched_rows": 15,
     "dataset_group": "group-a"
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "source_rows": 4,
     "matched_rows": 30,
     "dataset_group": "group-b"
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "matched_rows",
    "source_rows"
   ],
   "type": "string",
   "default": "matched_rows"
  },
  "window": {
   "type": "integer",
   "default": 2,
   "maximum": 200,
   "minimum": 2
  },
  "base_index": {
   "type": "integer",
   "default": 0,
   "maximum": 199,
   "minimum": 0
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/join-coverage-trailing-mean-series-base-100-series-f2a60cf6/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)