# Duplicate Observations Analytics — Grouped Numeric Summary + Date-by-Category Pivot

> Duplicate Observations Analytics — Grouped Numeric Summary + 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).

Analyzes up to 200 duplicate-observation records, producing a grouped numeric summary and a date-by-category pivot table as two independent analytical reports.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-04-097?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/duplicate-observations-analytics-grouped-numeric-summary-date-by-3009175a
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_VUrGjWuVBRhhqriv01Bqr

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-grouped-numeric-summary-date-by-3009175a -d '<json body>'
```

Example prompt: I have 150 rows of duplicate observation data with row IDs, dataset groups, dates, duplicate_rows counts, and total_rows — can you give me both a grouped numeric summary and a date-by-category pivot for the duplicate_rows field?

## When to prefer this

Choose this endpoint when you need both a grouped numeric summary AND a date-by-category pivot on duplicate observation data in a single call. It is ideal for data quality workflows where you want to understand duplication patterns across categories and time simultaneously, without needing live lookups, predictions, or external integrations. Best suited for batch analytical reporting on pre-collected duplicate detection results of up to 200 rows.

## Known failure modes

- Input array is empty or exceeds 200 rows — validation error returned
- Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) in any row — schema validation failure
- Date field does not match YYYY-MM-DD pattern — pattern validation error
- Numeric fields out of allowed range (±1 trillion) — validation error
- Invalid enum value for 'field' parameter — validation error
- Payment of 0.01 USDC not provided — x402 payment required response

## How this service works

Duplicate observations — Grouped numeric summary + Date by category pivot: Grouped numeric summary + 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 grouped numeric summary showing statistics (e.g. count, sum, mean, min, max) of the selected field (duplicate_rows or total_rows) broken down by dataset_group, and (2) a date-by-category pivot table cross-tabulating the selected field across dates and dataset groups. All analysis is performed locally on 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",
     "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-grouped-numeric-summary-date-by-3009175a/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)