{"uid":"cap_HlwGMWZH2Zu97H2S86jjf","slug":"transformation-throughput-analytics-base-100-series-date-by-category-686ba2c5","name":"Transformation Throughput Analytics: Base-100 Series + Date-by-Category Pivot","description":"Transformation throughput — Base-100 series + Date by category pivot: Base-100 series + 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-167?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"},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":0}}},"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_H6GyxdEA5StTMotenjM1Y","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—a Base-100 indexed series and a date-by-category pivot table—from supplied transformation throughput records (processed_rows, duration_seconds) for up to 200 rows.","exampleAgentPrompt":"Can you generate a base-100 indexed series and a date-by-category pivot table for my transformation throughput data? I have 4 rows with dataset groups 'group-a' and 'group-b', dates from 2026-10-01 to 2026-10-04, and I want to index on the processed_rows field starting from row index 0.","exampleUseCases":[{"title":"ETL pipeline throughput trend analysis","prompt":"I have daily ETL run records with processed_rows and duration_seconds across two pipeline groups from the past month — can you index them to base 100 starting from the first day and also pivot the data by date and group so I can see trends?"},{"title":"Data engineering performance benchmarking","prompt":"Take these 50 transformation job records with their row counts and runtimes, and give me a base-100 series normalized to the first record plus a pivot table showing processed_rows broken out by dataset_group and date."},{"title":"Multi-group throughput comparison report","prompt":"I want to compare how three different dataset groups performed over the last two weeks — can you build a base-100 series and a date-by-category pivot from my throughput records using the duration_seconds field, starting from index 0?"}],"resultDescription":"Returns two analytical reports: (1) a Base-100 indexed time series normalizing the chosen metric (processed_rows or duration_seconds) relative to a specified baseline row, enabling relative trend comparison; and (2) a date-by-category pivot table grouping the selected metric by date and dataset_group, showing how different groups performed across time. Both reports are computed locally from the supplied data 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 pattern) — validation error","base_index out of range for the supplied row count — index error","Missing required fields (row_id, dataset_group, date, processed_rows, duration_seconds) — schema validation failure","Null values in the metric field may affect index calculation accuracy"],"whenToPreferThis":"Choose this endpoint when you have up to 200 transformation throughput records and need both a Base-100 normalized trend series and a date-by-category pivot in a single low-cost call ($0.01 USDC). Ideal for data engineers and pipeline analysts who want to compare relative throughput trends across dataset groups over time without building custom analytics. Prefer this over general analytics platforms when working with ETL/pipeline-specific fields (processed_rows, duration_seconds) and needing two bundled reports from local computation with no external data dependencies.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:32.932Z","isFirstParty":false,"canonicalSlug":"transformation-throughput-analytics-base-100-series-date-by-category-686ba2c5"}