# Render Jobs Date-by-Category Pivot with Missing-Value Fill

> Render Jobs Date-by-Category Pivot with Missing-Value Fill 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-17).

Pivots render job records by date and asset category, filling missing values explicitly, and returns two analytical reports for up to 200 rows of render_seconds or sample_count data.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-creative-02-189?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-17
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/render-jobs-date-by-category-pivot-with-missing-value-fill-1e6c2368
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_R3HOcE6k_s8EeYK-5wWi-

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 render-jobs-date-by-category-pivot-with-missing-value-fill-1e6c2368 -d '<json body>'
```

Example prompt: I have render job records for 'group-a' and 'group-b' spanning October 2026 — can you pivot the render_seconds by date and asset group, filling any missing cells with the median, and give me both analytical reports? I have about 150 rows.

## When to prefer this

Choose this endpoint when you have tabular render job records and need to reshape them into a date-by-category cross-tab with explicit handling of sparse or missing cells, specifically for render_seconds or sample_count metrics. It is best when you need two coordinated reports (raw pivot + filled pivot) in one call at very low cost ($0.01 USDC), without needing external data, live predictions, or professional assessment. Ideal for creative pipeline analytics, studio operations dashboards, or batch render audits with up to 200 rows.

## Known failure modes

- Input array exceeds 200 rows — request will be rejected or truncated
- Missing required fields (row_id, asset_group, date, render_seconds, sample_count) cause row rejection
- Invalid date format (non-YYYY-MM-DD) triggers schema validation error
- Empty rows array returns error
- Numeric values outside ±1,000,000,000,000 range fail validation
- Invalid enum for field or method parameter causes schema error

## How this service works

Render jobs — Date by category pivot + Explicit missing-value fill: Date by category pivot + Explicit missing-value fill for supplied render jobs records (render_seconds, sample_count). 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

Two analytical reports: (1) a date-by-category pivot table of the selected metric (render_seconds or sample_count) with rows as dates and columns as asset groups, and (2) a version of that pivot with all missing cells explicitly filled using the chosen method (zero, mean, or median). Results cover up to 200 input rows, computed locally with no external lookups.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "asset_group",
     "date",
     "render_seconds",
     "sample_count"
    ],
    "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
     },
     "sample_count": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "render_seconds": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "row_id": "row-1",
     "asset_group": "group-a",
     "sample_count": 1,
     "render_seconds": 10
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "asset_group": "group-b",
     "sample_count": 2,
     "render_seconds": 20
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "asset_group": "group-a",
     "sample_count": 3,
     "render_seconds": 15
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "asset_group": "group-b",
     "sample_count": 4,
     "render_seconds": 30
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "render_seconds",
    "sample_count"
   ],
   "type": "string",
   "default": "render_seconds"
  },
  "method": {
   "enum": [
    "zero",
    "mean",
    "median"
   ],
   "type": "string",
   "default": "median"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/render-jobs-date-by-category-pivot-with-missing-value-fill-1e6c2368/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)