{"uid":"cap_eQqYM8OzQ0i-z6KVtYC7F","slug":"commercial-proposal-comparisons-category-frequencies-date-by-category-0638c145","name":"Commercial Proposal Comparisons — Category Frequencies + Date by Category Pivot","description":"Commercial proposal comparisons — Category frequencies + Date by category pivot: Category frequencies + Date by category pivot 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-110?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"}}},"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_ixGa7S7FlSJFr3Gj8TzSz","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":"Generates two analytical reports — category frequencies and a date-by-category pivot — for supplied commercial proposal comparison records containing quoted amounts and delivery days.","exampleAgentPrompt":"I have 50 commercial proposal records with vendor groups, dates, quoted amounts, and delivery days — can you run a category frequency breakdown and a date-by-category pivot on the quoted_amount field for me?","exampleUseCases":[{"title":"Vendor bid frequency analysis","prompt":"I've got a list of 120 supplier bids with company groups, dates, quoted amounts, and delivery days. Can you show me how frequently each company group appears and pivot the quoted amounts by date and group?"},{"title":"Delivery timeline comparison by supplier","prompt":"Here are 80 proposal records from our RFP process — each has a vendor group, submission date, and delivery_days estimate. Run a category frequency count and a date-by-category pivot on the delivery_days field so I can see patterns across groups."},{"title":"Procurement cost breakdown over time","prompt":"I need to analyze these 150 commercial proposals — they have row IDs, company groups, dates, and quoted amounts. Give me both a frequency table of the company groups and a pivot showing quoted_amount totals by date and category."}],"resultDescription":"Returns two analytical reports derived from the supplied rows: (1) a category frequencies table showing how often each company_group value appears, and (2) a date-by-category pivot showing the selected numeric field (quoted_amount or delivery_days) aggregated across dates and company groups. All computation is local with no external lookups.","failureModes":["Fewer than 1 row supplied — request rejected","More than 200 rows supplied — exceeds limit, request rejected","Missing required fields (row_id, company_group, date, quoted_amount, delivery_days) — validation error","Date field not in YYYY-MM-DD format — pattern validation failure","Null values in numeric fields may affect pivot aggregation","Invalid field enum value (not quoted_amount or delivery_days) — schema error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 commercial proposal records and need both a category frequency distribution and a date-by-category pivot in a single low-cost call ($0.01 USDC). Ideal for procurement analytics, supplier comparison, or RFP analysis where you want offline computation with no external data dependencies. Best when your data already contains company_group, date, quoted_amount, and delivery_days fields and you need structured tabular summaries quickly.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:43:36.341Z","isFirstParty":false,"canonicalSlug":"commercial-proposal-comparisons-category-frequencies-date-by-category-0638c145"}