{"uid":"cap_7EQ7dGVjNn0LHdtk1jenA","slug":"event-attendance-date-by-category-pivot-cfc0bb04","name":"Event Attendance Date-by-Category Pivot","description":"Event attendance - Date by category pivot: Date by category pivot for Event attendance. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded date by category pivot deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-event-attendance-pivot?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","event_type","date","registrations","attendees"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"attendees":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"event_type":{"type":"string","default":"","maxLength":80},"registrations":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","attendees":1,"event_type":"group-a","registrations":10},{"date":"2026-10-02","row_id":"row-2","attendees":2,"event_type":"group-b","registrations":20},{"date":"2026-10-03","row_id":"row-3","attendees":3,"event_type":"group-a","registrations":15},{"date":"2026-10-04","row_id":"row-4","attendees":4,"event_type":"group-b","registrations":30}],"maxItems":200,"minItems":1},"field":{"enum":["registrations","attendees"],"type":"string","default":"registrations"}}},"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_-jndnXBkHnRbj82Nf6Mpr","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 event attendance data (registrations or attendees) by date and event category, producing a cross-tabulated summary from up to 200 typed records.","exampleAgentPrompt":"I have a list of events with dates, event types, registration counts, and attendee counts — can you pivot the registrations field by date and event category to show me a cross-tab summary? Here are up to 200 rows of data with columns: row_id, event_type, date, registrations, attendees.","exampleUseCases":[{"title":"Conference attendance breakdown by track","prompt":"I have daily attendance logs for a multi-track conference — rows include date, track name as event_type, registrations, and attendees. Can you pivot the attendees field by date and track category so I can see how each track performed day by day?"},{"title":"Monthly event registration comparison across types","prompt":"I've got records for webinars, workshops, and networking events across October with registration and attendee numbers per day. Pivot the registrations field by date and event_type so I can see which category pulls the most sign-ups on each date."},{"title":"Festival footfall analysis by event category","prompt":"We ran a weekend festival with different event types — panels, performances, and exhibitions — logged by date with attendee counts. Can you cross-tabulate the attendees field across event types and dates so I can see the breakdown at a glance?"}],"resultDescription":"A date-by-category pivot table showing the selected numeric field (registrations or attendees) aggregated across all supplied event types and dates, delivered as a bounded structured output with local numeric processing and data-quality checks applied.","failureModes":["Invalid date format (must match YYYY-MM-DD pattern) causes row rejection","Exceeding 200 rows returns a validation error","Missing required fields (row_id, event_type, date, registrations, attendees) causes request failure","Null numeric values may be excluded or flagged depending on data-quality processing","Invalid field enum value (not 'registrations' or 'attendees') causes a schema validation error"],"whenToPreferThis":"Choose this endpoint when you need a fast, low-cost date-by-category pivot specifically for event attendance data (registrations or attendees) with up to 200 typed records, and you want local numeric aggregation without external enrichment or forecasting. It is ideal for structured event logs that already include event_type, date, and numeric attendance fields and where a clean cross-tabulation output is the end goal.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T19:08:06.269Z","isFirstParty":false,"canonicalSlug":"event-attendance-date-by-category-pivot-cfc0bb04"}