{"uid":"cap_XLmsf0R9OZOAkajVP3k3r","slug":"record-routing-analytics-two-measure-correlation-date-by-category-pivot-5b94e1a5","name":"Record Routing Analytics: Two-Measure Correlation + Date-by-Category Pivot","description":"Record routing — Two-measure correlation + Date by category pivot: Two-measure correlation + Date by category pivot 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-182?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_W_25ndzdfULoPBOPEB0kJ","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 a two-measure correlation (accepted vs rejected records) and a date-by-category pivot table for up to 200 supplied record routing rows in a single paid call.","exampleAgentPrompt":"Run a two-measure correlation between accepted_records and rejected_records plus a date-by-category pivot on this record routing data: group-a had 10 accepted and 1 rejected on 2026-10-01, group-b had 20 accepted and 2 rejected on 2026-10-02, group-a had 15 accepted and 3 rejected on 2026-10-03, and group-b had 30 accepted and 4 rejected on 2026-10-04.","exampleUseCases":[{"title":"Pipeline acceptance rate audit","prompt":"I have daily record routing logs for two dataset groups over the past week — can you run a correlation between accepted_records and rejected_records and pivot the counts by date and group so I can see which groups are drifting?"},{"title":"Data quality dashboard prep","prompt":"Compute a two-measure correlation and a date-by-category pivot for my record routing data across group-a and group-b using accepted_records as the primary field — I need both reports to populate my weekly data quality dashboard."},{"title":"Routing anomaly investigation","prompt":"Something looks off in our routing pipeline for October — take these 50 rows with accepted_records and rejected_records per dataset group and give me a correlation analysis plus a pivot by date so I can spot which group and day is causing the spike in rejections."}],"resultDescription":"Returns two independent analytical reports: (1) a two-measure correlation analysis between accepted_records and rejected_records across the supplied rows, and (2) a date-by-category pivot table grouping record counts by date and dataset_group. Both reports are computed locally on the supplied data with no external lookups. Up to 200 rows supported per call.","failureModes":["Fewer than 1 row submitted — validation error","More than 200 rows submitted — request rejected","Row missing required fields (row_id, date, accepted_records, rejected_records) — schema validation failure","Date field not in YYYY-MM-DD format — pattern validation error","Numeric values outside allowed range (±1,000,000,000,000) — validation error","Insufficient variance in data for meaningful correlation — degenerate result returned"],"whenToPreferThis":"Choose this endpoint when you need both a two-measure correlation and a date-by-category pivot on record routing data (accepted/rejected counts) in a single low-cost call ($0.01 USDC). It is ideal for offline batch analytics on up to 200 rows of supplied data where no live lookup, prediction, or external enrichment is needed. Prefer alternatives if you need more than 200 rows, a single report type, or metrics beyond accepted/rejected record counts.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:53:27.605Z","isFirstParty":false,"canonicalSlug":"record-routing-analytics-two-measure-correlation-date-by-category-pivot-5b94e1a5"}