{"uid":"cap_urGUnPGaUqj9puxKMZXQI","slug":"data-reconciliation-daily-sum-series-with-missing-value-fill-6ec0f625","name":"Data Reconciliation — Daily Sum Series with Missing-Value Fill","description":"Data reconciliation — Daily sum series + Explicit missing-value fill: Daily sum series + Explicit missing-value fill 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-145?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"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"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_uu46Yg5yZTWkm9aDIjClt","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":"Reconciles daily sum series data between source and target totals, computing daily aggregates and filling missing values using a chosen fill method (zero, mean, or median) for up to 200 rows across two analytical reports.","exampleAgentPrompt":"I have 150 rows of daily source and target sales totals for October grouped by region — can you reconcile them, fill any missing source_total values using the median, and give me the daily sum series report?","exampleUseCases":[{"title":"ETL pipeline discrepancy audit","prompt":"We run a nightly ETL and suspect our target_total is drifting from source_total — can you take these 120 rows of daily records across three dataset groups, fill any nulls in target_total with the mean, and produce the daily sum reconciliation report?"},{"title":"Financial daily close reconciliation","prompt":"Here are 80 rows of daily closing figures for our accounts, with some source_total values missing — reconcile source vs target totals by date, fill the missing source_total entries using zero, and show me the daily sum series breakdown."},{"title":"Multi-group data quality check","prompt":"I've got two dataset groups — 'north-region' and 'south-region' — with 60 rows of daily totals each; some target_total values are null. Can you fill those with the median and run the daily sum series reconciliation so I can see where they diverge?"}],"resultDescription":"Returns two analytical reports per call: a daily sum series showing aggregated source_total and target_total by date and dataset group, and an explicit missing-value fill report showing which rows had nulls and what values were substituted using the chosen method (zero, mean, or median). Covers up to 200 input rows with no external lookups or predictions.","failureModes":["Exceeds 200 row limit — request rejected or truncated","Invalid date format (not YYYY-MM-DD) causes validation error","Missing required fields (row_id, dataset_group, date, source_total, target_total) causes schema rejection","Values outside ±1,000,000,000,000 range rejected by schema","Invalid method enum value (not zero/mean/median) causes error","Invalid field enum value (not source_total/target_total) causes error","Empty rows array (minItems:1 not met) causes rejection"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of daily time-series records with source and target totals and need both a daily sum aggregation and explicit missing-value imputation in a single call. It is ideal for ETL validation, data pipeline reconciliation, or financial close audits where you need to compare two data feeds by date and dataset group without any external data lookups. Prefer it over general analytics tools when you need the specific combination of daily sum series plus missing-value fill as paired reports at low per-call cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:51.266Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-daily-sum-series-with-missing-value-fill-6ec0f625"}