{"uid":"cap_n7Rx-_oTwfb-zDgK7CTUD","slug":"duplicate-observations-grouped-numeric-summary-numeric-interval-filter-892b8ee5","name":"Duplicate Observations — Grouped Numeric Summary + Numeric Interval Filter","description":"Duplicate observations — Grouped numeric summary + Numeric interval filter: Grouped numeric summary + Numeric interval filter 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-088?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"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_0XuVgG8KnqLys9hHEygiZ","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 a grouped numeric summary and a numeric interval filter report for supplied duplicate_rows/total_rows observation data, up to 200 rows, returning 2 analytical reports per call.","exampleAgentPrompt":"I have duplicate observation records for two groups — group-a and group-b — across dates in October 2026, with duplicate_rows and total_rows counts. Can you give me a grouped numeric summary and also filter to only rows where duplicate_rows is between 10 and 25?","exampleUseCases":[{"title":"Data quality audit by dataset group","prompt":"I've got 150 records each with a dataset_group, a date, and counts for duplicate_rows and total_rows. Can you group them and give me a numeric summary of duplicate_rows per group, and also filter to show only the records where duplicate_rows falls between 5 and 50?"},{"title":"Deduplication monitoring for ETL pipeline","prompt":"Here are my ETL pipeline's duplicate observation rows for the past month — each row has a group name, a date, duplicate_rows, and total_rows. Summarize the duplicate_rows statistics grouped by dataset group, and filter down to rows where total_rows is between 100 and 500."},{"title":"Identifying high-duplication groups","prompt":"I have a dataset with records across group-a, group-b, and group-c, each with duplicate_rows and total_rows values. Give me a grouped numeric summary of duplicate_rows across those groups and show me only the entries where duplicate_rows is between 20 and 200."}],"resultDescription":"Returns two analytical reports: (1) a grouped numeric summary breaking down the selected field (duplicate_rows or total_rows) by dataset_group with descriptive statistics, and (2) a numeric interval filter report listing rows where the selected field falls between the specified minimum and maximum values. Both reports are computed locally on the supplied data with no external lookups.","failureModes":["Fewer than 1 row submitted — request rejected (minItems: 1)","More than 200 rows submitted — exceeds maxItems limit","date field does not match YYYY-MM-DD pattern — validation error","minimum greater than maximum — interval filter returns empty results","duplicate_rows or total_rows out of allowed numeric range (±1 trillion) — schema validation failure","missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — request rejected"],"whenToPreferThis":"Choose this endpoint when you need both a grouped statistical summary AND a numeric range filter on duplicate observation data in a single $0.01 call, without requiring any external data sources or live lookups. Ideal for data quality profiling workflows where you want to segment duplicate counts by group and isolate records within a specific numeric interval in one step.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:09:23.492Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-grouped-numeric-summary-numeric-interval-filter-892b8ee5"}