# Join Coverage Analytics: Weighted Mean + Dataset Comparison

> Join Coverage Analytics: Weighted Mean + Dataset Comparison 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 secondary-measure weighted mean and performs a keyed dataset comparison for join coverage records (matched_rows, source_rows) across two supplied datasets.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-186?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/join-coverage-analytics-weighted-mean-dataset-comparison-41c802ad
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_OVcgwG1Wf5USvlCGp_Sc6

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-analytics-weighted-mean-dataset-comparison-41c802ad -d '<json body>'
```

Example prompt: Can you compute a weighted mean of matched_rows (weighted by source_rows) and compare two sets of join coverage records — the primary dataset has rows like group-a on 2026-10-01 with 1 source row and 10 matched rows, and I have a second dataset with slightly different matched_row counts for the same keys?

## When to prefer this

Use this endpoint when you need both a weighted mean calculation and a keyed side-by-side dataset comparison for join coverage data (matched_rows, source_rows) in a single $0.01 call, without needing live lookups or external enrichment. It is ideal for data engineers validating ETL join quality, comparing pipeline runs, or auditing coverage drift across dataset groups with up to 200 rows.

## Known failure modes

- Fewer than 1 row supplied returns a validation error
- More than 200 rows supplied exceeds the row limit
- Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) causes schema rejection
- Invalid date format (not YYYY-MM-DD) triggers pattern validation failure
- Null values in both matched_rows and source_rows may produce undefined weighted mean results
- Mismatched keys between primary and secondary datasets may result in sparse comparison output

## How this service works

Join coverage — Secondary-measure weighted mean + Keyed dataset comparison: Secondary-measure weighted mean + Keyed dataset comparison 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 independent analytical reports: (1) a secondary-measure weighted mean of the selected field (matched_rows or source_rows), where the other measure acts as the weight, computed over the supplied rows; and (2) a keyed dataset comparison between the primary rows and the secondary 'other' rows, identifying differences by row_id, dataset_group, and date. Both reports are computed locally with no external data access.

## 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"
  },
  "other": {
   "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",
  
… (truncated)
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/join-coverage-analytics-weighted-mean-dataset-comparison-41c802ad/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)
