{"uid":"cap_SUtYPpW3-P4QeuSE5puw6","slug":"pipeline-durations-analytics-grouped-numeric-summary-date-by-category-3e958004","name":"Pipeline Durations Analytics — Grouped Numeric Summary + Date by Category Pivot","description":"Pipeline durations — Grouped numeric summary + Date by category pivot: Grouped numeric summary + Date by category pivot 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-097?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_n1MLMm5qSXv2DhWr2yGyB","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":"Generates two analytical reports (grouped numeric summary and date-by-category pivot) for pipeline duration records including run_seconds and processed_rows, using up to 200 supplied rows.","exampleAgentPrompt":"Can you run two analytics reports on these pipeline records — a grouped numeric summary and a date-by-category pivot — focusing on run_seconds? I have 8 rows with dataset_group labels like 'group-a' and 'group-b' and dates ranging from 2026-10-01 to 2026-10-08.","exampleUseCases":[{"title":"Pipeline performance review by team","prompt":"I have 50 pipeline run records with columns row_id, dataset_group, date, run_seconds, and processed_rows. Can you give me a grouped numeric summary and a date-by-category pivot for run_seconds so I can see which groups are slowest?"},{"title":"ETL batch throughput analysis","prompt":"Analyze these 120 ETL pipeline records for me — I want both a grouped numeric summary and a date-by-category pivot focused on processed_rows, broken down by our dataset_group labels across October 2026."},{"title":"Weekly pipeline audit report","prompt":"Here are 200 rows of pipeline execution logs with run_seconds and dataset_group. Can you generate a grouped stats summary plus a pivot of run_seconds by date and category so I can spot any outliers this week?"}],"resultDescription":"Two analytical reports returned together: (1) a grouped numeric summary with statistics like min, max, mean, and count for the selected field (run_seconds or processed_rows) broken down by dataset_group; (2) a date-by-category pivot table cross-tabulating the selected metric by date and dataset_group category. No external data is fetched; all analysis is performed on the supplied rows.","failureModes":["Fewer than 1 row supplied returns an error","More than 200 rows supplied exceeds the limit and will be rejected","Missing required fields (row_id, dataset_group, date, run_seconds, processed_rows) cause validation failure","Invalid date format (not YYYY-MM-DD) causes schema rejection","Null values in the selected numeric field may reduce summary accuracy or exclude rows from pivot","Payment of 0.01 USDC not fulfilled causes 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you have pipeline execution records with run duration and row-count metrics and need both a grouped statistical summary and a date-based category pivot in a single call. It is ideal for data engineers and analytics workflows that want quick offline analysis of up to 200 rows without setting up their own aggregation logic. Prefer this over general analytics tools when you want two complementary views — grouped stats and time-series pivot — delivered together cheaply for supplied data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:39:06.375Z","isFirstParty":false,"canonicalSlug":"pipeline-durations-analytics-grouped-numeric-summary-date-by-category-3e958004"}