{"uid":"cap_aqU77__ylTLaBfYmeXLCm","slug":"join-coverage-grouped-numeric-summary-category-frequencies-1ff0d069","name":"Join Coverage — Grouped Numeric Summary + Category Frequencies","description":"Join coverage — Grouped numeric summary + Category frequencies: Grouped numeric summary + Category frequencies 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-086?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"}}},"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_UZPQAPfdDWzT-0BNdKet-","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 grouped numeric summary statistics and category frequency distributions for join coverage records (matched_rows, source_rows) across up to 200 rows.","exampleAgentPrompt":"I have join coverage records for two groups — group-a and group-b — with matched_rows and source_rows values across dates in October 2026. Can you give me a grouped numeric summary and category frequency breakdown for the matched_rows field across up to 4 rows?","exampleUseCases":[{"title":"ETL pipeline join coverage audit","prompt":"I ran a nightly ETL job and collected join coverage stats — matched_rows and source_rows — for dataset groups 'customers' and 'orders' across the past week. Can you compute a grouped numeric summary and category frequency breakdown for matched_rows so I can see how each group is performing?"},{"title":"Data warehouse match rate analysis","prompt":"I have join coverage data from our data warehouse reconciliation for groups 'transactions' and 'refunds' across 10 dates in November 2026. Please give me grouped summary statistics and category frequencies for source_rows so I can understand the distribution."},{"title":"Multi-group join quality reporting","prompt":"We track join coverage across four dataset groups daily — give me a numeric summary grouped by dataset_group and a frequency count of how often each group appears, using matched_rows as the analysis field, for the 50 rows I'm supplying."}],"resultDescription":"Two analytical reports: (1) a grouped numeric summary (e.g. mean, min, max, std dev) of the selected field (matched_rows or source_rows) broken down by dataset_group, and (2) category frequency counts showing how often each dataset_group appears across the supplied rows. Results are computed locally with no external lookups.","failureModes":["Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) returns validation error","More than 200 rows submitted — request rejected due to maxItems constraint","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Null values in numeric fields may affect summary statistics output","Empty rows array rejected due to minItems: 1 constraint"],"whenToPreferThis":"Choose this endpoint when you have tabular join coverage data (matched_rows, source_rows) segmented by dataset group and date, and need both grouped numeric descriptive statistics and category frequency distributions in a single call without any external data lookup or prediction. Ideal for ETL auditing, data quality monitoring, and reconciliation reporting workflows where you supply the data and want local analytical summaries fast and cheaply.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:44.547Z","isFirstParty":false,"canonicalSlug":"join-coverage-grouped-numeric-summary-category-frequencies-1ff0d069"}