{"uid":"cap_WjTNo2HscB012x97xbxQt","slug":"purchase-orders-numeric-row-ordering-secondary-measure-weighted-mean-a7818143","name":"Purchase Orders Numeric Row Ordering + Secondary-Measure Weighted Mean","description":"Purchase orders — Numeric row ordering + Secondary-measure weighted mean: Numeric row ordering + Secondary-measure weighted mean for supplied purchase orders records (ordered_amount, received_amount). 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-retail-19-121?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","store_group","date","ordered_amount","received_amount"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"store_group":{"type":"string","default":"","maxLength":80},"ordered_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"received_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","store_group":"group-a","ordered_amount":10,"received_amount":1},{"date":"2026-10-02","row_id":"row-2","store_group":"group-b","ordered_amount":20,"received_amount":2},{"date":"2026-10-03","row_id":"row-3","store_group":"group-a","ordered_amount":15,"received_amount":3},{"date":"2026-10-04","row_id":"row-4","store_group":"group-b","ordered_amount":30,"received_amount":4}],"maxItems":200,"minItems":1},"field":{"enum":["ordered_amount","received_amount"],"type":"string","default":"ordered_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_7ciK-_UhBhbyemvYN_igr","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":"Ranks purchase order rows by a numeric field and computes a secondary-measure weighted mean, returning two analytical reports for up to 200 supplied rows.","exampleAgentPrompt":"I have 4 purchase order rows for our store groups — row-1 group-a 2026-10-01 ordered 10 received 1, row-2 group-b 2026-10-02 ordered 20 received 2, row-3 group-a 2026-10-03 ordered 15 received 3, row-4 group-b 2026-10-04 ordered 30 received 4 — can you rank these rows by ordered_amount and also give me the weighted mean of received_amount weighted by ordered_amount?","exampleUseCases":[{"title":"Rank POs by order size","prompt":"I have 50 purchase order records across our store groups from last quarter — each has a row ID, store group, date, ordered amount, and received amount. Can you rank all the rows numerically by ordered_amount and also compute the weighted mean of received_amount using ordered_amount as the weights?"},{"title":"Fulfillment rate weighted summary","prompt":"Here are 120 purchase order rows for our retail locations. I want to understand which rows rank highest by received_amount and get a weighted average of ordered_amount weighted by received_amount — can you run both reports on this data?"},{"title":"Store group PO analytics","prompt":"We have purchase order data for two store groups over the past month — about 80 rows with ordered and received quantities. Please rank those rows by received_amount and give me the secondary-measure weighted mean using received_amount as the field."}],"resultDescription":"Two analytical reports: (1) the input purchase order rows sorted/ranked by the selected numeric field in ascending or descending order, and (2) a weighted mean value of the secondary measure computed using the primary field as weights — both derived from the supplied rows without any external lookups.","failureModes":["More than 200 rows submitted — request rejected with validation error","Missing required fields (row_id, date, ordered_amount, received_amount) — schema validation failure","Invalid date format not matching YYYY-MM-DD pattern — rejected","Null values in both numeric fields for all rows — weighted mean undefined","Invalid field enum value other than 'ordered_amount' or 'received_amount' — rejected"],"whenToPreferThis":"Choose this endpoint when you need both numeric row ranking and a weighted mean statistic on purchase order data in a single API call for up to 200 rows, and you want a low-cost ($0.01 USDC) batch computation with no external data dependencies. Ideal for retail supply chain analytics pipelines that process PO fulfillment data locally without needing live lookups or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:37:10.694Z","isFirstParty":false,"canonicalSlug":"purchase-orders-numeric-row-ordering-secondary-measure-weighted-mean-a7818143"}