{"uid":"cap_Bzpmnwhp281iCYBSVRNHf","slug":"compositing-graphs-category-frequencies-date-by-category-pivot-fbcb47c3","name":"Compositing Graphs — Category Frequencies + Date by Category Pivot","description":"Compositing graphs — Category frequencies + Date by category pivot: Category frequencies + Date by category pivot for supplied compositing graphs records (node_count, render_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-creative-09-110?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","node_count","render_seconds"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"node_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"asset_group":{"type":"string","default":"","maxLength":80},"render_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","node_count":10,"asset_group":"group-a","render_seconds":1},{"date":"2026-10-02","row_id":"row-2","node_count":20,"asset_group":"group-b","render_seconds":2},{"date":"2026-10-03","row_id":"row-3","node_count":15,"asset_group":"group-a","render_seconds":3},{"date":"2026-10-04","row_id":"row-4","node_count":30,"asset_group":"group-b","render_seconds":4}],"maxItems":200,"minItems":1},"field":{"enum":["node_count","render_seconds"],"type":"string","default":"node_count"}}},"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_EW-wOLgluixYnu0b-w_lo","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":"Runs two analytical reports on compositing graph records: category frequency counts by asset_group and a date-by-category pivot for node_count or render_seconds, covering up to 200 rows.","exampleAgentPrompt":"Can you analyze my compositing graph records and give me both an asset_group frequency breakdown and a pivot of node_count by date and asset_group? Here are up to 200 rows with fields row_id, asset_group, date, node_count, and render_seconds — field to analyze is node_count.","exampleUseCases":[{"title":"Render farm asset group audit","prompt":"I have logs from our compositing pipeline with asset groups, dates, node counts, and render times for about 150 jobs. Can you tell me how frequently each asset group appears and also show me a pivot of node_count broken down by date and asset_group?"},{"title":"Render time trend by category","prompt":"Here are 200 rows of compositing graph data with asset groups and daily render_seconds. Run a frequency count on the asset groups and give me a date-by-category pivot for render_seconds so I can see which groups are slowest on which days."},{"title":"Pipeline balance check across groups","prompt":"My compositing team has been logging jobs for the past month — I've got the asset_group, date, node_count, and render_seconds for each row. Can you produce a category frequency report and a date-by-asset_group pivot for node_count to check if work is evenly distributed?"}],"resultDescription":"Returns two independent analytical reports: (1) a category frequency table showing how many records exist per asset_group value, and (2) a date-by-category pivot table showing the chosen numeric metric (node_count or render_seconds) broken down by date and asset_group. Both reports are derived purely from the supplied row data, with no external lookups or predictions.","failureModes":["Fewer than 1 row supplied — request rejected","More than 200 rows submitted — exceeds limit","Missing required fields (row_id, asset_group, date, node_count, render_seconds) in any row — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Field enum value not 'node_count' or 'render_seconds' — rejected","Numeric values outside ±1,000,000,000,000 range — schema rejection","Payment not fulfilled — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you have compositing graph records with asset_group and date dimensions and need both a simple category frequency count and a pivot view of a numeric metric across dates and categories in a single $0.01 call. It is ideal for creative/rendering pipeline analytics where the data is already on hand and no external data enrichment, prediction, or live lookup is needed. Prefer it over general-purpose analytics tools when working within a compositing or 3D rendering production context and you want two complementary views (distribution + pivot) in one batch.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:42:37.146Z","isFirstParty":false,"canonicalSlug":"compositing-graphs-category-frequencies-date-by-category-pivot-fbcb47c3"}