{"uid":"cap_PtSkBm3J6tticqyjEzwpD","slug":"ownership-record-completeness-daily-sum-series-date-by-category-pivot-ceaf77cd","name":"Ownership Record Completeness — Daily Sum Series + Date-by-Category Pivot","description":"Ownership record completeness — Daily sum series + Date by category pivot: Daily sum series + Date by category pivot for supplied ownership record completeness records (documented_links, required_links). 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-21-143?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","documented_links","required_links"],"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_links":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"documented_links":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","required_links":1,"documented_links":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","required_links":2,"documented_links":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","required_links":3,"documented_links":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","required_links":4,"documented_links":30}],"maxItems":200,"minItems":1},"field":{"enum":["documented_links","required_links"],"type":"string","default":"documented_links"}}},"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_DWUVvY-x0czNUntRd6pkS","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":"Generates two analytical reports (daily sum time series and date-by-category pivot) from supplied ownership record completeness data covering documented_links and required_links fields, for up to 200 rows.","exampleAgentPrompt":"Can you run a daily sum series and date-by-category pivot on my ownership record completeness data? I have 4 rows across two company groups (group-a and group-b) from 2026-10-01 to 2026-10-04, with documented_links and required_links values — I want to analyze the documented_links field.","exampleUseCases":[{"title":"Audit ownership link coverage by week","prompt":"I have ownership records for two business units over the past two weeks, each row has a date, company_group, documented_links count, and required_links count. Can you give me a daily sum time series and a pivot by company group and date so I can see where our documentation gaps are? Analyze the documented_links field."},{"title":"Compare required links completeness across subsidiaries","prompt":"Here are 120 rows of ownership record completeness data across five subsidiaries with dates spanning Q3. Run a daily sum series and a date-by-category pivot on the required_links field so I can see which groups are falling behind."},{"title":"Track documentation progress over a sprint","prompt":"My team has been documenting ownership links over the last 30 days and I've got 80 rows with company_group, date, documented_links, and required_links. Can you aggregate this into a daily sum series and a pivot table by date and group, focused on the documented_links field, so I can report progress to management?"}],"resultDescription":"Two independent analytical reports computed from the supplied rows: (1) a daily sum time series of the selected field (documented_links or required_links) aggregated by date, and (2) a date-by-category pivot table cross-tabulating dates against company_group values. Both reports are derived entirely from the submitted data with no external lookups.","failureModes":["Input array contains more than 200 rows — request will be rejected or truncated","Missing required row fields (row_id, company_group, date, documented_links, required_links) causes validation error","Invalid date format (non-YYYY-MM-DD) causes schema rejection","Field selector not in enum ['documented_links','required_links'] causes error","Null or out-of-range numeric values for documented_links or required_links may affect aggregation accuracy","Empty rows array triggers minItems validation failure"],"whenToPreferThis":"Choose this endpoint when you already have ownership record completeness data locally and need two pre-packaged analytical views (daily sum series + date-by-category pivot) without building custom aggregation logic. It is ideal for quick audits of documented vs required link coverage across company groups over time. Prefer alternatives if you need live data lookup, predictions, or more than 200 rows processed in a single call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-16T12:43:25.825Z","isFirstParty":false,"canonicalSlug":"ownership-record-completeness-daily-sum-series-date-by-category-pivot-ceaf77cd"}