{"uid":"cap_wCaJuDXz8gACkpxyIILWH","slug":"business-event-participation-daily-sum-series-date-by-category-pivot-0f00490f","name":"Business Event Participation — Daily Sum Series + Date by Category Pivot","description":"Business event participation — Daily sum series + Date by category pivot: Daily sum series + Date by category pivot for supplied business event participation records (attendee_count, company_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-company-19-143?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","attendee_count","company_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"attendee_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_count":1,"company_group":"group-a","attendee_count":10},{"date":"2026-10-02","row_id":"row-2","company_count":2,"company_group":"group-b","attendee_count":20},{"date":"2026-10-03","row_id":"row-3","company_count":3,"company_group":"group-a","attendee_count":15},{"date":"2026-10-04","row_id":"row-4","company_count":4,"company_group":"group-b","attendee_count":30}],"maxItems":200,"minItems":1},"field":{"enum":["attendee_count","company_count"],"type":"string","default":"attendee_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_G_rRPq06Q5AUbdkCYxOOj","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 a daily sum time series and a date-by-category pivot table for supplied business event participation data (attendee_count or company_count) across up to 200 rows.","exampleAgentPrompt":"I have a list of business event participation records with dates, company groups, attendee counts, and company counts — can you compute a daily sum time series and a date-by-category pivot for the attendee_count field across all my rows?","exampleUseCases":[{"title":"Conference attendance daily trend report","prompt":"Here are my conference participation records for October with company groups and attendee counts for each day — can you give me a daily sum series and a pivot table of attendee_count broken out by company group and date?"},{"title":"Corporate event company participation pivot","prompt":"I have event data rows with company_group, date, and company_count fields — can you run both a daily aggregation and a date-by-category pivot on the company_count metric so I can see how many companies attended each day by group?"},{"title":"Multi-group event analytics for monthly review","prompt":"We tracked attendee and company counts across two groups, group-a and group-b, for our monthly business events — can you produce a daily sum series and a date-by-company-group pivot for the attendee_count so I can include it in the monthly review?"}],"resultDescription":"Returns two analytical reports: (1) a daily sum time series showing totals of the selected metric (attendee_count or company_count) aggregated by date, and (2) a date-by-category pivot table cross-tabulating values by date and company_group. Both reports are computed locally from the supplied input rows with no external data lookup.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, company_group, date, attendee_count, company_count) causes validation error","Date field not matching YYYY-MM-DD pattern causes schema rejection","Invalid field enum value (not attendee_count or company_count) causes error","Empty rows array (minItems:1 not satisfied) causes rejection","Numeric values outside ±1,000,000,000,000 range rejected"],"whenToPreferThis":"Choose this endpoint when you have pre-collected business event participation records (up to 200 rows) and need both a daily aggregate time series AND a date-by-category pivot in a single low-cost call. It is ideal for offline/batch reporting on event attendance data where no live data fetching, prediction, or external enrichment is needed, and where you want two complementary analytical views for the price of one call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:48.952Z","isFirstParty":false,"canonicalSlug":"business-event-participation-daily-sum-series-date-by-category-pivot-0f00490f"}