{"uid":"cap_SrJggTFlpbkq0wXvOropG","slug":"pipeline-durations-numeric-interval-filter-daily-sum-series-4a45bc7f","name":"Pipeline Durations — Numeric Interval Filter + Daily Sum Series","description":"Pipeline durations — Numeric interval filter + Daily sum series: Numeric interval filter + Daily sum series 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-125?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_GX04G09PRA_mzIK_keDKX","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 range on a chosen metric and computes a daily sum time series, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have 150 pipeline duration records with run_seconds and processed_rows — can you filter to runs where run_seconds is between 5 and 60 seconds and give me a daily sum series for run_seconds?","exampleUseCases":[{"title":"ETL job duration range analysis","prompt":"Here are my pipeline run logs for October — filter them to only jobs where run_seconds is between 10 and 120, then show me the daily total run time as a time series."},{"title":"Processed rows daily throughput check","prompt":"I've got 200 pipeline records with processed_rows data — can you filter to rows where processed_rows is between 1000 and 50000 and compute the daily sum of processed_rows across those records?"},{"title":"Outlier exclusion before daily aggregation","prompt":"I want to exclude very short and very long pipeline runs — keep only records where run_seconds is between 30 and 300 and give me the daily summed run_seconds so I can spot trends."}],"resultDescription":"Two analytical reports: (1) the subset of pipeline records whose chosen metric (run_seconds or processed_rows) falls within the specified [minimum, maximum] interval, and (2) a daily sum series aggregating that metric by date across all input records (up to 200 rows). Both reports are computed locally with no external lookups.","failureModes":["Fewer than 1 row supplied — request rejected (minItems:1)","More than 200 rows supplied — request rejected (maxItems:200)","Invalid date format (not YYYY-MM-DD) — validation error","Field value not in enum ['run_seconds','processed_rows'] — validation error","Minimum greater than maximum — may produce empty interval filter result","Null metric values included — nulls excluded from numeric filter and sum computation"],"whenToPreferThis":"Choose this endpoint when you need both a numeric range filter and a daily sum aggregation on pipeline duration data (run_seconds or processed_rows) in a single low-cost call. It is ideal for ETL monitoring, pipeline performance analysis, and time series trend detection without requiring any external data source or prediction. Best when your dataset is already collected and has up to 200 rows; it is not suitable for live streaming data, machine learning predictions, or datasets requiring external enrichment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:41:13.051Z","isFirstParty":false,"canonicalSlug":"pipeline-durations-numeric-interval-filter-daily-sum-series-4a45bc7f"}