{"uid":"cap_Kjf4gyW0bSV8ZChPa6wz-","slug":"pipeline-durations-analytics-numeric-row-ordering-daily-sum-series-df2f320e","name":"Pipeline Durations Analytics — Numeric Row Ordering + Daily Sum Series","description":"Pipeline durations — Numeric row ordering + Daily sum series: Numeric row ordering + 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-114?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"}}},"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_GbIz2L1CII50BW1OQs9dn","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 numeric row ordering and daily sum time series for pipeline duration records (run_seconds and processed_rows) across up to 200 rows in two bundled analytical reports.","exampleAgentPrompt":"I have a list of pipeline run records with dates, run_seconds, and processed_rows — can you give me numeric row ordering and a daily sum series for the run_seconds field across these up to 200 rows?","exampleUseCases":[{"title":"ETL job duration ranking","prompt":"I've got logs from our nightly ETL jobs with row IDs, dates, and run_seconds — can you rank those rows numerically by duration and also give me a daily total of run_seconds so I can see which days had the heaviest pipeline load?"},{"title":"Daily throughput time series","prompt":"Here are 150 records from our data pipeline runs, each with a date, dataset_group, and processed_rows count. Can you produce a numeric row ordering and a daily sum series for processed_rows so I can track throughput trends over time?"},{"title":"Pipeline performance audit","prompt":"I need to audit our pipeline performance — I have records for about 80 runs across two dataset groups with run_seconds values. Can you give me numeric row ordering plus a daily aggregated sum of run_seconds for the full date range?"}],"resultDescription":"Two analytical reports: (1) a numeric row ordering of the supplied pipeline duration records ranked by the chosen metric field (run_seconds or processed_rows), and (2) a daily sum time series aggregating the chosen metric by date across all input rows. Reports are computed locally with no external data lookup.","failureModes":["Input array exceeds 200 rows — rejected with validation error","Missing required fields (row_id, date, dataset_group, run_seconds, processed_rows) on any row — validation failure","Invalid date format (not YYYY-MM-DD) — pattern validation error","Numeric field values outside allowed range (±1,000,000,000,000) — rejected","Empty rows array (minItems:1 not met) — validation error","Invalid field enum value (must be run_seconds or processed_rows) — rejected"],"whenToPreferThis":"Use this endpoint when you have up to 200 pipeline duration records and need both a ranked row ordering and a daily sum time series in a single low-cost call ($0.01 USDC for both reports). Prefer it over building custom analytics when you want fast, bundled computation on supplied data without any external lookup or live data dependency. It is best suited for ETL/data engineering monitoring, pipeline throughput auditing, and performance trend analysis over date-stamped run records.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-16T06:55:07.480Z","isFirstParty":false,"canonicalSlug":"pipeline-durations-analytics-numeric-row-ordering-daily-sum-series-df2f320e"}