{"uid":"cap_N5eIZkIv2UYr53ZFG5ZmC","slug":"pipeline-durations-analytics-numeric-interval-filter-weighted-mean-9efb4023","name":"Pipeline Durations Analytics: Numeric Interval Filter + Weighted Mean","description":"Pipeline durations — Numeric interval filter + Secondary-measure weighted mean: Numeric interval filter + Secondary-measure weighted mean for supplied pipeline durations records (run_seconds, processed_rows). 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-05-132?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","run_seconds","processed_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"run_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"processed_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","run_seconds":10,"dataset_group":"group-a","processed_rows":1},{"date":"2026-10-02","row_id":"row-2","run_seconds":20,"dataset_group":"group-b","processed_rows":2},{"date":"2026-10-03","row_id":"row-3","run_seconds":15,"dataset_group":"group-a","processed_rows":3},{"date":"2026-10-04","row_id":"row-4","run_seconds":30,"dataset_group":"group-b","processed_rows":4}],"maxItems":200,"minItems":1},"field":{"enum":["run_seconds","processed_rows"],"type":"string","default":"run_seconds"},"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_hyafBQiTeU4b5_tjFPYYv","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":"Filters pipeline duration records by a numeric interval and computes a secondary-measure weighted mean, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have 150 pipeline run records with run_seconds and processed_rows columns — filter them to only include rows where run_seconds is between 10 and 500, then give me a weighted mean of processed_rows using run_seconds as the weight, as two separate analytical reports.","exampleUseCases":[{"title":"ETL pipeline performance band analysis","prompt":"Here are my 80 ETL pipeline records with run_seconds and processed_rows. Filter down to runs where run_seconds falls between 30 and 300, and compute the weighted mean of processed_rows weighted by run_seconds across those filtered records — I need both reports."},{"title":"Outlier exclusion for weighted throughput summary","prompt":"I want to exclude very fast and very slow jobs from my pipeline stats. Take these 120 pipeline records, keep only the ones where processed_rows is between 1000 and 50000, and return the weighted mean of run_seconds weighted by processed_rows in the two-report format."},{"title":"Daily pipeline duration reporting for a dataset group","prompt":"Can you analyze these 60 pipeline duration records for October 2026? Filter to rows where run_seconds is between 5 and 200, then compute the weighted mean of processed_rows, and give me both analytical reports so I can compare group-a versus group-b performance."}],"resultDescription":"Returns two independent analytical reports: one summarizing the interval-filtered subset of pipeline duration records (rows where the selected field falls within [minimum, maximum]), and one providing a secondary-measure weighted mean computed over those records — all processed locally with no external lookups.","failureModes":["Empty rows array or fewer than 1 row returns an error","More than 200 rows submitted exceeds the row limit","Invalid date format (not YYYY-MM-DD) causes schema validation failure","minimum greater than maximum results in empty filter output or error","Null values in run_seconds or processed_rows may affect weighted mean calculation","field enum value not matching 'run_seconds' or 'processed_rows' causes rejection","Payment of 0.01 USDC not provided results in 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you have pipeline execution records (with run_seconds and processed_rows fields) and need to simultaneously filter them to a numeric interval AND compute a weighted mean of the secondary measure — delivered as two structured reports in one call for $0.01 USDC. Ideal for data engineers doing ad-hoc performance analysis on up to 200 pipeline runs without building custom analytics infrastructure.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:37.983Z","isFirstParty":false,"canonicalSlug":"pipeline-durations-analytics-numeric-interval-filter-weighted-mean-9efb4023"}