{"uid":"cap_yOXmbbjAbc8GfmJfEE6sC","slug":"record-routing-analytics-category-frequencies-secondary-measure-2deae373","name":"Record Routing Analytics — Category Frequencies + Secondary-Measure Weighted Mean","description":"Record routing — Category frequencies + Secondary-measure weighted mean: Category frequencies + Secondary-measure weighted mean for supplied record routing records (accepted_records, rejected_records). 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-analytics-19-109?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","accepted_records","rejected_records"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"accepted_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"rejected_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","accepted_records":10,"rejected_records":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","accepted_records":20,"rejected_records":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","accepted_records":15,"rejected_records":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","accepted_records":30,"rejected_records":4}],"maxItems":200,"minItems":1},"field":{"enum":["accepted_records","rejected_records"],"type":"string","default":"accepted_records"}}},"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_3zRsFCD08vItF8dRI07Gj","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 category-level frequencies and a secondary-measure weighted mean for accepted/rejected record routing data, returning two local analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you run a category-frequency and weighted-mean analysis on my record routing data? I have up to 50 rows with fields: row_id, dataset_group, date, accepted_records, and rejected_records — use accepted_records as the primary measure field.","exampleUseCases":[{"title":"ETL pipeline rejection audit","prompt":"I have daily record routing logs for two groups — group-alpha and group-beta — across 30 days. Can you calculate the category frequencies and the weighted mean of rejected_records across those groups so I can see which group has the worst rejection rate?"},{"title":"Data quality dashboard report","prompt":"Generate a frequency breakdown and a weighted mean summary for my accepted_records across three dataset groups for October 2026 — I have about 80 rows of routing data with row IDs, dates, and group labels."},{"title":"Routing pipeline acceptance analysis","prompt":"For my routing pipeline audit, can you analyze these 120 rows of record routing data — each with a date, dataset_group, accepted_records, and rejected_records — and give me both the category frequencies and the secondary-measure weighted mean using rejected_records as the field?"}],"resultDescription":"Returns two independent analytical reports: (1) category frequencies showing how often each dataset_group appears across the supplied rows, and (2) a weighted mean of the chosen secondary measure (accepted_records or rejected_records) computed using local analytical engines — no external lookups or predictions. Both reports cover up to 200 input rows.","failureModes":["Fewer than 1 row supplied — minItems validation failure","Row missing required fields (row_id, dataset_group, date, accepted_records, rejected_records) — schema validation error","Date field does not match YYYY-MM-DD pattern — pattern validation error","More than 200 rows supplied — maxItems exceeded error","Numeric values outside ±1,000,000,000,000 range — bounds validation error","Invalid field enum value (must be 'accepted_records' or 'rejected_records') — enum validation error"],"whenToPreferThis":"Choose this endpoint when you need two quick local analytical summaries — category frequency distribution and a weighted mean of a numeric routing measure — on a batch of up to 200 record routing rows, without requiring live data lookup, external API calls, or prediction models. Ideal for lightweight ETL auditing, data quality dashboards, or pipeline monitoring tasks where cost efficiency ($0.01 USDC for both reports) matters.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:47:59.600Z","isFirstParty":false,"canonicalSlug":"record-routing-analytics-category-frequencies-secondary-measure-2deae373"}