{"uid":"cap_gvotUAIJhtdnHThhhTtYj","slug":"survey-participation-numeric-row-ordering-date-by-category-pivot-b4d831e9","name":"Survey Participation Numeric Row Ordering + Date by Category Pivot","description":"Survey participation — Numeric row ordering + Date by category pivot: Numeric row ordering + Date by category pivot for supplied survey participation records (respondents, invitations). 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-education-10-122?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","course_group","date","respondents","invitations"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"invitations":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"respondents":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"course_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","invitations":1,"respondents":10,"course_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","invitations":2,"respondents":20,"course_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","invitations":3,"respondents":15,"course_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","invitations":4,"respondents":30,"course_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["respondents","invitations"],"type":"string","default":"respondents"}}},"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_c2Hww1VMWKtdGahUgb5fP","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":"Analyzes survey participation data (respondents and invitations) by producing two reports: a numeric row ordering and a date-by-category pivot, for up to 200 rows.","exampleAgentPrompt":"I have survey participation records for our course groups — can you sort them numerically by respondent count and also give me a pivot table showing respondents by date and course group? Here's the data: row-1 on 2026-10-01 had 10 respondents and 1 invitation in group-a, row-2 on 2026-10-02 had 20 respondents and 2 invitations in group-b, row-3 on 2026-10-03 had 15 respondents and 3 invitations in group-a.","exampleUseCases":[{"title":"Course engagement ranking by respondents","prompt":"I've got survey participation data for four course groups across different dates — can you rank the rows numerically by respondent count and pivot the respondent numbers by date and course group so I can see which groups are most active over time?"},{"title":"Invitation acceptance analysis across groups","prompt":"Here's my survey invitation data for groups A and B across October — row-1 is 2026-10-01 group-a with 5 invitations, row-2 is 2026-10-02 group-b with 12 invitations, row-3 is 2026-10-03 group-a with 8 invitations. Sort the rows by invitation count and give me a date-by-category pivot using invitations as the metric."},{"title":"Education survey participation reporting","prompt":"I need two quick reports on this survey participation dataset for our education program: sort all 10 rows numerically by respondent count, and pivot the respondents field by date and course group. The data covers groups alpha, beta, and gamma from January through March 2026."}],"resultDescription":"Returns two analytical reports derived from the supplied survey participation rows: (1) a numeric row ordering that ranks rows by the selected metric (respondents or invitations), and (2) a date-by-category pivot table that cross-tabulates the selected metric across dates and course groups. Both reports are computed locally from the provided data with no external lookups.","failureModes":["Missing required fields (row_id, course_group, date, respondents, invitations) cause validation errors","Date values not matching YYYY-MM-DD pattern are rejected","Submitting more than 200 rows exceeds the maximum and is rejected","Invalid field enum value (anything other than 'respondents' or 'invitations') causes an error","Null numeric values may affect ordering and pivot calculations","Payment failure (insufficient USDC) results in 402 response"],"whenToPreferThis":"Choose this endpoint when you have up to 200 survey participation records with respondent/invitation counts grouped by course category and date, and you need both a numeric ranking of rows and a date-by-category pivot table in a single low-cost call. Ideal for education analytics workflows where participation data is already structured and no external data enrichment or prediction is needed.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:36:51.447Z","isFirstParty":false,"canonicalSlug":"survey-participation-numeric-row-ordering-date-by-category-pivot-b4d831e9"}