# Aggregation Checks — Numeric Interval Filter + Date by Category Pivot

> Aggregation Checks — Numeric Interval Filter + 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-15).

Filters aggregation check records by a numeric interval and produces a date-by-category pivot report, returning two independent analytical reports for up to 200 supplied rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-17-133?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-15
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/aggregation-checks-numeric-interval-filter-date-by-category-pivot-4f3ab842
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_F9HhP8cqhjU-rPx9Co92j

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 aggregation-checks-numeric-interval-filter-date-by-category-pivot-4f3ab842 -d '<json body>'
```

Example prompt: Run two reports on these 4 aggregation check rows — apply a numeric interval filter on source_sum from 0 to 100, then produce a date-by-category pivot: row-1 (2026-10-01, group-a, source_sum=10, aggregate_sum=1), row-2 (2026-10-02, group-b, source_sum=20, aggregate_sum=2), row-3 (2026-10-03, group-a, source_sum=15, aggregate_sum=3), row-4 (2026-10-04, group-b, source_sum=30, aggregate_sum=4).

## When to prefer this

Choose this endpoint when you have up to 200 aggregation check records with source_sum and aggregate_sum fields and need both a numeric range filter and a date-by-category pivot in a single low-cost call ($0.01 USDC). It is ideal for financial reconciliation, data quality audits, and sales aggregation analysis where you supply the data locally and need two distinct analytical views without any live lookup or external data enrichment.

## Known failure modes

- Rows array empty or missing — API rejects with validation error
- More than 200 rows supplied — exceeds maxItems limit
- Invalid date format (not YYYY-MM-DD) — schema pattern validation failure
- source_sum or aggregate_sum outside ±1,000,000,000,000 — value rejected
- Invalid field enum value (not source_sum or aggregate_sum) — schema error
- minimum greater than maximum — may return empty filter result set
- Payment not included or insufficient USDC — x402 payment required error

## How this service works

Aggregation checks — Numeric interval filter + Date by category pivot: Numeric interval filter + Date by category pivot for supplied aggregation checks records (source_sum, aggregate_sum). 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 independent analytical reports: (1) a numeric interval filter report showing which rows have the selected field (source_sum or aggregate_sum) within the specified minimum–maximum range, and (2) a date-by-category pivot table summarizing values broken down by date and dataset_group, both computed locally on the supplied data (up to 200 rows).

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/aggregation-checks-numeric-interval-filter-date-by-category-pivot-4f3ab842/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)