{"uid":"cap_e0bnKiExmWfiLuj9eRkIl","slug":"render-jobs-grouped-numeric-summary-date-by-category-pivot-be696e41","name":"Render Jobs Grouped Numeric Summary + Date by Category Pivot","description":"Render jobs — Grouped numeric summary + Date by category pivot: Grouped numeric summary + 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-097?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"}}},"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_v2CJf_FeTafcynIpbPXay","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":"Produces two analytical reports for render job records: a grouped numeric summary and a date-by-category pivot table for render_seconds or sample_count fields.","exampleAgentPrompt":"Analyze these render job records and give me both a grouped numeric summary and a date-by-category pivot for render_seconds: row-1 (group-a, 2026-10-01, 10s, 1 sample), row-2 (group-b, 2026-10-02, 20s, 2 samples), row-3 (group-a, 2026-10-03, 15s, 3 samples), row-4 (group-b, 2026-10-04, 30s, 4 samples).","exampleUseCases":[{"title":"Studio render time breakdown by group","prompt":"I have render job logs for our animation studio — can you group the render_seconds by asset_group and also pivot them by date? Here are the rows: row-1 (group-a, 2026-10-01, 120s, 5 samples), row-2 (group-b, 2026-10-01, 200s, 8 samples), row-3 (group-a, 2026-10-02, 95s, 4 samples), row-4 (group-b, 2026-10-02, 310s, 10 samples)."},{"title":"Sample count trends across asset groups","prompt":"Run a grouped numeric summary and date pivot on sample_count for these render jobs: row-1 (vfx-a, 2026-11-01, 45s, 12 samples), row-2 (vfx-b, 2026-11-01, 60s, 18 samples), row-3 (vfx-a, 2026-11-02, 30s, 9 samples), row-4 (vfx-b, 2026-11-02, 75s, 22 samples) — I want to see how sample counts differ by group over those two days."},{"title":"Weekly render workload comparison","prompt":"Can you give me both reports — grouped summary and date-by-category pivot — for render_seconds across these weekly render job records? row-1 (batch-1, 2026-09-01, 500s, 20 samples), row-2 (batch-2, 2026-09-01, 750s, 35 samples), row-3 (batch-1, 2026-09-07, 420s, 18 samples), row-4 (batch-2, 2026-09-07, 680s, 30 samples)."}],"resultDescription":"Returns two analytical reports: (1) a grouped numeric summary aggregating render_seconds or sample_count by asset_group (e.g. min, max, mean, sum, count), and (2) a date-by-category pivot table showing how the selected metric varies across asset groups over time. Both reports are computed from the supplied row data using local analytical engines, with no external lookups.","failureModes":["Empty or missing rows array returns an error","More than 200 rows submitted exceeds the limit and will be rejected","Invalid date format (not YYYY-MM-DD) causes validation failure","Null values in render_seconds or sample_count may affect aggregation results","Invalid field enum value (not 'render_seconds' or 'sample_count') causes schema rejection","row_id missing or empty string triggers required field validation error"],"whenToPreferThis":"Choose this endpoint when you have render job records with asset group and date dimensions and need both a grouped numeric summary and a pivot table in a single call for up to 200 rows. It is ideal for creative pipeline analytics where you want to compare render_seconds or sample_count across groups and dates without building your own aggregation logic. Prefer it over general analytics APIs when the data is already structured with asset_group and date fields matching this schema.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:43:37.932Z","isFirstParty":false,"canonicalSlug":"render-jobs-grouped-numeric-summary-date-by-category-pivot-be696e41"}