{"uid":"cap_USkhrKqjN4KQH7oC_gYtO","slug":"travel-administration-analytics-category-frequencies-secondary-8ab070e2","name":"Travel Administration Analytics — Category Frequencies & Secondary-Measure Weighted Mean","description":"Travel administration — Category frequencies + Secondary-measure weighted mean: Category frequencies + Secondary-measure weighted mean for supplied travel administration records (trip_count, recorded_cost). 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-operations-14-109?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","trip_count","recorded_cost"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"team_group":{"type":"string","default":"","maxLength":80},"trip_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"recorded_cost":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","trip_count":10,"recorded_cost":1},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","trip_count":20,"recorded_cost":2},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","trip_count":15,"recorded_cost":3},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","trip_count":30,"recorded_cost":4}],"maxItems":200,"minItems":1},"field":{"enum":["trip_count","recorded_cost"],"type":"string","default":"trip_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_LpAxp1gy9Psr_ljoVibjT","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 category-level frequencies and a secondary-measure weighted mean for up to 200 travel administration records containing trip counts and recorded costs.","exampleAgentPrompt":"I have up to 200 travel administration records with row IDs, team groups, dates, trip counts, and recorded costs — can you compute the category frequencies for each team group and the weighted mean of recorded_cost weighted by trip_count?","exampleUseCases":[{"title":"Team travel cost analysis","prompt":"Here are 150 travel records for our teams — each has a row ID, team group, date, trip count, and recorded cost. Can you compute how frequently each team group appears and the weighted mean of recorded_cost using trip_count as the weight?"},{"title":"Monthly trip volume distribution","prompt":"I have travel admin data for October with team groups alpha, beta, and gamma across 80 rows. Can you give me the category frequencies for each team group and calculate the weighted average cost with trip_count as the secondary measure?"},{"title":"Travel budget audit by group","prompt":"For our travel budget review, I need two reports on these 200 rows: one showing how often each team_group appears, and one showing the weighted mean of trip_count with recorded_cost as the weighting measure."}],"resultDescription":"Two analytical reports: (1) a frequency table showing how often each category (team_group) appears in the supplied rows, and (2) a secondary-measure weighted mean for the specified field (trip_count or recorded_cost) across those rows, all computed locally without any external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, team_group, date, trip_count, recorded_cost) causes rejection","Invalid date format (not YYYY-MM-DD) triggers a pattern validation error","Numeric values outside ±1,000,000,000,000 fail schema validation","Empty rows array is rejected (minItems: 1)"],"whenToPreferThis":"Choose this endpoint when you need a quick, low-cost ($0.01) dual-report analysis of travel administration tabular data — specifically category frequency counts and a weighted mean — on up to 200 rows, without requiring any live data lookup, external API calls, or predictive modeling. Ideal for auditing travel records by team group and deriving cost-per-trip insights in a single call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T19:10:12.341Z","isFirstParty":false,"canonicalSlug":"travel-administration-analytics-category-frequencies-secondary-8ab070e2"}