{"uid":"cap_NhoHQESfBs1TD-DDixXwd","slug":"aggregation-checks-trailing-mean-series-secondary-measure-weighted-mean-29824798","name":"Aggregation Checks — Trailing Mean Series + Secondary-Measure Weighted Mean","description":"Aggregation checks — Trailing mean series + Secondary-measure weighted mean: Trailing mean series + 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-151?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"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_8mpJDSAlgqh82OB_nIhjs","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 rolling trailing mean series and a secondary-measure weighted mean for user-supplied aggregation check records containing source_sum and aggregate_sum fields.","exampleAgentPrompt":"Run trailing mean and weighted mean analytics on my aggregation check records — I have up to 50 rows with source_sum and aggregate_sum fields grouped by dataset_group across dates in October 2026, using a window of 3 and focusing on source_sum as the primary field.","exampleUseCases":[{"title":"Finance reconciliation trailing mean check","prompt":"I need to audit my monthly source vs aggregate sums for reconciliation — can you run a trailing mean series with a window of 5 and a weighted mean on these 80 rows of aggregation check data grouped by department?"},{"title":"Supply chain aggregation quality analysis","prompt":"I have 120 rows of supplier aggregation records with source_sum and aggregate_sum columns across different dataset groups from 2026-09 through 2026-12 — run both the trailing mean series and secondary-measure weighted mean with a window of 4 targeting aggregate_sum."},{"title":"Data pipeline aggregate drift detection","prompt":"Can you compute a rolling trailing mean and weighted mean on my pipeline aggregation check output — 30 rows with source_sum and aggregate_sum per date, window of 2, so I can spot drift between raw source totals and aggregated figures?"}],"resultDescription":"Returns two independent analytical reports: (1) a trailing mean series computed over the specified rolling window for the chosen field (source_sum or aggregate_sum), and (2) a secondary-measure weighted mean across the supplied rows. Results cover up to 200 rows of user-supplied aggregation check data and are generated locally without external lookups or live data fetches.","failureModes":["Missing required fields (row_id, date, dataset_group, source_sum, aggregate_sum) causes validation error","Exceeding 200 rows returns an error or truncation","Window size outside the range 2–200 causes rejection","Malformed date strings not matching YYYY-MM-DD pattern cause parsing errors","Null values in both source_sum and aggregate_sum may produce undefined weighted mean output"],"whenToPreferThis":"Choose this endpoint when you need dual statistical reports — a rolling trailing mean series and a weighted mean — on pre-supplied aggregation check data (source_sum vs aggregate_sum) without any external data lookup. Ideal for data reconciliation workflows, pipeline quality audits, and supply aggregation checks where you already have the rows locally and need lightweight batch computation at low cost ($0.01 USDC for two reports on up to 200 rows).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:38:55.862Z","isFirstParty":false,"canonicalSlug":"aggregation-checks-trailing-mean-series-secondary-measure-weighted-mean-29824798"}