{"uid":"cap_V_9-a59f_gsbmvf0zok0Y","slug":"illustration-estimates-category-frequencies-secondary-measure-726cc352","name":"Illustration Estimates — Category Frequencies + Secondary-Measure Weighted Mean","description":"Illustration estimates — Category frequencies + Secondary-measure weighted mean: Category frequencies + Secondary-measure weighted mean for supplied illustration estimates records (estimated_hours, actual_hours). 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-19-109?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","estimated_hours","actual_hours"],"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},"actual_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"estimated_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","asset_group":"group-a","actual_hours":1,"estimated_hours":10},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","actual_hours":2,"estimated_hours":20},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","actual_hours":3,"estimated_hours":15},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","actual_hours":4,"estimated_hours":30}],"maxItems":200,"minItems":1},"field":{"enum":["estimated_hours","actual_hours"],"type":"string","default":"estimated_hours"}}},"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_vlErE-9YXdXhHBnIjwJFn","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":"Computes category frequency distribution and a secondary-measure weighted mean across supplied illustration estimate records (estimated_hours, actual_hours) for up to 200 rows.","exampleAgentPrompt":"I have 4 illustration estimate records across asset groups 'backgrounds' and 'characters' with dates from 2025-01-01 to 2025-01-04 and estimated_hours of 10, 20, 15, 30 with actual_hours of 1, 2, 3, 4 — can you run the category frequency and weighted mean report using estimated_hours as the secondary measure?","exampleUseCases":[{"title":"Illustration sprint time audit","prompt":"Here are 8 illustration job records split between 'characters', 'props', and 'backgrounds' asset groups — each has a row ID, date, estimated hours, and actual hours. Can you tell me how frequently each asset group appears and compute the weighted mean of actual_hours across those categories?"},{"title":"Comparing estimated vs actual hours by asset group","prompt":"I've got 12 rows of illustration estimate data with asset groups like 'storyboard' and 'concept-art', and I want to know the category breakdown plus the weighted average of estimated_hours weighted by actual_hours — can you run both reports together?"},{"title":"Creative studio billing analytics","prompt":"We track illustration work across 5 asset groups and I have 50 rows of estimates and actuals by date. Please compute the frequency of each asset group and the secondary-measure weighted mean using actual_hours as the field for our billing review."}],"resultDescription":"Returns two co-generated analytical reports: (1) a category frequency table showing how often each asset_group value appears across the submitted rows, and (2) a weighted mean of the selected secondary measure (estimated_hours or actual_hours) computed across categories — all derived locally from supplied data with no external lookups.","failureModes":["Rows array is empty or missing — returns validation error","More than 200 rows submitted — request rejected with max-items error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Null values in both estimated_hours and actual_hours for all rows — weighted mean may be undefined or zero","Invalid field enum value — schema rejection","row_id missing or blank — required field error"],"whenToPreferThis":"Choose this endpoint when you need two specific statistical outputs — category frequency counts and a secondary-measure weighted mean — for illustration project time data (estimated vs actual hours) in a single $0.01 call. It is best suited for creative production analytics, time-tracking audits, and asset group profiling where all data is already on hand and no external data fetch or prediction is needed. Prefer it over general analytics tools when working with illustration-specific asset_group segmentation and hours fields up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-03T12:42:36.462Z","isFirstParty":false,"canonicalSlug":"illustration-estimates-category-frequencies-secondary-measure-726cc352"}