# Event Attendance Date-by-Category Pivot

> Event Attendance Date-by-Category Pivot is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-10-19).

Pivots event attendance data (registrations or attendees) by date and event category, producing a cross-tabulated summary from up to 200 typed records.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-sector-analytics-event-attendance-pivot?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-19
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/event-attendance-date-by-category-pivot-cfc0bb04
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_7EQ7dGVjNn0LHdtk1jenA

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability event-attendance-date-by-category-pivot-cfc0bb04 -d '<json body>'
```

Example prompt: 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.

## When to prefer this

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.

## Known failure modes

- 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

## How this service works

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.

## Output

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.

## Request schema (JSON Schema)

```json
{
 "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"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/event-attendance-date-by-category-pivot-cfc0bb04/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from market.datapackvibe.com](https://www.zero.xyz/host/market.datapackvibe.com/llms.txt)