# Duplicate Observations — Equal-Width Histogram + Date by Category Pivot

> Duplicate Observations — Equal-Width Histogram + 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-18).

Generates an equal-width histogram and a date-by-category pivot table for supplied duplicate observation records (duplicate_rows, total_rows) in a single call.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-04-173?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-18
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/duplicate-observations-equal-width-histogram-date-by-category-pivot-ba6a7770
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_Xh_qjQwejeXhJkQJltvFF

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 duplicate-observations-equal-width-histogram-date-by-category-pivot-ba6a7770 -d '<json body>'
```

Example prompt: I have 150 duplicate observation records with row IDs, dates, dataset groups, and duplicate_rows counts — can you run an equal-width histogram with 10 bins on duplicate_rows and also generate a date-by-category pivot for those records?

## When to prefer this

Choose this endpoint when you have up to 200 duplicate observation records and need both a frequency distribution histogram and a date-by-category pivot in one low-cost call. It is ideal for data quality audits, ETL pipeline monitoring, and deduplication reporting where you supply your own data and need fast, local statistical summaries without any external data fetching or prediction.

## Known failure modes

- Exceeds 200 rows — request rejected
- bins parameter outside 1–30 range — validation error
- Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — schema validation error
- Invalid date format (not YYYY-MM-DD) — pattern validation error
- Null values in numeric fields may affect histogram bin calculations
- Empty rows array — minimum 1 item required

## How this service works

Duplicate observations — Equal-width histogram + Date by category pivot: Equal-width histogram + Date by category pivot for supplied duplicate observations records (duplicate_rows, total_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) an equal-width histogram showing frequency distribution of the selected numeric field (duplicate_rows or total_rows) across up to 30 user-defined bins, and (2) a date-by-category pivot table aggregating values by date and dataset_group. Both reports are computed locally on the supplied data, with no external lookups or predictions.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "bins": {
   "type": "integer",
   "default": 5,
   "maximum": 30,
   "minimum": 1
  },
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "dataset_group",
     "date",
     "duplicate_rows",
     "total_rows"
    ],
    "properties": {
     "date": {
      "type": "string",
      "default": "",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
      "maxLength": 10
     },
     "row_id": {
      "type": "string",
      "default": "",
      "maxLength": 80,
      "minLength": 1
     },
     "total_rows": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "dataset_group": {
      "type": "string",
      "default": "",
      "maxLength": 80
     },
     "duplicate_rows": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "row_id": "row-1",
     "total_rows": 1,
     "dataset_group": "group-a",
     "duplicate_rows": 10
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "total_rows": 2,
     "dataset_group": "group-b",
     "duplicate_rows": 20
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "total_rows": 3,
     "dataset_group": "group-a",
     "duplicate_rows": 15
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "total_rows": 4,
     "dataset_group": "group-b",
     "duplicate_rows": 30
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "duplicate_rows",
    "total_rows"
   ],
   "type": "string",
   "default": "duplicate_rows"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/duplicate-observations-equal-width-histogram-date-by-category-pivot-ba6a7770/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)