# Data Reconciliation Analytics: Numeric Distribution + Date by Category Pivot

> Data Reconciliation Analytics: Numeric Distribution + Date by Category Pivot 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).

Generates two analytical reports — a numeric distribution and a date-by-category pivot — for data reconciliation records comparing source and target totals across up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-11-083?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/data-reconciliation-analytics-numeric-distribution-date-by-category-a42788ce
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_JPuNU4EyNfyvJnuDcpWQ9

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 data-reconciliation-analytics-numeric-distribution-date-by-category-a42788ce -d '<json body>'
```

Example prompt: Can you run a numeric distribution and date-by-category pivot on these reconciliation records? I have 4 rows: row-1 on 2026-10-01 in group-a with source_total 10 and target_total 1, row-2 on 2026-10-02 in group-b with source_total 20 and target_total 2, row-3 on 2026-10-03 in group-a with source_total 15 and target_total 3, and row-4 on 2026-10-04 in group-b with source_total 30 and target_total 4 — analyze the source_total field.

## When to prefer this

Choose this endpoint when you need quick, local analytical computation on reconciliation data comparing source and target totals across categorical groups and dates, without sending data to an external analytics platform. It is ideal when you have up to 200 rows of structured reconciliation records and want both a numeric distribution and a pivot in a single low-cost call ($0.01 USDC for both reports). Prefer this over general-purpose analytics APIs when your data is already structured per the reconciliation schema and you need fast, offline-style analysis.

## Known failure modes

- Fewer than 1 row or more than 200 rows submitted — request rejected
- Missing required fields (row_id, dataset_group, date, source_total, target_total) in any row — validation error
- Date values not matching YYYY-MM-DD pattern — schema validation failure
- Numeric values outside allowed range of -1,000,000,000,000 to 1,000,000,000,000 — schema rejection
- Invalid field selector (not 'source_total' or 'target_total') — enum validation error
- Payment not received or insufficient USDC — request not processed

## How this service works

Data reconciliation — Numeric distribution + Date by category pivot: Numeric distribution + Date by category pivot for supplied data reconciliation records (source_total, target_total). 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 reports for the supplied reconciliation records: (1) a numeric distribution of the selected field (source_total or target_total) showing statistical spread such as min, max, mean, percentiles, and bin counts; and (2) a date-by-category pivot table cross-tabulating totals by date and dataset_group. Both reports are computed locally from the supplied data with no external lookups.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/data-reconciliation-analytics-numeric-distribution-date-by-category-a42788ce/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)