# Duplicate Observations Analytics: Two-Measure Correlation + Date-by-Category Pivot

> Duplicate Observations Analytics: Two-Measure Correlation + 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-20).

Runs two local analytical reports on duplicate-observation records: a correlation between duplicate_rows and total_rows, plus a date-by-category pivot table, for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-04-182?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-20
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/duplicate-observations-analytics-two-measure-correlation-date-by-ff662b6f
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_2vu6u6u7BbNqROER6kM-L

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-analytics-two-measure-correlation-date-by-ff662b6f -d '<json body>'
```

Example prompt: I have up to 200 duplicate observation records with fields row_id, dataset_group, date, duplicate_rows, and total_rows — can you run a two-measure correlation between duplicate_rows and total_rows AND generate a date-by-category pivot for my dataset groups?

## When to prefer this

Choose this endpoint when you need both a statistical correlation between two data-quality measures (duplicate_rows vs total_rows) AND a date-by-category pivot in a single low-cost call on up to 200 rows. It is ideal for data quality workflows, ETL audits, or deduplication monitoring where you want two complementary views of the same dataset without external data access or predictions.

## Known failure modes

- Fewer than 1 row submitted returns a validation error
- More than 200 rows submitted exceeds the row limit and is rejected
- Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) cause schema validation failure
- Invalid date format (not YYYY-MM-DD) triggers pattern mismatch error
- Null values in both numeric fields may degrade or break correlation computation
- Payment of 0.01 USDC must be included; missing payment returns a 402 response

## How this service works

Duplicate observations — Two-measure correlation + Date by category pivot: Two-measure correlation + 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) a Pearson or equivalent correlation result between the duplicate_rows and total_rows measures across supplied records, and (2) a pivot table crossing dates against dataset_group categories showing aggregated duplicate observation values — all computed locally with no external lookups, covering up to 200 input rows.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "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-analytics-two-measure-correlation-date-by-ff662b6f/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)