# Aggregation Checks — Numeric Interval Filter + Secondary-Measure Weighted Mean

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

Filters aggregation check records by a numeric interval on a chosen field and computes a secondary-measure weighted mean, returning two analytical reports for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-17-132?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-secondary-measure-weighted-319e745f
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_YSwNPr245ogFb7Im4VAjD

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-secondary-measure-weighted-319e745f -d '<json body>'
```

Example prompt: For these aggregation check rows I'm uploading (up to 200 records with source_sum and aggregate_sum fields), filter on source_sum between 0 and 100, and give me both the interval-filtered report and the secondary-measure weighted mean report.

## 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 interval filter report and a weighted mean in a single paid call. It is ideal for lightweight ETL validation, data quality audits, or financial reconciliation checks where no external data lookups are needed and results must be derived purely from supplied data.

## Known failure modes

- Missing required fields (row_id, dataset_group, date, source_sum, aggregate_sum) cause validation errors
- Submitting more than 200 rows exceeds the row limit and results in a rejection
- Invalid date format (not YYYY-MM-DD) causes schema validation failure
- Minimum value greater than maximum value may yield an empty filtered set with no weighted mean
- Null values in both source_sum and aggregate_sum may produce undefined weighted mean
- Payment not included or insufficient USDC causes x402 payment-required error

## How this service works

Aggregation checks — Numeric interval filter + Secondary-measure weighted mean: Numeric interval filter + Secondary-measure weighted mean 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

Returns two analytical reports: (1) a numeric interval filter report listing rows where the chosen field (source_sum or aggregate_sum) falls within the specified minimum–maximum range, and (2) a secondary-measure weighted mean report computing the weighted average of the complementary measure across all supplied rows or the filtered subset. Results are based entirely on the supplied data with no external lookups.

## 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-secondary-measure-weighted-319e745f/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)