{"uid":"cap_SWwbLL06GECuOj93D_3hI","slug":"aggregation-checks-grouped-numeric-summary-numeric-row-ordering-42a98e41","name":"Aggregation Checks — Grouped Numeric Summary + Numeric Row Ordering","description":"Aggregation checks — Grouped numeric summary + Numeric row ordering: Grouped numeric summary + Numeric row ordering 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-087?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"}}},"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_7kMTwug9dyj3UTA3zcs0K","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":"Produces two analytical reports for aggregation check records: a grouped numeric summary and a numeric row ordering, both computed locally on up to 200 supplied rows of source_sum and aggregate_sum data.","exampleAgentPrompt":"I have 4 aggregation check records across two groups — group-a had source_sum 10 and 15 on 2026-10-01 and 2026-10-03, group-b had source_sum 20 and 30 on 2026-10-02 and 2026-10-04, with aggregate_sums 1, 3, 2, 4 respectively. Can you run both a grouped numeric summary and a numeric row ordering on source_sum for these records?","exampleUseCases":[{"title":"Reconciliation discrepancy review by group","prompt":"I need to spot discrepancies in my reconciliation data — here are 50 rows with row IDs, dataset groups, dates, and source_sum vs aggregate_sum values. Give me a grouped numeric summary and rank all the rows by source_sum so I can see which groups are most out of balance."},{"title":"Daily aggregation audit report","prompt":"Run two reports on my daily aggregation check data: a grouped summary and a row ordering by aggregate_sum. I have 120 rows across three dataset groups covering October 2026 — here's the data."},{"title":"Pipeline output validation before sign-off","prompt":"Before I sign off on the pipeline run, I want a grouped numeric summary and numeric row ordering for these 80 aggregation check records using source_sum as the field — they span groups alpha, beta, and gamma with dates from 2026-09-01 to 2026-09-30."}],"resultDescription":"Returns two independent analytical reports computed on the supplied rows: (1) a grouped numeric summary aggregating source_sum and/or aggregate_sum values by dataset_group, and (2) a numeric row ordering ranking rows by the selected field (source_sum or aggregate_sum). Both reports are derived entirely from the input data with no external lookups.","failureModes":["Submitting more than 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, source_sum, aggregate_sum) cause a schema validation failure","Invalid date format (non-YYYY-MM-DD) triggers a pattern validation error","Numeric values outside ±1,000,000,000,000 are rejected","Empty rows array returns an error due to minItems:1 constraint","Payment failure (insufficient USDC) prevents report generation"],"whenToPreferThis":"Choose this endpoint when you need both a grouped numeric summary and a numeric row ordering in a single call for up to 200 aggregation check records, without requiring any live data lookup, external enrichment, or prediction. It is ideal for reconciliation workflows, pipeline audits, and data quality checks where you supply the rows directly and want two complementary analytical views at minimal cost ($0.01 USDC for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:39:03.950Z","isFirstParty":false,"canonicalSlug":"aggregation-checks-grouped-numeric-summary-numeric-row-ordering-42a98e41"}