{"uid":"cap_yCZwlBV_81uSNwD9UjLDD","slug":"commercial-proposal-comparisons-daily-sum-series-explicit-missing-0afa032e","name":"Commercial Proposal Comparisons — Daily Sum Series + Explicit Missing-Value Fill","description":"Commercial proposal comparisons — Daily sum series + Explicit missing-value fill: Daily sum series + Explicit missing-value fill for supplied commercial proposal comparisons records (quoted_amount, delivery_days). 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-company-24-145?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","quoted_amount","delivery_days"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"delivery_days":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"quoted_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","delivery_days":1,"quoted_amount":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","delivery_days":2,"quoted_amount":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","delivery_days":3,"quoted_amount":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","delivery_days":4,"quoted_amount":30}],"maxItems":200,"minItems":1},"field":{"enum":["quoted_amount","delivery_days"],"type":"string","default":"quoted_amount"},"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_GKQ-Emt-YT7aWBOUCqoNO","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 time series for commercial proposal fields (quoted_amount or delivery_days) with explicit missing-value fill, across company groups, for up to 200 rows.","exampleAgentPrompt":"I have 4 commercial proposal rows from two vendors across October 2026 — can you compute the daily sum series of quoted_amount for each company group and fill any missing dates using the median method?","exampleUseCases":[{"title":"Vendor quote trend analysis","prompt":"I have a set of commercial proposals from two suppliers over the past month. Can you sum the quoted_amount by day for each company group and fill any gaps using the median so I can compare their pricing trends?"},{"title":"Delivery time daily aggregation","prompt":"I've got up to 180 rows of bid records with delivery_days from multiple vendors. Please compute the daily total delivery days per company group and fill any missing dates with zero so I can see how commitments vary day by day."},{"title":"Procurement proposal data cleanup","prompt":"We have proposal comparison data with some null quoted_amount values scattered across dates. Can you run a daily sum aggregation using mean fill for the missing values and give me the two reports covering all company groups?"}],"resultDescription":"Returns two analytical reports: a daily sum time series aggregated by company group for the selected field (quoted_amount or delivery_days), and an explicit missing-value fill report using the chosen method (zero, mean, or median), covering all supplied rows up to 200 entries.","failureModes":["More than 200 rows supplied — request will be rejected or truncated","Invalid date format (not YYYY-MM-DD) causes row rejection","Missing required fields (row_id, company_group, date) causes validation error","Invalid enum value for field or method parameter","All values null for a group/date, making mean/median fill undefined","Payment of 0.01 USDC not completed, blocking response"],"whenToPreferThis":"Choose this endpoint when you need to aggregate commercial proposal data (quoted amounts or delivery days) into daily sum time series across company groups, with explicit handling of missing values. It is purpose-built for procurement and vendor comparison analytics on supplied row data — no external lookups or predictions are made, making it deterministic and cost-effective at $0.01 per call for up to 200 rows with two reports included.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:42:23.614Z","isFirstParty":false,"canonicalSlug":"commercial-proposal-comparisons-daily-sum-series-explicit-missing-0afa032e"}