{"uid":"cap_E7qMT9OH-DVA_BYgBi4ma","slug":"research-task-completion-date-by-category-pivot-keyed-dataset-e09c57a1","name":"Research Task Completion — Date by Category Pivot + Keyed Dataset Comparison","description":"Research task completion — Date by category pivot + Keyed dataset comparison: Date by category pivot + Keyed dataset comparison for supplied research task completion records (completed_tasks, assigned_tasks). 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-22-188?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","completed_tasks","assigned_tasks"],"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},"assigned_tasks":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_tasks":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","assigned_tasks":1,"completed_tasks":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","assigned_tasks":2,"completed_tasks":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","assigned_tasks":3,"completed_tasks":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","assigned_tasks":4,"completed_tasks":30}],"maxItems":200,"minItems":1},"field":{"enum":["completed_tasks","assigned_tasks"],"type":"string","default":"completed_tasks"},"other":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","completed_tasks","assigned_tasks"],"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},"assigned_tasks":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_tasks":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","assigned_tasks":1,"completed_tasks":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","assigned_tasks":2,"completed_tasks":21},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","assigned_tasks":3,"completed_tasks":17},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","assigned_tasks":4,"completed_tasks":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_xyGHjVGdZnhYum1gQee5w","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 on research task completion data: a date-by-category pivot table and a keyed dataset comparison, for up to 200 rows.","exampleAgentPrompt":"I have two sets of research task completion records — each up to 200 rows with row_id, company_group, date, completed_tasks, and assigned_tasks — can you run a date-by-category pivot on the completed_tasks field and also compare the two datasets side by side to highlight differences?","exampleUseCases":[{"title":"Weekly task completion pivot by team","prompt":"Here are this week's research task records for group-a and group-b with dates and completed_tasks counts — can you pivot them by date and company group so I can see completion totals per team per day, and compare them against last week's records to spot any changes?"},{"title":"Assigned vs completed task comparison","prompt":"I have two batches of task data — one with assigned_tasks and one with completed_tasks — both keyed by row_id, date, and company_group. Run the date-by-category pivot on assigned_tasks and compare the two datasets to flag any mismatches."},{"title":"Cross-period research task audit","prompt":"Can you take my Q3 and Q4 research task completion records (each up to 200 rows, with row_id, company_group, date, completed_tasks, assigned_tasks) and produce both a pivot table breaking down completed_tasks by date and group, plus a keyed comparison report showing what changed between the two periods?"}],"resultDescription":"Returns two independent reports: (1) a date-by-category pivot table showing the selected metric (completed_tasks or assigned_tasks) broken down by date and company_group, and (2) a keyed dataset comparison highlighting differences between the primary and secondary datasets, based on the supplied rows up to 200 records each.","failureModes":["Input array exceeds 200 rows — request will be rejected or truncated","Missing required fields (row_id, company_group, date, completed_tasks, assigned_tasks) cause row-level errors","Invalid date format (not YYYY-MM-DD) triggers schema validation failure","Null values in numeric fields may affect aggregation accuracy","Empty rows array returns no meaningful report output"],"whenToPreferThis":"Choose this endpoint when you need both a cross-tabulated pivot of task completion data by date and company category AND a side-by-side keyed comparison of two datasets in a single $0.01 call. Ideal for research operations teams tracking completed vs assigned tasks across company groups over time, especially when comparing two time periods or data snapshots without needing 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-17T12:43:03.890Z","isFirstParty":false,"canonicalSlug":"research-task-completion-date-by-category-pivot-keyed-dataset-e09c57a1"}