# Join Coverage — Grouped Numeric Summary + Category Frequencies

> Join Coverage — Grouped Numeric Summary + Category Frequencies 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 grouped numeric summary statistics and category frequency distributions for join coverage records (matched_rows, source_rows) across up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-086?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-grouped-numeric-summary-category-frequencies-1ff0d069
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_aqU77__ylTLaBfYmeXLCm

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-grouped-numeric-summary-category-frequencies-1ff0d069 -d '<json body>'
```

Example prompt: I have join coverage records for two groups — group-a and group-b — with matched_rows and source_rows values across dates in October 2026. Can you give me a grouped numeric summary and category frequency breakdown for the matched_rows field across up to 4 rows?

## When to prefer this

Choose this endpoint when you have tabular join coverage data (matched_rows, source_rows) segmented by dataset group and date, and need both grouped numeric descriptive statistics and category frequency distributions in a single call without any external data lookup or prediction. Ideal for ETL auditing, data quality monitoring, and reconciliation reporting workflows where you supply the data and want local analytical summaries fast and cheaply.

## Known failure modes

- Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) returns validation error
- More than 200 rows submitted — request rejected due to maxItems constraint
- Invalid date format (not YYYY-MM-DD) causes schema validation failure
- Null values in numeric fields may affect summary statistics output
- Empty rows array rejected due to minItems: 1 constraint

## How this service works

Join coverage — Grouped numeric summary + Category frequencies: Grouped numeric summary + Category frequencies 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

Two analytical reports: (1) a grouped numeric summary (e.g. mean, min, max, std dev) of the selected field (matched_rows or source_rows) broken down by dataset_group, and (2) category frequency counts showing how often each dataset_group appears across the supplied rows. Results are computed locally with no external lookups.

## 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"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/join-coverage-grouped-numeric-summary-category-frequencies-1ff0d069/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)