{"uid":"cap_Lw9W_Ds_75PPF2_DZAtfA","slug":"contract-renewal-inventories-grouped-numeric-summary-weighted-mean-df9a61b9","name":"Contract Renewal Inventories — Grouped Numeric Summary & Weighted Mean","description":"Contract renewal inventories — Grouped numeric summary + Secondary-measure weighted mean: Grouped numeric summary + Secondary-measure weighted mean for supplied contract renewal inventories records (expiring_contracts, renewed_contracts). 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-20-096?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","expiring_contracts","renewed_contracts"],"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},"renewed_contracts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"expiring_contracts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","renewed_contracts":1,"expiring_contracts":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","renewed_contracts":2,"expiring_contracts":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","renewed_contracts":3,"expiring_contracts":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","renewed_contracts":4,"expiring_contracts":30}],"maxItems":200,"minItems":1},"field":{"enum":["expiring_contracts","renewed_contracts"],"type":"string","default":"expiring_contracts"}}},"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_hylZ81-MB_JtjTpwlxVaO","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 grouped numeric summary statistics and a secondary-measure weighted mean for supplied contract renewal inventory records (expiring and renewed contracts), grouped by company and date.","exampleAgentPrompt":"Can you run a grouped numeric summary and weighted mean on this contract renewal data — I have 4 rows with company groups (group-a and group-b), dates, expiring_contracts counts, and renewed_contracts counts, and I want to analyze expiring_contracts as the primary field?","exampleUseCases":[{"title":"Renewal rate analysis by company group","prompt":"I have a list of contract records for Q4 with expiring and renewed counts per company group — can you group them and give me a numeric summary plus the weighted mean of renewed_contracts for each group?"},{"title":"Expiry pipeline breakdown for sales ops","prompt":"Here are 150 rows of contract inventory data with company_group, date, expiring_contracts, and renewed_contracts — run a grouped summary and weighted mean on expiring_contracts so I can see which groups have the most contracts coming up for renewal."},{"title":"Month-end contract inventory report","prompt":"I need a grouped numeric summary and secondary-measure weighted mean report for our contract renewal records this month — I'll supply the rows with row_id, company_group, date, expiring_contracts, and renewed_contracts, and I want expiring_contracts as the target field."}],"resultDescription":"Returns two independent analytical reports for up to 200 supplied rows: (1) a grouped numeric summary (e.g. count, min, max, mean, std dev per company_group) and (2) a secondary-measure weighted mean for the chosen field (expiring_contracts or renewed_contracts), all computed locally without external lookups.","failureModes":["Missing required fields (row_id, company_group, date, expiring_contracts, renewed_contracts) cause validation errors","Date values not matching YYYY-MM-DD pattern are rejected","More than 200 rows submitted exceeds the maximum and will be rejected","Null values in both measure fields may affect weighted mean computation","Malformed JSON or wrong data types for numeric fields return errors"],"whenToPreferThis":"Choose this endpoint when you have raw contract renewal records (up to 200 rows) and need both grouped descriptive statistics and a weighted mean computed against a chosen measure field (expiring or renewed contracts), without needing live data lookups or external enrichment. Ideal for offline batch analytics on contract pipeline snapshots at $0.01 per two-report bundle.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:40.242Z","isFirstParty":false,"canonicalSlug":"contract-renewal-inventories-grouped-numeric-summary-weighted-mean-df9a61b9"}