{"uid":"cap_U1f_es7LuGhc4mnXGKpbt","slug":"transformation-throughput-analytics-grouped-numeric-summary-date-by-bd783548","name":"Transformation Throughput Analytics — Grouped Numeric Summary + Date by Category Pivot","description":"Transformation throughput — Grouped numeric summary + Date by category pivot: Grouped numeric summary + Date by category pivot for supplied transformation throughput records (processed_rows, duration_seconds). 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-13-097?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","processed_rows","duration_seconds"],"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},"processed_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"duration_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","processed_rows":10,"duration_seconds":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","processed_rows":20,"duration_seconds":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","processed_rows":15,"duration_seconds":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","processed_rows":30,"duration_seconds":4}],"maxItems":200,"minItems":1},"field":{"enum":["processed_rows","duration_seconds"],"type":"string","default":"processed_rows"}}},"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_Ra1WpEzVaJ12h7OnjU12r","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 local analytical reports for transformation throughput data: a grouped numeric summary and a date-by-category pivot, for up to 200 rows of processed_rows and duration_seconds metrics.","exampleAgentPrompt":"I have up to 200 transformation throughput records with dataset_group, date, processed_rows, and duration_seconds columns — can you run a grouped numeric summary and a date-by-category pivot on the processed_rows field for me?","exampleUseCases":[{"title":"ETL pipeline throughput review","prompt":"I've got logs from our ETL jobs with columns for dataset_group, date, processed_rows, and duration_seconds — can you give me a grouped summary and a date-by-category pivot on processed_rows so I can see which groups processed the most data?"},{"title":"Pipeline duration benchmarking by group","prompt":"Here are 150 transformation job records with row IDs, dataset groups, dates, and duration_seconds — run a grouped numeric summary and a date-by-category pivot on the duration_seconds field so I can benchmark how long each group's jobs are taking."},{"title":"Data team daily throughput report","prompt":"Can you analyze our daily transformation throughput records — I have dataset_group, date, and processed_rows for about 80 rows — and produce a grouped numeric summary plus a date-pivot by category?"}],"resultDescription":"Returns two analytical reports: (1) a grouped numeric summary with statistics (e.g. count, sum, mean, min, max) for the selected metric (processed_rows or duration_seconds) broken down by dataset_group, and (2) a date-by-category pivot table showing the selected metric values across dates and groups. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Fewer than 1 row supplied — returns validation error","More than 200 rows supplied — request rejected due to row limit","Missing required fields (row_id, dataset_group, date, processed_rows, duration_seconds) — schema validation failure","Invalid date format (not YYYY-MM-DD) — pattern validation error","field selector not one of 'processed_rows' or 'duration_seconds' — enum validation error","All null values for selected metric — summary may return empty or zero statistics"],"whenToPreferThis":"Choose this endpoint when you have transformation throughput records (ETL or data pipeline jobs) and need both a grouped statistical summary and a date-by-category pivot in a single low-cost call. It is ideal for offline/supplied-data analytics where no live lookup or external data is needed, and when your dataset fits within 200 rows. Prefer this over general analytics tools when you specifically need grouped numeric summaries and date pivots together for pipeline throughput metrics (processed_rows or duration_seconds).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:13.793Z","isFirstParty":false,"canonicalSlug":"transformation-throughput-analytics-grouped-numeric-summary-date-by-bd783548"}