{"uid":"cap_J_0xTBgxRUqkhFUDWdju1","slug":"training-compliance-secondary-measure-weighted-mean-date-by-category-2ec6fc45","name":"Training Compliance — Secondary-Measure Weighted Mean + Date by Category Pivot","description":"Training compliance — Secondary-measure weighted mean + Date by category pivot: Secondary-measure weighted mean + Date by category pivot for supplied training compliance records (completed_courses, assigned_courses). 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-10-185?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","completed_courses","assigned_courses"],"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},"assigned_courses":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_courses":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","assigned_courses":1,"completed_courses":10},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","assigned_courses":2,"completed_courses":20},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","assigned_courses":3,"completed_courses":15},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","assigned_courses":4,"completed_courses":30}],"maxItems":200,"minItems":1},"field":{"enum":["completed_courses","assigned_courses"],"type":"string","default":"completed_courses"}}},"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_Ahd2RXiCyv4GcatQ39KIM","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 a secondary-measure weighted mean and a date-by-category pivot table for up to 200 training compliance records (completed_courses, assigned_courses).","exampleAgentPrompt":"I have training compliance data for two team groups over four dates — can you compute the weighted mean of completed_courses weighted by assigned_courses, and also pivot it by date and team category? Here are the rows: row-1 group-a 2026-10-01 completed=10 assigned=1, row-2 group-b 2026-10-02 completed=20 assigned=2, row-3 group-a 2026-10-03 completed=15 assigned=3, row-4 group-b 2026-10-04 completed=30 assigned=4.","exampleUseCases":[{"title":"Monthly compliance rollup by team","prompt":"I have 50 training records across 5 team groups for October — each row has a date, team name, number of completed courses, and number of assigned courses. Can you give me the weighted mean of completed_courses (weighted by assigned_courses) and a pivot of completions by date and team group?"},{"title":"HR audit of course assignment completion","prompt":"We're running an HR audit and I need to analyze 120 training compliance rows. For each row I have the team group, date, assigned courses, and completed courses. Please compute the secondary-measure weighted mean and pivot the data by date and category so I can see patterns."},{"title":"Comparing training progress across departments","prompt":"I want to compare training progress across our departments — I have records with row IDs, department names, dates, assigned course counts, and completed course counts (up to 80 rows). Run both the weighted mean analysis on assigned_courses and the date-by-category pivot for completed_courses."}],"resultDescription":"Returns two analytical reports: (1) a secondary-measure weighted mean of the selected field (completed_courses or assigned_courses) weighted by the other measure across all rows, and (2) a date-by-category pivot table breaking down the field values by team_group and date. Both reports are computed locally on the supplied data, with no external lookups.","failureModes":["Fewer than 1 or more than 200 rows submitted — request rejected","Missing required fields (row_id, team_group, date, completed_courses, assigned_courses) — validation error","Date field not matching YYYY-MM-DD format — pattern validation failure","Null values in both completed_courses and assigned_courses may produce undefined weighted mean","Invalid field enum value (not completed_courses or assigned_courses) — rejected","Payment of 0.01 USDC not fulfilled — 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you have tabular training compliance data (completed vs assigned courses) and need both a weighted-mean aggregation and a date-by-category pivot in a single paid call. It is ideal for HR analytics pipelines, compliance dashboards, or automated reporting workflows that supply up to 200 rows and want two complementary analytical views without any external data lookups or live integrations.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:30:57.537Z","isFirstParty":false,"canonicalSlug":"training-compliance-secondary-measure-weighted-mean-date-by-category-2ec6fc45"}