{"uid":"cap_F9HhP8cqhjU-rPx9Co92j","slug":"aggregation-checks-numeric-interval-filter-date-by-category-pivot-4f3ab842","name":"Aggregation Checks — Numeric Interval Filter + Date by Category Pivot","description":"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.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-17-133?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"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}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_hoVcSMtwjID0ud1uE-ABL","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"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.","exampleAgentPrompt":"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).","exampleUseCases":[{"title":"Financial reconciliation interval check","prompt":"I have 50 reconciliation rows with source_sum and aggregate_sum values — filter them to only show rows where source_sum is between 500 and 50000, and give me a date-by-category pivot so I can see how totals break down by dataset_group over time."},{"title":"Sales aggregation category pivot","prompt":"Here are 120 sales aggregation check records with dates and dataset groups — apply a numeric filter on aggregate_sum between 0 and 200000, then pivot the results by date and category so I can spot trends across groups."},{"title":"Data quality range audit","prompt":"I want to audit these 80 aggregation check rows for outliers — filter by source_sum in the range -5000 to 5000 and produce a date-by-category pivot report to see which dataset_groups have anomalies by day."}],"resultDescription":"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).","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:38:51.351Z","isFirstParty":false,"canonicalSlug":"aggregation-checks-numeric-interval-filter-date-by-category-pivot-4f3ab842"}