# Cache Observations – Date by Category Pivot

> Cache Observations – 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-16).

Pivots up to 200 cache observation records (hits/misses) by date and cache category, returning a local descriptive analytics summary table.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ar-analytics-cache-observations-pivot?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-16
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/cache-observations-date-by-category-pivot-8a064403
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_IBn1W44G1v_GkuUZZioLx

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 cache-observations-date-by-category-pivot-8a064403 -d '<json body>'
```

Example prompt: Can you pivot my cache observation data by date and cache group, using hits as the metric? I have records for group-a and group-b across several dates in October 2026 — up to 200 rows total.

## When to prefer this

Choose this endpoint when you have raw cache observation records (hits and misses) already on hand and need a fast, cheap local pivot table grouped by date and cache category — without any external enrichment, forecasting, or complex transformation. It's ideal for quick descriptive analytics on cache performance data when you want a structured cross-tab output for up to 200 rows at minimal cost.

## Known failure modes

- Fewer than 1 row supplied — minimum items constraint violated
- More than 200 rows supplied — maxItems constraint exceeded
- Missing required fields (row_id, cache, date, hits, misses) on any row
- Date field not matching YYYY-MM-DD format
- Invalid field enum value (must be 'hits' or 'misses')
- Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000)
- Payment not completed — x402 payment required at $0.01 USDC

## How this service works

Cache observations - Date by category pivot: Date by category pivot for Cache observations. Up to 200 supplied typed records. Local descriptive analytics; no enrichment or forecast. One of 25 new profiles across 20 shared operations in this industry. 0.01 USDC includes one bounded date by category pivot report.

## Output

A date-by-category pivot report summarizing the chosen metric (hits or misses) across all supplied cache observation records, organized with dates as one axis and cache category names as the other. The report is purely local descriptive analytics with no enrichment or forecasting.

## Request schema (JSON Schema)

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

## More

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