{"uid":"cap_ZFYpvqffyl7Nub58ZtVyT","slug":"business-event-participation-iqr-outlier-flags-date-by-category-pivot-b11249f1","name":"Business Event Participation — IQR Outlier Flags + Date by Category Pivot","description":"Business event participation — IQR outlier flags + Date by category pivot: IQR outlier flags + 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-178?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_kaENQmo7rfehCtMUFiMgS","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 local statistical reports on supplied business event participation data: IQR-based outlier flagging and a date-by-category pivot, for up to 200 rows.","exampleAgentPrompt":"I have up to 200 rows of business event participation records with attendee_count and company_count fields — can you run IQR outlier flagging plus a date-by-category pivot on the attendee_count field? Here are the rows: [{\"row_id\":\"row-1\",\"company_group\":\"group-a\",\"date\":\"2026-10-01\",\"attendee_count\":10,\"company_count\":1}, ...]","exampleUseCases":[{"title":"Flagging Anomalous Event Attendance","prompt":"I've got a dataset of 150 business event participation records with attendee_count and company_count per company group and date — can you flag any IQR outliers and also pivot the attendee_count by date and category so I can spot unusual spikes?"},{"title":"Audit Event Data Before Reporting","prompt":"Before I finalize my quarterly event participation report, run IQR outlier detection and a date-by-category pivot on these 80 rows of event data using company_count as the measure — I want to catch any weird values before they go into the deck."},{"title":"Compare Company Groups Across Dates","prompt":"Can you take my 60 business event records and give me both a pivot of company_count broken down by date and company group, plus flag any rows that are statistical outliers using IQR? The fields are row_id, company_group, date, attendee_count, and company_count."}],"resultDescription":"Returns two independent analytical reports: (1) IQR outlier flags for each row indicating whether the chosen metric (attendee_count or company_count) falls outside the interquartile range bounds, and (2) a pivot table of the selected metric aggregated by date and company_group category. Both reports are computed locally using shared analytical engines with no external data lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, company_group, date, attendee_count, or company_count) — validation error","Invalid date format (must match YYYY-MM-DD pattern) — schema validation failure","Fewer than 1 row provided — minItems constraint violation","Field value out of allowed numeric range — schema rejection","Null values in numeric fields may affect IQR computation accuracy"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of business event participation data and need both IQR-based statistical outlier detection and a date-by-category pivot in a single low-cost call. It is ideal for pre-reporting data audits, anomaly detection in event metrics, and quick categorical summaries without requiring external data sources or live lookups. Prefer it over generic analytics tools when your data already includes attendee_count and company_count fields structured per event row.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:48.208Z","isFirstParty":false,"canonicalSlug":"business-event-participation-iqr-outlier-flags-date-by-category-pivot-b11249f1"}