{"uid":"cap_5oYpuCG8YdY_DEHT1Blva","slug":"data-reconciliation-daily-sum-series-trailing-mean-series-790e0b36","name":"Data Reconciliation — Daily Sum Series + Trailing Mean Series","description":"Data reconciliation — Daily sum series + Trailing mean series: Daily sum series + Trailing mean series for supplied data reconciliation records (source_total, target_total). 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-11-136?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_total","target_total"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_total":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"target_total":{"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_total":10,"target_total":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_total":20,"target_total":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_total":15,"target_total":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_total":30,"target_total":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["source_total","target_total"],"type":"string","default":"source_total"},"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_OimIzLubH883CwTGdVAD0","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 daily sum series and trailing mean series analytics for supplied data reconciliation records comparing source and target totals, returning two independent reports for up to 200 rows.","exampleAgentPrompt":"Can you run daily sum and trailing mean series reports on my reconciliation data — I've got rows with source_total and target_total by date across two groups, and I want a window size of 7? There are about 50 rows total.","exampleUseCases":[{"title":"Financial ledger reconciliation trend analysis","prompt":"I need to check the daily sums and a 5-day trailing mean for our source vs target ledger totals across groups 'payments' and 'settlements' — here are 120 rows of daily data by date, can you run both reports on source_total?"},{"title":"ETL pipeline output validation over time","prompt":"We have 80 rows of ETL reconciliation records comparing source and target row counts by date — can you compute the daily sum series and a trailing mean with a window of 10 so I can spot drift in our pipeline outputs?"},{"title":"Cross-system data audit with rolling average","prompt":"I'm auditing two systems over the last quarter and have 60 daily reconciliation records with source_total and target_total fields — please run the daily sum and trailing mean series (window 3) on target_total so I can see where the averages diverge."}],"resultDescription":"Returns two independent analytical reports: (1) a daily sum series aggregating the specified field (source_total or target_total) across dataset groups by date, and (2) a trailing mean series computed over the specified rolling window size — both derived from the supplied reconciliation rows with no external data lookups.","failureModes":["Fewer than 1 row provided — minimum array length not met","More than 200 rows submitted — exceeds maxItems limit","Missing required fields (row_id, dataset_group, date, source_total, target_total) in any row","Date field not in YYYY-MM-DD format — pattern validation failure","Window size less than 2 or greater than 200 — integer constraint violation","Numeric values exceeding ±1,000,000,000,000 — range validation failure","Payment not completed — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you need both a daily sum aggregation and a trailing moving average computed together in a single paid call on up to 200 reconciliation rows — ideal for comparing source vs target totals across groups over time without any external lookups, predictions, or live data. Best suited for offline or batch analytical workflows where you supply all the data and want lightweight statistical summaries at low 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-19T12:44:47.262Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-daily-sum-series-trailing-mean-series-790e0b36"}