{"uid":"cap_lrCI3HdkBJB3OTvAB3Dw8","slug":"join-coverage-analytics-numeric-interval-filter-base-100-series-b082d184","name":"Join Coverage Analytics: Numeric Interval Filter + Base-100 Series","description":"Join coverage — Numeric interval filter + Base-100 series: Numeric interval filter + Base-100 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-128?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},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":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_LvIWnnOvXoU29_laxuPmW","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 a base-100 index series on join coverage records (matched_rows, source_rows) for up to 200 rows, returning two independent analytical reports.","exampleAgentPrompt":"I have join coverage data for two dataset groups — can you filter matched_rows to only show values between 10 and 50, then build a base-100 index series starting from row index 0? Here are my rows: group-a on 2026-10-01 had source_rows=100, matched_rows=20; group-b on 2026-10-02 had source_rows=200, matched_rows=45.","exampleUseCases":[{"title":"Filter low join coverage records","prompt":"I've got a table of join coverage results with matched_rows and source_rows by date and group — can you filter out any rows where matched_rows falls outside the range 5 to 80, and give me both a filtered report and a base-100 index starting at position 0?"},{"title":"Index source row trends to a baseline","prompt":"Can you take my join coverage dataset — 150 rows across three dataset groups with dates from Jan to Mar — and create a base-100 series for source_rows using row index 0 as the baseline, while also filtering to values between 0 and 500?"},{"title":"Compare group join rates over time","prompt":"I want to analyze matched_rows across my group-a and group-b join coverage records from last quarter. Please filter to values between 15 and 200 and compute an indexed series so I can see how coverage changed relative to the first row."}],"resultDescription":"Returns two independent analytical reports: (1) records from the supplied join coverage data where the selected field (matched_rows or source_rows) falls within the specified numeric interval [minimum, maximum], and (2) a base-100 index series for the selected field anchored at the specified base_index row, enabling trend comparison across up to 200 rows.","failureModes":["Missing required fields (row_id, date, dataset_group, matched_rows, source_rows) cause validation errors","Providing more than 200 rows exceeds the row limit and will be rejected","Invalid date format (not YYYY-MM-DD) causes schema validation failure","base_index out of range (0–199) returns an error","minimum greater than maximum produces an empty interval filter result","null values in the selected numeric field may be excluded from index computation"],"whenToPreferThis":"Choose this endpoint when you have preloaded join coverage records (matched_rows and source_rows) and need two specific analytical views — a numeric interval filter and a base-100 index series — without any external data lookup or prediction. It is ideal for data pipeline quality reviews, ETL join audits, and coverage trend analysis on datasets up to 200 rows. Not suitable for live database queries, ML predictions, or analysis of fields beyond matched_rows and source_rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:46.672Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-numeric-interval-filter-base-100-series-b082d184"}