{"uid":"cap_ASDEOtEfdg_pGLFBoTD8B","slug":"join-coverage-analytics-category-frequencies-equal-width-histogram-991baa0a","name":"Join Coverage Analytics: Category Frequencies + Equal-Width Histogram","description":"Join coverage — Category frequencies + Equal-width histogram: Category frequencies + 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-106?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"}}},"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_shKKhdGrpQRo8Ho3YJgWP","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":"Computes category frequency counts and an equal-width histogram for join coverage metrics (matched_rows, source_rows) across up to 200 supplied records.","exampleAgentPrompt":"Analyze my join coverage data — I have 150 records with matched_rows and source_rows across two groups (group-a and group-b) from October 2026. Give me category frequencies by dataset_group and an equal-width histogram with 10 bins on the matched_rows field.","exampleUseCases":[{"title":"Profiling join match rates by dataset group","prompt":"I've got join coverage results from last quarter — about 120 rows with matched_rows, source_rows, and dataset_group labels. Can you break down how often each group appears and show me a histogram with 8 bins on matched_rows so I can see where coverage clusters?"},{"title":"Auditing source row distribution in a data pipeline","prompt":"I need to audit the distribution of source_rows in my pipeline's join coverage output — I have 80 records from different dates and groups. Can you run a 5-bin equal-width histogram on source_rows and tell me the category frequencies by dataset_group?"},{"title":"Spotting coverage gaps in a multi-group join","prompt":"We merged two datasets last week and I want to understand the join coverage. I have 200 records with matched_rows and source_rows across four dataset groups. Please compute category frequencies for each group and a 15-bin histogram on matched_rows."}],"resultDescription":"Returns two analytical reports: (1) a category frequency table showing how often each dataset_group value appears in the supplied records, and (2) an equal-width histogram of the chosen numeric field (matched_rows or source_rows) divided into the specified number of bins (1–30). Both reports are computed locally from the submitted data with no external lookups.","failureModes":["Submitting more than 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) cause schema rejection","Invalid date format (not YYYY-MM-DD) fails pattern validation","Bins value outside 1–30 range is rejected","All null values in the target numeric field may produce an empty or degenerate histogram","Payment of 0.01 USDC not completed causes 402 rejection"],"whenToPreferThis":"Choose this endpoint when you have pre-collected join coverage records (matched_rows, source_rows) and need both a categorical frequency breakdown by dataset group AND a numeric histogram in a single call. It is ideal for data engineers auditing pipeline join quality, analysts profiling match rates, or workflows that need offline/local statistical summaries without any external data enrichment or prediction. Prefer over single-report alternatives when you want both reports (category + histogram) at once for the same dataset.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:40.207Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-category-frequencies-equal-width-histogram-991baa0a"}