{"uid":"cap_VUrGjWuVBRhhqriv01Bqr","slug":"duplicate-observations-analytics-grouped-numeric-summary-date-by-3009175a","name":"Duplicate Observations Analytics — Grouped Numeric Summary + Date-by-Category Pivot","description":"Duplicate observations — Grouped numeric summary + Date by category pivot: Grouped numeric summary + Date by category pivot for supplied duplicate observations records (duplicate_rows, total_rows). 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-analytics-04-097?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","duplicate_rows","total_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"duplicate_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rows":1,"dataset_group":"group-a","duplicate_rows":10},{"date":"2026-10-02","row_id":"row-2","total_rows":2,"dataset_group":"group-b","duplicate_rows":20},{"date":"2026-10-03","row_id":"row-3","total_rows":3,"dataset_group":"group-a","duplicate_rows":15},{"date":"2026-10-04","row_id":"row-4","total_rows":4,"dataset_group":"group-b","duplicate_rows":30}],"maxItems":200,"minItems":1},"field":{"enum":["duplicate_rows","total_rows"],"type":"string","default":"duplicate_rows"}}},"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_NGrfwebrdMqxM2Ttkctui","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":"Analyzes up to 200 duplicate-observation records, producing a grouped numeric summary and a date-by-category pivot table as two independent analytical reports.","exampleAgentPrompt":"I have 150 rows of duplicate observation data with row IDs, dataset groups, dates, duplicate_rows counts, and total_rows — can you give me both a grouped numeric summary and a date-by-category pivot for the duplicate_rows field?","exampleUseCases":[{"title":"Data quality audit across pipeline stages","prompt":"I'm auditing our ETL pipeline and have 80 records showing duplicate_rows and total_rows per dataset_group and date. Can you run a grouped numeric summary and a date-by-category pivot on the duplicate_rows field so I can see where duplication is worst?"},{"title":"Weekly deduplication report for data team","prompt":"Here are this week's duplicate observation records — 120 rows with dataset group, date, duplicate count, and total rows. Give me both a grouped summary and a date-category pivot on total_rows so I can share the report with my data team."},{"title":"Comparing duplicate rates across vendor datasets","prompt":"I have duplicate observation data for 4 vendor dataset groups across 50 records. Run me a grouped numeric summary and a date-by-category pivot on duplicate_rows so I can compare duplication rates between vendors."}],"resultDescription":"Returns two independent analytical reports: (1) a grouped numeric summary showing statistics (e.g. count, sum, mean, min, max) of the selected field (duplicate_rows or total_rows) broken down by dataset_group, and (2) a date-by-category pivot table cross-tabulating the selected field across dates and dataset groups. All analysis is performed locally on the supplied data with no external lookups.","failureModes":["Input array is empty or exceeds 200 rows — validation error returned","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) in any row — schema validation failure","Date field does not match YYYY-MM-DD pattern — pattern validation error","Numeric fields out of allowed range (±1 trillion) — validation error","Invalid enum value for 'field' parameter — validation error","Payment of 0.01 USDC not provided — x402 payment required response"],"whenToPreferThis":"Choose this endpoint when you need both a grouped numeric summary AND a date-by-category pivot on duplicate observation data in a single call. It is ideal for data quality workflows where you want to understand duplication patterns across categories and time simultaneously, without needing live lookups, predictions, or external integrations. Best suited for batch analytical reporting on pre-collected duplicate detection results of up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:47:06.611Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-analytics-grouped-numeric-summary-date-by-3009175a"}