{"uid":"cap_z59TLPcPQACeFOwRXQ5xO","slug":"render-jobs-numeric-interval-filter-date-by-category-pivot-a913a6da","name":"Render Jobs Numeric Interval Filter + Date by Category Pivot","description":"Render jobs — Numeric interval filter + Date by category pivot: Numeric interval filter + Date by category pivot for supplied render jobs records (render_seconds, sample_count). 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-creative-02-133?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","render_seconds","sample_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"asset_group":{"type":"string","default":"","maxLength":80},"sample_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"render_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","asset_group":"group-a","sample_count":1,"render_seconds":10},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","sample_count":2,"render_seconds":20},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","sample_count":3,"render_seconds":15},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","sample_count":4,"render_seconds":30}],"maxItems":200,"minItems":1},"field":{"enum":["render_seconds","sample_count"],"type":"string","default":"render_seconds"},"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_dT2fVg5h7iFo191W26A70","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 supplied render job records (render_seconds, sample_count), returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have render job records with asset groups and dates — can you filter for jobs where render_seconds is between 10 and 50, and also give me a pivot of render_seconds by date and asset_group? Here are up to 200 rows: row-1 on 2026-10-01, group-a, 10 render_seconds, 1 sample_count; row-2 on 2026-10-02, group-b, 20 render_seconds, 2 sample_count.","exampleUseCases":[{"title":"Identify slow render jobs by asset group","prompt":"Can you filter my render job records to only show jobs where render_seconds is between 30 and 200, and then pivot the results by date and asset_group? I want to see which groups are consistently slow."},{"title":"Sample count range analysis across categories","prompt":"I need to filter my render jobs where sample_count falls between 5 and 100, and also get a date-by-category breakdown of sample_count across all my asset groups — here are 150 rows of job data."},{"title":"Daily render time pivot for production review","prompt":"For our weekly production review, can you take these render job records and produce a date-by-category pivot of render_seconds grouped by asset_group, while also filtering to only include jobs where render_seconds is between 0 and 60?"}],"resultDescription":"Two analytical reports: (1) a numeric interval filter report showing render job rows where the selected field (render_seconds or sample_count) falls within the specified minimum–maximum range, and (2) a date-by-category pivot table aggregating the selected metric by date and asset_group. Both reports cover the supplied dataset of up to 200 rows.","failureModes":["Rows array is empty or missing — validation error","More than 200 rows supplied — request rejected","date field does not match YYYY-MM-DD pattern — schema validation failure","minimum value is greater than maximum value — may return empty filter results","render_seconds or sample_count values outside allowed numeric range — schema rejection","Required fields (row_id, asset_group, date) missing from any row — validation error"],"whenToPreferThis":"Choose this endpoint when you need both a range-based numeric filter AND a date-by-category pivot on render job data in a single paid call. It is purpose-built for render pipeline analytics (render_seconds, sample_count) and returns two reports simultaneously, making it more efficient than running separate filter and pivot operations. Best when your dataset is up to 200 rows and you need fast, local analytical results without external lookups or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:43:28.842Z","isFirstParty":false,"canonicalSlug":"render-jobs-numeric-interval-filter-date-by-category-pivot-a913a6da"}