{"uid":"cap_OhOaKaDSKt-TAc_q3kygN","slug":"company-headcount-observations-duplicate-key-report-secondary-measure-8150573b","name":"Company Headcount Observations — Duplicate Key Report + Secondary-Measure Weighted Mean","description":"Company headcount observations — Duplicate key report + Secondary-measure weighted mean: Duplicate key report + Secondary-measure weighted mean for supplied company headcount observations records (headcount, open_roles). 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-12-067?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","headcount","open_roles"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"headcount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"open_roles":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","headcount":10,"open_roles":1,"company_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","headcount":20,"open_roles":2,"company_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","headcount":15,"open_roles":3,"company_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","headcount":30,"open_roles":4,"company_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["headcount","open_roles"],"type":"string","default":"headcount"}}},"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_17IO2tzkrg5dyUuYKqwAn","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 user-supplied company headcount data: a duplicate key detection report and a weighted mean calculation for headcount or open_roles, supporting up to 200 rows per call.","exampleAgentPrompt":"Check my company headcount observations for duplicate row IDs and compute the weighted mean of headcount across these records — here are up to 200 rows with fields row_id, company_group, date, headcount, and open_roles.","exampleUseCases":[{"title":"Pre-load headcount data quality check","prompt":"Before I import this batch of 150 company headcount records into our HR system, can you scan them for any duplicate row IDs or duplicate company/date combinations, and also give me the weighted mean headcount? The rows each have a row_id, company_group, date, headcount, and open_roles."},{"title":"Workforce planning weighted mean summary","prompt":"I have quarterly headcount observations for about 80 company groups and I need to know the weighted mean of open_roles across all of them, plus flag any duplicates in the data. Can you run both reports on the rows I'm supplying?"},{"title":"Audit headcount snapshot before reporting","prompt":"We're preparing a headcount report for leadership and I need to first deduplicate-check our observation data and get a weighted average headcount — the dataset has around 120 rows with company_group, date, headcount, and open_roles columns. Can you run those two analyses?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any rows with repeated key combinations (row_id, company_group, date), and (2) a secondary-measure weighted mean for the chosen field (headcount or open_roles) across all supplied rows. Results are computed locally on the supplied data with no external lookups.","failureModes":["Missing required fields (row_id, company_group, date, headcount, or open_roles) cause validation errors","Supplying more than 200 rows exceeds the maxItems limit and will be rejected","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","Null values in both numeric fields may affect weighted mean computation","Empty rows array (minItems: 1 not met) returns an error","Invalid field enum value (anything other than 'headcount' or 'open_roles') causes rejection"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously check a batch of company headcount observations for duplicate keys AND compute a weighted mean for headcount or open_roles, and your dataset is 200 rows or fewer. It is ideal for pre-ingestion data quality validation or quick analytical summaries on supplied data without needing any external data sources or live lookups. Not suitable for datasets exceeding 200 rows, for live headcount lookups, or for operations requiring more than two report types.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:45:36.469Z","isFirstParty":false,"canonicalSlug":"company-headcount-observations-duplicate-key-report-secondary-measure-8150573b"}