{"uid":"cap_nKqdl591JZg3suiyBIl9U","slug":"null-coverage-daily-sum-series-missing-value-fill-analytics-83c49f9a","name":"Null Coverage Daily Sum Series — Missing-Value Fill Analytics","description":"Null coverage — Daily sum series + Explicit missing-value fill: Daily sum series + Explicit missing-value fill for supplied null coverage records (missing_values, total_values). 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-03-145?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","missing_values","total_values"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_values":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"missing_values":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_values":1,"dataset_group":"group-a","missing_values":10},{"date":"2026-10-02","row_id":"row-2","total_values":2,"dataset_group":"group-b","missing_values":20},{"date":"2026-10-03","row_id":"row-3","total_values":3,"dataset_group":"group-a","missing_values":15},{"date":"2026-10-04","row_id":"row-4","total_values":4,"dataset_group":"group-b","missing_values":30}],"maxItems":200,"minItems":1},"field":{"enum":["missing_values","total_values"],"type":"string","default":"missing_values"},"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_tv9ujSJiLUbysxyAsIMwB","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":"Runs two local analytical reports on user-supplied daily null-coverage data: a daily sum time series and an explicit missing-value fill (zero, mean, or median) for up to 200 rows.","exampleAgentPrompt":"I have 4 rows of daily data for October 2026 — group-a and group-b — with missing_values and total_values columns. Can you run the null coverage daily sum series and fill any missing values using the median method on the missing_values field?","exampleUseCases":[{"title":"Data quality audit for ETL pipeline","prompt":"I've got a week's worth of daily pipeline records across two dataset groups with missing_values and total_values counts per day — can you run the null coverage daily sum series and use median fill on the missing_values field so I can see where my data gaps are?"},{"title":"Imputing zeros for sparse sensor data","prompt":"My sensor dataset has up to 150 rows of daily readings with a lot of nulls in the total_values column — can you fill those missing entries with zero and give me a daily sum series report?"},{"title":"Comparing null rates across dataset groups","prompt":"I have about 80 rows of daily records split between three dataset groups, each with missing_values and total_values. Please run the null coverage daily sum and mean-fill the missing_values field so I can compare data completeness across the groups."}],"resultDescription":"Returns two analytical reports: (1) a daily sum series aggregating the specified field over the supplied date range, and (2) an explicit missing-value fill report where nulls in the target field are replaced using the chosen method (zero, mean, or median). Results are computed locally from the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request rejected due to row limit","Missing required fields (row_id, date, missing_values, total_values) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Field or method enum value not recognized — rejected with validation error","Null or out-of-range numeric values exceeding ±1,000,000,000,000 — rejected","Empty rows array — minimum 1 item required"],"whenToPreferThis":"Choose this endpoint when you have pre-collected daily time series data with null/missing value counts and need both a daily aggregate sum series and a filled dataset (zero, mean, or median imputation) in a single low-cost call. It is ideal for data quality audits, ETL validation, and offline analytics on up to 200 rows of grouped daily records where no live data lookup or external prediction is needed.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-10T12:43:29.193Z","isFirstParty":false,"canonicalSlug":"null-coverage-daily-sum-series-missing-value-fill-analytics-83c49f9a"}