{"uid":"cap_xpoB2homkM0N-5IoCGyaB","slug":"training-compliance-date-by-category-pivot-keyed-dataset-comparison-e5a58128","name":"Training Compliance — Date by Category Pivot + Keyed Dataset Comparison","description":"Training compliance — Date by category pivot + Keyed dataset comparison: Date by category pivot + Keyed dataset comparison 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-188?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"},"other":{"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":21},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","assigned_courses":3,"completed_courses":17},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","assigned_courses":4,"completed_courses":33}],"maxItems":200,"minItems":0}}},"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_YnzAr3PMHborG6ray4vVz","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 analytical reports on training compliance data: a date-by-category pivot table and a keyed dataset comparison, for up to 200 rows of completed/assigned course records.","exampleAgentPrompt":"Analyze my training compliance data — I have two sets of records with team_group, date, completed_courses, and assigned_courses fields (up to 200 rows each). Run a date-by-category pivot on completed_courses and a keyed comparison between the two datasets so I can see how completion rates differ by team over time.","exampleUseCases":[{"title":"Monthly training compliance review","prompt":"I have two months of training records for our teams — each row has a team_group, date, and counts of completed_courses and assigned_courses. Can you pivot this by date and team, and then compare January versus February so I can see which groups improved?"},{"title":"Department-level course completion audit","prompt":"Run a date-by-category pivot on our Q3 training compliance data grouped by team_group using the completed_courses field, and compare it against our Q2 records row-by-row so I can spot which departments fell behind."},{"title":"Onboarding cohort training gap analysis","prompt":"I've got two cohorts of new hires with training records — each has a row_id, team_group, date, assigned_courses, and completed_courses. Please pivot the data by date and team for the completed_courses metric and run a keyed comparison between cohort A and cohort B to find the gaps."}],"resultDescription":"Returns two independent analytical reports: (1) a date-by-category pivot table showing the selected metric (completed_courses or assigned_courses) broken down by date and team_group, and (2) a keyed dataset comparison that highlights row-level differences between the primary and secondary supplied datasets, using shared local analytical engines with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, team_group, date, completed_courses, assigned_courses) — validation error","Date field does not match YYYY-MM-DD pattern — schema validation failure","Empty rows array (minItems: 1 not met) — request rejected","Null numeric values where aggregation is attempted may produce incomplete pivot cells"],"whenToPreferThis":"Choose this endpoint when you have training compliance tabular data (completed and assigned courses by team and date) and need both a pivot-table breakdown by date/category and a row-keyed diff between two datasets in a single $0.01 call. It is ideal for HR analytics, L&D reporting, and compliance auditing workflows where data is already collected and you need structured analytical summaries without any external data fetching or live lookups. Prefer it over generic analytics tools when your data fits within 200 rows and you want both report types bundled cost-efficiently.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:31:02.036Z","isFirstParty":false,"canonicalSlug":"training-compliance-date-by-category-pivot-keyed-dataset-comparison-e5a58128"}