# Illustration Estimates Duplicate Key Report + Secondary-Measure Weighted Mean

> Illustration Estimates Duplicate Key Report + Secondary-Measure Weighted Mean is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-11-02).

Runs two local analytical reports on illustration estimate records: a duplicate key report and a secondary-measure weighted mean, across up to 200 rows of estimated_hours and actual_hours data.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-creative-19-067?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-11-02
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/illustration-estimates-duplicate-key-report-secondary-measure-5d6d1695
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_-2HeuTCIgTb_CWsnM-DHz

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 illustration-estimates-duplicate-key-report-secondary-measure-5d6d1695 -d '<json body>'
```

Example prompt: Can you check my illustration estimate records for duplicate row IDs and also calculate the weighted mean of estimated_hours? I have 4 rows: row-1 for group-a on 2026-10-01 with estimated 10 hours and actual 1, row-2 for group-b on 2026-10-02 with estimated 20 and actual 2, row-3 for group-a on 2026-10-03 with estimated 15 and actual 3, and row-4 for group-b on 2026-10-04 with estimated 30 and actual 4.

## When to prefer this

Choose this endpoint when you need to simultaneously check for duplicate row identifiers and compute a weighted mean over hour-based illustration estimate data in a single API call. It is ideal for creative project managers or data pipelines that need lightweight, local data quality and statistical summary reports on up to 200 rows without requiring external data sources or live lookups.

## Known failure modes

- Exceeding 200 rows returns a validation error
- Missing required fields (row_id, date, asset_group) causes row rejection
- Invalid date format (non-YYYY-MM-DD) triggers a pattern validation failure
- Null values in the selected measure field may affect weighted mean calculation
- Numeric values outside the allowed range cause schema validation errors

## How this service works

Illustration estimates — Duplicate key report + Secondary-measure weighted mean: Duplicate key report + Secondary-measure weighted mean for supplied illustration estimates records (estimated_hours, actual_hours). 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 duplicate key report identifying any row_id values that appear more than once in the supplied records, and (2) a secondary-measure weighted mean computed over the specified field (estimated_hours or actual_hours) across all submitted rows. Both reports are computed locally without external lookups.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/illustration-estimates-duplicate-key-report-secondary-measure-5d6d1695/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)