{"uid":"cap_5baCkap43WbMYIF0cq7Xf","slug":"company-record-completeness-iqr-outlier-flags-date-by-category-pivot-355714da","name":"Company Record Completeness — IQR Outlier Flags + Date by Category Pivot","description":"Company record completeness — IQR outlier flags + Date by category pivot: IQR outlier flags + Date by category pivot for supplied company record completeness records (populated_fields, required_fields). 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-01-178?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","populated_fields","required_fields"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"required_fields":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"populated_fields":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","required_fields":1,"populated_fields":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","required_fields":2,"populated_fields":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","required_fields":3,"populated_fields":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","required_fields":4,"populated_fields":30}],"maxItems":200,"minItems":1},"field":{"enum":["populated_fields","required_fields"],"type":"string","default":"populated_fields"}}},"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_SmNnJFh_jWyvCLinNDP-2","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 local analytical reports on company record completeness data: IQR-based outlier detection on populated_fields or required_fields, and a date-by-category pivot table, for up to 200 rows.","exampleAgentPrompt":"I have a dataset of up to 100 company records with populated_fields and required_fields counts, grouped by company_group and date — can you run IQR outlier detection and a date-by-category pivot on the populated_fields metric and tell me which records are anomalous?","exampleUseCases":[{"title":"CRM data quality audit","prompt":"Here are 150 rows of our CRM company records with populated_fields and required_fields values, grouped by region and date — flag any outliers using IQR analysis on populated_fields and also give me a pivot of completeness by date and region."},{"title":"Monthly completeness trend review","prompt":"I want to understand how our record completeness has varied across company groups over the last quarter — here's the data with dates and required_fields counts, run the IQR outlier flags and date-by-category pivot on required_fields."},{"title":"Pre-migration data anomaly check","prompt":"Before we migrate our company database, I need to check for records with abnormally low populated_fields counts — please run IQR outlier detection and a date-category pivot on this set of 80 records so I can spot which groups need cleanup."}],"resultDescription":"Returns two independent analytical reports: (1) IQR outlier flags identifying which rows have populated_fields or required_fields values outside the interquartile range, and (2) a date-by-category pivot table summarizing the selected metric across company_group and date dimensions. Both reports are computed locally from supplied data with no external lookups.","failureModes":["Input array exceeds 200 rows — request will be rejected or truncated","Missing required fields (row_id, company_group, date, populated_fields, required_fields) cause validation errors","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Null numeric values may reduce statistical reliability of IQR computation","Too few rows (e.g. fewer than 4) may make IQR outlier detection statistically meaningless","Invalid 'field' enum value (not 'populated_fields' or 'required_fields') causes error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of company record completeness data and need both IQR-based statistical outlier detection and a date-by-category pivot in a single low-cost ($0.01) call. Ideal for data quality audits, CRM hygiene checks, and pre-migration anomaly reviews where you supply the data and want offline, deterministic analysis without any live lookups or external data enrichment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:00.356Z","isFirstParty":false,"canonicalSlug":"company-record-completeness-iqr-outlier-flags-date-by-category-pivot-355714da"}