{"uid":"cap_R3HOcE6k_s8EeYK-5wWi-","slug":"render-jobs-date-by-category-pivot-with-missing-value-fill-1e6c2368","name":"Render Jobs Date-by-Category Pivot with Missing-Value Fill","description":"Render jobs — Date by category pivot + Explicit missing-value fill: Date by category pivot + Explicit missing-value fill 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-189?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"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"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_SAIzZt7QpBRrW1WVZ7OVa","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":"Pivots render job records by date and asset category, filling missing values explicitly, and returns two analytical reports for up to 200 rows of render_seconds or sample_count data.","exampleAgentPrompt":"I have render job records for 'group-a' and 'group-b' spanning October 2026 — can you pivot the render_seconds by date and asset group, filling any missing cells with the median, and give me both analytical reports? I have about 150 rows.","exampleUseCases":[{"title":"Studio render time breakdown by asset group","prompt":"I've got 120 render job entries across three asset groups over the past month — can you pivot the render_seconds by date and asset category, filling gaps with the median, so I can see which groups are heaviest each day?"},{"title":"Sample count cross-tab for pipeline audit","prompt":"For our pipeline audit, I need a date-by-category pivot of sample_count across all our asset groups in this batch of 80 rows, with any missing values filled with zero — can you run both reports?"},{"title":"Missing-value analysis on creative rendering data","prompt":"Our render tracking data has some gaps — can you pivot the render_seconds by date and asset group using mean to fill in the missing values, and give me the two summary reports for these 200 records?"}],"resultDescription":"Two analytical reports: (1) a date-by-category pivot table of the selected metric (render_seconds or sample_count) with rows as dates and columns as asset groups, and (2) a version of that pivot with all missing cells explicitly filled using the chosen method (zero, mean, or median). Results cover up to 200 input rows, computed locally with no external lookups.","failureModes":["Input array exceeds 200 rows — request will be rejected or truncated","Missing required fields (row_id, asset_group, date, render_seconds, sample_count) cause row rejection","Invalid date format (non-YYYY-MM-DD) triggers schema validation error","Empty rows array returns error","Numeric values outside ±1,000,000,000,000 range fail validation","Invalid enum for field or method parameter causes schema error"],"whenToPreferThis":"Choose this endpoint when you have tabular render job records and need to reshape them into a date-by-category cross-tab with explicit handling of sparse or missing cells, specifically for render_seconds or sample_count metrics. It is best when you need two coordinated reports (raw pivot + filled pivot) in one call at very low cost ($0.01 USDC), without needing external data, live predictions, or professional assessment. Ideal for creative pipeline analytics, studio operations dashboards, or batch render audits with up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:43:08.952Z","isFirstParty":false,"canonicalSlug":"render-jobs-date-by-category-pivot-with-missing-value-fill-1e6c2368"}