{"uid":"cap_bida2ifh8rAL7t5J7vI8X","slug":"join-coverage-analytics-numeric-interval-filter-keyed-dataset-8c0025b6","name":"Join Coverage Analytics: Numeric Interval Filter + Keyed Dataset Comparison","description":"Join coverage — Numeric interval filter + Keyed dataset comparison: Numeric interval filter + Keyed dataset comparison for supplied join coverage records (matched_rows, source_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-09-134?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","matched_rows","source_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"matched_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_rows":1,"matched_rows":10,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_rows":2,"matched_rows":20,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_rows":3,"matched_rows":15,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_rows":4,"matched_rows":30,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["matched_rows","source_rows"],"type":"string","default":"matched_rows"},"other":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","matched_rows","source_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"matched_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_rows":1,"matched_rows":10,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_rows":2,"matched_rows":21,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_rows":3,"matched_rows":17,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_rows":4,"matched_rows":33,"dataset_group":"group-b"}],"maxItems":200,"minItems":0},"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__cY1FF_Mt0vMcAHMYTnqt","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 join coverage data by applying numeric interval filtering and comparing two keyed datasets (rows vs other) across matched_rows and source_rows metrics, returning 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"I have two sets of join coverage records — my primary dataset and a comparison dataset — each with matched_rows and source_rows per group per day. Can you run both a numeric interval filter and a keyed dataset comparison on the matched_rows field and give me 2 analytical reports?","exampleUseCases":[{"title":"ETL pipeline join quality audit","prompt":"I ran a data join yesterday and today and want to compare join coverage: here's my primary dataset with row_id, date, dataset_group, matched_rows, and source_rows, and a second dataset from last week. Analyze the matched_rows field with an interval filter and compare the two datasets by key."},{"title":"Dataset group coverage drift detection","prompt":"I have two snapshots of join results — one from before a schema change and one after — both with matched_rows and source_rows by dataset_group and date. Can you compare them and flag where coverage has changed using a keyed dataset comparison?"},{"title":"Source row match rate analysis by group","prompt":"Here are up to 200 rows of join coverage data split into group-a and group-b, with matched_rows and source_rows per day. Run the numeric interval filter and keyed comparison on source_rows so I can see which groups have low match rates."}],"resultDescription":"Two analytical reports: (1) a numeric interval filter report showing the distribution and segmentation of the selected field (matched_rows or source_rows) across the primary dataset, and (2) a keyed dataset comparison report highlighting differences between the primary and secondary datasets matched by row_id, dataset_group, and date. Both reports are computed locally without external lookups.","failureModes":["More than 200 rows submitted — returns validation error","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — returns schema validation error","Date not in YYYY-MM-DD format — rejected by pattern validation","Invalid field enum value (not matched_rows or source_rows) — returns error","Empty rows array — rejected by minItems:1 constraint","Numeric values outside ±1,000,000,000,000 range — rejected"],"whenToPreferThis":"Choose this endpoint when you need to perform offline, local analytical computation on join coverage data — specifically numeric interval segmentation plus keyed cross-dataset comparison — without any external data lookups or live predictions. Ideal for data engineers auditing ETL pipeline join completeness, comparing two snapshots of join results by group and date, or evaluating match rates across dataset groups. At $0.01 USDC for 2 reports covering up to 200 rows, it is cost-effective for routine data quality checks.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T19:07:57.121Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-numeric-interval-filter-keyed-dataset-8c0025b6"}