{"uid":"cap_VElm6XQBJhR68HWQLBltO","slug":"record-routing-analytics-trailing-mean-series-date-by-category-pivot-62818979","name":"Record Routing Analytics: Trailing Mean Series + Date-by-Category Pivot","description":"Record routing — Trailing mean series + Date by category pivot: Trailing mean series + 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-152?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"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_cPtfZF4JEDcJCN3VOLCyP","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 trailing mean time series and a date-by-category pivot table for accepted_records and rejected_records fields in supplied record routing data (up to 200 rows, two reports per call).","exampleAgentPrompt":"Can you run a trailing mean series with a window of 3 and a date-by-category pivot on my record routing data? I have accepted_records and rejected_records by date and dataset_group — here are my rows: [{\"date\":\"2026-10-01\",\"row_id\":\"r1\",\"dataset_group\":\"group-a\",\"accepted_records\":100,\"rejected_records\":5},{\"date\":\"2026-10-02\",\"row_id\":\"r2\",\"dataset_group\":\"group-b\",\"accepted_records\":200,\"rejected_records\":10}]. Use accepted_records as the field.","exampleUseCases":[{"title":"Monitor pipeline acceptance trend","prompt":"I have daily record routing stats for the last 30 days across two dataset groups. Can you compute a trailing mean series with a window of 7 for accepted_records and also pivot those records by date and group so I can see which groups are underperforming?"},{"title":"Spot rejection spikes by category","prompt":"Run a trailing mean series (window of 5) on rejected_records for my routing dataset and give me a date-by-category pivot — I want to see if any specific dataset_group has a spike in rejections this month."},{"title":"Weekly data quality summary report","prompt":"Take these 50 rows of record routing data with accepted_records and rejected_records fields and produce a rolling mean series (window of 4) plus a date-by-category pivot so I can include both in my weekly data quality report."}],"resultDescription":"Returns two analytical reports: (1) a trailing mean time series for the chosen field (accepted_records or rejected_records) computed over the specified rolling window across the supplied rows, and (2) a pivot table breaking down values by date and dataset_group category. Results are based entirely on the supplied data with no external lookups.","failureModes":["Fewer than 1 row supplied — minimum 1 row required","More than 200 rows supplied — results truncated or rejected","Invalid date format (must be YYYY-MM-DD)","Window size less than 2 or greater than 200 — validation error","Null or missing required fields (row_id, date, dataset_group) cause row-level errors","Field enum value not one of 'accepted_records' or 'rejected_records' — rejected","Payment of 0.01 USDC not completed — request blocked"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of record routing data with accepted/rejected record counts grouped by date and category, and you need both a rolling/trailing mean time series and a date-by-category pivot in a single cheap call ($0.01 USDC). It is a self-contained analytical engine with no external dependencies, making it ideal for lightweight, reproducible batch analytics on pipeline or data quality metrics without setting up your own compute.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:56.632Z","isFirstParty":false,"canonicalSlug":"record-routing-analytics-trailing-mean-series-date-by-category-pivot-62818979"}