{"uid":"cap_6w-rPKqiWKcYAr9iVB4bG","slug":"join-coverage-analytics-base-100-series-equal-width-histogram-625a9233","name":"Join Coverage Analytics: Base-100 Series + Equal-Width Histogram","description":"Join coverage — Base-100 series + Equal-width histogram: Base-100 series + Equal-width histogram 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-163?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"bins":{"type":"integer","default":5,"maximum":30,"minimum":1},"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"},"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_IRoLW5TBmPwKZVOL_OabF","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 Base-100 indexed time series and an equal-width histogram for join coverage data (matched_rows vs source_rows) across up to 200 rows in two independent analytical reports.","exampleAgentPrompt":"Can you run a base-100 series and equal-width histogram on my join coverage data — I have matched_rows and source_rows for each day from 2024-01-01 to 2024-01-10 across two dataset groups, use matched_rows as the field, set the base index to row 0, and use 10 bins?","exampleUseCases":[{"title":"ETL pipeline join quality trend","prompt":"I want to see how my join coverage has trended over the past month — I have daily records with matched_rows and source_rows for two dataset groups. Can you index them to base-100 starting from the first row and also give me a histogram of matched_rows using 8 bins?"},{"title":"Data warehouse match rate distribution","prompt":"Here are 150 rows of join coverage data for my warehouse loads with matched_rows and source_rows per date and dataset group. Can you give me an equal-width histogram with 5 bins on the source_rows field and a base-100 series anchored to row 0?"},{"title":"Multi-group join completeness audit","prompt":"I need to audit join completeness across my two dataset groups — can you take these 50 date-stamped records with matched_rows and source_rows, run a base-100 indexed series starting at index 0, and show me a 10-bin frequency histogram on matched_rows?"}],"resultDescription":"Returns two analytical reports: (1) a Base-100 indexed time series normalizing the selected field (matched_rows or source_rows) relative to a chosen baseline row, and (2) an equal-width histogram showing the frequency distribution of values across a configurable number of bins (1–30). Both reports are computed locally from the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Invalid date format (not YYYY-MM-DD) causes validation failure","base_index out of range for the number of supplied rows","bins value outside 1–30 range rejected by schema","Null values in matched_rows or source_rows may affect histogram accuracy","Missing required fields (row_id, date, dataset_group) cause row-level errors"],"whenToPreferThis":"Choose this endpoint when you need both a normalized trend view (Base-100 series) and a frequency distribution (histogram) of join coverage metrics in a single call, without needing external data, predictions, or live lookups. Ideal for data engineers auditing ETL pipeline match rates, data quality analysts reviewing join completeness over time, or anyone wanting fast statistical summaries of matched vs source row counts across up to 200 records for $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:34.861Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-base-100-series-equal-width-histogram-625a9233"}