{"uid":"cap_sKlDvADq8u6nrs57H-Vk0","slug":"transformation-throughput-analytics-numeric-interval-filter-date-by-be89897f","name":"Transformation Throughput Analytics: Numeric Interval Filter + Date by Category Pivot","description":"Transformation throughput — Numeric interval filter + Date by category pivot: Numeric interval filter + 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-133?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"},"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_sKwSpuk-a3gyTaLAmo1Uw","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":"Applies a numeric interval filter and a date-by-category pivot to up to 200 transformation throughput records (processed_rows, duration_seconds), returning two analytical reports.","exampleAgentPrompt":"I have 150 transformation throughput records with processed_rows and duration_seconds — can you filter them to only include records where processed_rows is between 10 and 500, and also pivot the data by date and dataset_group so I can see category breakdowns?","exampleUseCases":[{"title":"ETL batch job throughput review","prompt":"Here are my ETL run records for last month — filter them to show only jobs where duration_seconds is between 5 and 120, and also give me a pivot of processed_rows by date and dataset group so I can spot which groups were busiest each day."},{"title":"Pipeline anomaly triage by interval","prompt":"I've got 80 transformation throughput rows and I want to flag anything where processed_rows falls outside the range of 0 to 1000 — can you run the numeric interval filter on processed_rows with minimum 0 and maximum 1000, plus a date-by-category pivot to see the group breakdown?"},{"title":"Cross-team data volume comparison","prompt":"Can you analyze these 200 transformation records across our three dataset groups — apply a numeric filter on processed_rows between 50 and 5000 and generate a date-by-category pivot so my team can compare throughput volumes across groups over time?"}],"resultDescription":"Two local analytical reports: (1) a numeric interval filter report listing transformation records where the chosen field (processed_rows or duration_seconds) falls within the specified minimum–maximum range, and (2) a date-by-category pivot table aggregating the throughput metrics by date and dataset_group. No external data is fetched; all computation runs on the supplied rows.","failureModes":["Fewer than 1 row supplied — request rejected","More than 200 rows supplied — exceeds row limit","Invalid date format (not YYYY-MM-DD) on any row — schema validation error","Field value not in enum ['processed_rows','duration_seconds'] — schema validation error","Minimum greater than maximum — may return empty filter result with no error","Null values in numeric fields — nulls may be excluded from interval filter silently"],"whenToPreferThis":"Choose this endpoint when you have up to 200 transformation throughput records with processed_rows and duration_seconds fields and need both a numeric range filter and a date-by-category pivot in a single low-cost call. It is ideal for local, offline analytics on ETL or data pipeline run logs where no external lookup or prediction is needed. Prefer it over general analytics platforms when you want a cheap ($0.01 USDC), deterministic, dual-report output without setting up your own analytical engine.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:16.811Z","isFirstParty":false,"canonicalSlug":"transformation-throughput-analytics-numeric-interval-filter-date-by-be89897f"}