{"uid":"cap_1YHzSkAaOGr_sVF8ezwWi","slug":"shipment-costs-date-by-category-pivot-311f6513","name":"Shipment Costs Date-by-Category Pivot","description":"Shipment costs - Date by category pivot: Date by category pivot for Shipment costs. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded date by category pivot deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-shipment-costs-pivot?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","carrier","date","weight_kg","shipping_cost"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"carrier":{"type":"string","default":"","maxLength":80},"weight_kg":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"shipping_cost":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","carrier":"group-a","weight_kg":10,"shipping_cost":1},{"date":"2026-10-02","row_id":"row-2","carrier":"group-b","weight_kg":20,"shipping_cost":2},{"date":"2026-10-03","row_id":"row-3","carrier":"group-a","weight_kg":15,"shipping_cost":3},{"date":"2026-10-04","row_id":"row-4","carrier":"group-b","weight_kg":30,"shipping_cost":4}],"maxItems":200,"minItems":1},"field":{"enum":["weight_kg","shipping_cost"],"type":"string","default":"weight_kg"}}},"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_Z2lV_1ANTHCElgLkgir5D","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":"Pivots shipment cost records by date and carrier category, aggregating up to 200 rows of shipping data into a cross-tabulated summary.","exampleAgentPrompt":"Pivot my shipment cost records by date and carrier — I have 4 rows with carriers group-a and group-b, dates from 2026-10-01 to 2026-10-04, and I want to see the shipping_cost field cross-tabulated.","exampleUseCases":[{"title":"Weekly carrier cost comparison","prompt":"I have shipping records for last week across two carriers, FastFreight and EcoShip, with dates and costs per shipment — can you pivot them by date and carrier so I can see how each carrier's costs changed day by day?"},{"title":"Weight distribution across shipping groups","prompt":"Take these 50 shipment records with dates, carrier groups, and weight_kg values and give me a pivot table showing total weight by date and carrier group."},{"title":"Monthly logistics cost breakdown","prompt":"I've got 200 rows of shipment data from October, each with a date, a carrier name, and a shipping_cost — pivot it so I get a date-by-carrier matrix of costs for my monthly logistics report."}],"resultDescription":"A date-by-category (carrier) pivot table aggregating the selected numeric field (weight_kg or shipping_cost) across up to 200 input shipment records, with dates as one axis and carrier categories as the other.","failureModes":["Input array exceeds 200 items — request rejected","Missing required fields (row_id, carrier, date, weight_kg, shipping_cost) on any row — validation error","Invalid date format (must match YYYY-MM-DD) — pattern validation failure","Empty rows array — minimum 1 item required","Invalid field enum value — must be weight_kg or shipping_cost"],"whenToPreferThis":"Choose this endpoint when you need a structured date-by-carrier pivot of shipment cost or weight data locally, without sending data to an external enrichment or forecasting service. Ideal for logistics analytics agents processing batches up to 200 records that need fast, deterministic aggregation with no side effects.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-12T00:43:08.703Z","isFirstParty":false,"canonicalSlug":"shipment-costs-date-by-category-pivot-311f6513"}