{"uid":"cap_Z012FhnGWjxHwUsp5K8Cr","slug":"join-coverage-analytics-numeric-interval-filter-daily-sum-series-cd3e89ef","name":"Join Coverage Analytics: Numeric Interval Filter + Daily Sum Series","description":"Join coverage — Numeric interval filter + Daily sum series: Numeric interval filter + Daily sum series 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-125?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"},"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_U1pjO7DINMyK_08eGaizI","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":"Applies a numeric interval filter and computes daily sum series for join coverage metrics (matched_rows, source_rows) across up to 200 supplied rows, returning 2 independent analytical reports.","exampleAgentPrompt":"I have join coverage records for groups A and B from October 1–4 2026 — can you filter matched_rows between 0 and 100, and also give me the daily sum series for matched_rows across those rows?","exampleUseCases":[{"title":"ETL join quality daily monitoring","prompt":"I have 50 join coverage records across dataset groups 'orders' and 'returns' for the past month — filter source_rows between 1 and 500, and give me the daily sum series for source_rows so I can spot coverage drops."},{"title":"Coverage threshold compliance check","prompt":"Here are my join coverage rows for groups 'alpha' and 'beta' through last week — filter matched_rows between 10 and 1000 and compute the daily sum series for matched_rows so I can see which days stayed within our acceptable range."},{"title":"Dataset group comparison by daily totals","prompt":"Can you run both reports on my join coverage data for groups 'inventory' and 'sales' — apply a numeric interval filter from 0 to 250 on matched_rows and show me the daily sum series so I can compare coverage across groups?"}],"resultDescription":"Returns two independent analytical reports: (1) a numeric interval filter report listing which of the supplied rows have the chosen field (matched_rows or source_rows) within the specified minimum–maximum range, and (2) a daily sum series report aggregating the chosen field by date across the supplied rows — both computed locally on the provided data, covering up to 200 rows.","failureModes":["More than 200 rows submitted — request rejected or truncated","Invalid date format (non-YYYY-MM-DD) causes schema validation failure","minimum greater than maximum results in empty filter output","Missing required fields (row_id, date, matched_rows, source_rows, dataset_group) causes validation error","Null numeric values in the selected field may be excluded from sums or filter results","Invalid field enum value (not 'matched_rows' or 'source_rows') causes rejection"],"whenToPreferThis":"Choose this endpoint when you have already collected join coverage records locally and need two quick analytical reports — a numeric range filter and a daily sum series — without any live data lookup, external enrichment, or prediction. It is ideal for ETL monitoring, data quality review, or coverage auditing workflows where you want to inspect which records fall within a numeric band and how coverage totals trend day-by-day, all within a single low-cost call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:43.512Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-numeric-interval-filter-daily-sum-series-cd3e89ef"}