{"uid":"cap_j3w34W0VnEdErBIsqKtK8","slug":"record-routing-analytics-numeric-interval-filter-trailing-mean-series-f3b641f4","name":"Record Routing Analytics: Numeric Interval Filter + Trailing Mean Series","description":"Record routing — Numeric interval filter + Trailing mean series: Numeric interval filter + Trailing mean series 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-126?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},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_5ViabiaivwSPJfsyiZV-A","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":"Applies a numeric interval filter and computes a trailing mean time series on accepted_records or rejected_records fields from supplied record routing data, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Analyze my record routing data using the numeric interval filter (minimum 0, maximum 500) on accepted_records with a trailing mean window of 5: rows are group-a on 2026-10-01 with 10 accepted and 1 rejected, group-b on 2026-10-02 with 20 accepted and 2 rejected, group-a on 2026-10-03 with 450 accepted and 3 rejected.","exampleUseCases":[{"title":"ETL pipeline rejection spike detection","prompt":"I have 30 days of ETL record routing data and want to filter rows where rejected_records fall between 5 and 100, then see a trailing mean over a window of 7 so I can spot unusual rejection spikes — can you run both reports on my dataset?"},{"title":"Accepted records trend analysis by group","prompt":"Run an interval filter keeping only rows where accepted_records are between 10 and 1000, and compute a trailing mean with window size 3 on accepted_records across these dataset groups: group-a had 15 accepted on Oct 1, group-b had 80 on Oct 2, group-a had 500 on Oct 3."},{"title":"Data quality threshold monitoring","prompt":"I want to check which of my record routing rows fall within an acceptable range of 0 to 200 for rejected_records, and also see the trailing rolling average with a window of 4 — here are my 10 rows with dates and group names."}],"resultDescription":"Returns two analytical reports: (1) a filtered list of rows where the chosen field (accepted_records or rejected_records) falls within the specified minimum–maximum interval, and (2) a trailing mean time series computed over the chosen field using the specified window size. Both reports are derived purely from the supplied data, with no external lookups or predictions.","failureModes":["Fewer than 1 row supplied returns an error","More than 200 rows submitted exceeds the row limit","Window size larger than the number of rows may produce sparse or empty trailing mean output","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Minimum value greater than maximum value may return an empty filtered set","Null values in the target field may be excluded from interval filtering and mean calculation"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of time-stamped record routing data with accepted_records and rejected_records fields and need both a numeric range filter and a rolling mean analysis in a single low-cost call. It is ideal for lightweight ETL monitoring, data quality checks, or pipeline analytics where no external data lookup or prediction is required. It is not suitable for real-time streaming, datasets exceeding 200 rows, or analyses requiring external data enrichment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:54:01.431Z","isFirstParty":false,"canonicalSlug":"record-routing-analytics-numeric-interval-filter-trailing-mean-series-f3b641f4"}