{"uid":"cap_MKfV_6ljKG06fXwXeHAih","slug":"data-reconciliation-trailing-mean-series-two-measure-correlation-1fef3cc1","name":"Data Reconciliation: Trailing Mean Series + Two-Measure Correlation","description":"Data reconciliation — Trailing mean series + Two-measure correlation: Trailing mean series + Two-measure correlation 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-150?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_pPXiIVDsjsf57Byhtjs7v","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 trailing mean time series and a two-measure correlation analysis on supplied source_total/target_total reconciliation data (up to 200 rows, no external lookups).","exampleAgentPrompt":"Run a trailing mean series and two-measure correlation on my reconciliation data — I have 50 rows with source_total and target_total values dated from 2025-01-01 to 2025-02-19, use a window size of 7 and compute the trailing mean on the source_total field.","exampleUseCases":[{"title":"Financial ledger reconciliation trend analysis","prompt":"I have 120 rows of daily ledger data with source_total and target_total amounts grouped by department from 2024-07-01 to 2024-10-28. Can you run a trailing mean series with a window of 5 on source_total and also calculate the two-measure correlation between source and target totals?"},{"title":"Monthly sales channel discrepancy smoothing","prompt":"I'm comparing sales figures from our internal system versus our payment processor — I have 90 rows of daily data with source_total and target_total. Please compute the trailing mean on target_total with a window of 10 and tell me the correlation between the two measures."},{"title":"Inventory count reconciliation over quarters","prompt":"We have 150 rows of quarterly inventory counts split across three warehouse groups, each with a source_total (our count) and target_total (auditor count). Run the trailing mean with a window of 4 on source_total and give me the correlation between both measures."}],"resultDescription":"Returns two independent analytical reports: (1) a trailing mean time series computed over the specified window size for the chosen field (source_total or target_total), and (2) a two-measure correlation report showing the statistical relationship between source_total and target_total across the supplied rows. No external data is fetched; all computation is performed locally on the submitted rows.","failureModes":["Fewer than 1 row submitted — minimum item requirement not met","Window size larger than number of rows — trailing mean cannot be computed","Invalid date format (not YYYY-MM-DD) — schema validation failure","source_total or target_total outside allowed range (-1T to +1T) — validation error","More than 200 rows submitted — exceeds maximum item limit","Missing required fields (row_id, dataset_group, date) — request rejected"],"whenToPreferThis":"Choose this endpoint when you need both a rolling/trailing mean time series and a pairwise correlation between two numeric measures (source_total and target_total) in a single paid call on your own supplied data. It is ideal for data reconciliation workflows where you want to smooth temporal noise and quantify agreement between two data sources without any external lookups or predictions. Prefer this over general-purpose analytics tools when you need lightweight, on-demand statistical reconciliation analysis 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:46:51.758Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-trailing-mean-series-two-measure-correlation-1fef3cc1"}