# Equipment Runtime Date-by-Category Pivot

> Equipment Runtime 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).

Pivots equipment runtime and downtime hours data by date and machine category, returning a summary table of up to 200 records.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-sector-analytics-equipment-runtime-pivot?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/equipment-runtime-date-by-category-pivot-e12b32e1
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_IEHRE0DJzKOwSHeXJXnYO

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 equipment-runtime-date-by-category-pivot-e12b32e1 -d '<json body>'
```

Example prompt: Pivot my equipment runtime data by date and machine category — I have 4 rows: row-1 machine group-a on 2026-10-01 with 10 run hours and 1 downtime hour, row-2 group-b on 2026-10-02 with 20 run hours and 2 downtime hours, row-3 group-a on 2026-10-03 with 15 run hours and 3 downtime hours, row-4 group-b on 2026-10-04 with 30 run hours and 4 downtime hours — and use run_hours as the pivot field.

## When to prefer this

Choose this endpoint when you have raw equipment operational records (up to 200 rows) and need a structured pivot table grouped by date and machine category for either run hours or downtime hours. It is ideal for quick local aggregation without needing an external analytics platform or BI tool. It is not suitable for time-series forecasting, anomaly detection, or datasets exceeding 200 records.

## Known failure modes

- Missing required fields (row_id, machine, date, run_hours, downtime_hours) causes validation error
- Date strings not matching YYYY-MM-DD pattern are rejected
- More than 200 rows supplied triggers a max-items validation error
- Empty rows array (minItems:1 violated) returns an error
- Invalid field enum value (not run_hours or downtime_hours) returns a schema error
- Null numeric values are accepted but may result in blank pivot cells

## How this service works

Equipment runtime - Date by category pivot: Date by category pivot for Equipment runtime. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded date by category pivot deliverable.

## Output

Returns a date-by-category pivot table where rows represent dates and columns represent machine categories, with cells containing the aggregated value (run_hours or downtime_hours) for each date-category combination, computed locally from the supplied records without external enrichment.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/equipment-runtime-date-by-category-pivot-e12b32e1/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)