{"uid":"cap_jd2cQTmUV8uot-sp8NNSA","slug":"aggregation-checks-grouped-numeric-summary-weighted-mean-75fa034a","name":"Aggregation Checks — Grouped Numeric Summary + Weighted Mean","description":"Aggregation checks — Grouped numeric summary + Secondary-measure weighted mean: Grouped numeric summary + 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.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-17-096?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_JiTuo8n0ETlPtLFrzIXSq","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":"Computes a grouped numeric summary and a secondary-measure weighted mean for up to 200 rows of aggregation check data (source_sum, aggregate_sum).","exampleAgentPrompt":"I have 4 aggregation check records grouped into group-a and group-b with source_sum and aggregate_sum values — can you run a grouped numeric summary and a weighted mean on the source_sum field for these rows?","exampleUseCases":[{"title":"Reconciling source vs aggregate sums","prompt":"I have a set of aggregation check rows with source_sum and aggregate_sum values across two dataset groups. Can you give me a grouped numeric summary and a weighted mean on aggregate_sum so I can see where the totals diverge?"},{"title":"Monthly data pipeline audit","prompt":"Here are 150 rows from our monthly pipeline audit, each tagged with a dataset_group and date, and two numeric fields: source_sum and aggregate_sum. Run the grouped summary and secondary-measure weighted mean on source_sum so I can spot any anomalies by group."},{"title":"Finance team aggregation QA","prompt":"Our finance team needs a quick statistical breakdown of these aggregation check records — grouped numeric summary plus weighted mean on aggregate_sum — across about 80 rows spread over several dataset groups. Can you generate the two reports?"}],"resultDescription":"Returns two analytical reports: (1) a grouped numeric summary breaking down source_sum and aggregate_sum statistics by dataset_group, and (2) a secondary-measure weighted mean for the selected field (source_sum or aggregate_sum), all computed locally on the supplied rows with no external lookups. Up to 200 rows processed per call.","failureModes":["More than 200 rows submitted — request rejected due to maxItems constraint","Missing required fields (row_id, dataset_group, date, source_sum, aggregate_sum) cause validation errors","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Numeric values outside ±1,000,000,000,000 range are rejected","Empty rows array (minItems: 1 not met) causes error","Invalid field enum value (not 'source_sum' or 'aggregate_sum') causes rejection"],"whenToPreferThis":"Choose this endpoint when you have up to 200 aggregation check records with source_sum and aggregate_sum fields and need two fast, local statistical reports — a grouped numeric summary and a weighted mean — without any external API calls, predictions, or live data enrichment. Ideal for data reconciliation, pipeline QA, and finance audits where you want offline, reproducible analytics on structured tabular data 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-24T00:54:07.682Z","isFirstParty":false,"canonicalSlug":"aggregation-checks-grouped-numeric-summary-weighted-mean-75fa034a"}