{"uid":"cap_93A-DmlSwvhcRqw38_l7o","slug":"join-coverage-analytics-grouped-numeric-summary-two-measure-correlation-4ceae5d6","name":"Join Coverage Analytics: Grouped Numeric Summary + Two-Measure Correlation","description":"Join coverage — Grouped numeric summary + Two-measure correlation: Grouped numeric summary + Two-measure correlation 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-095?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_BT2Vl7m4c5B6VvS4MsloQ","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 a grouped numeric summary and a two-measure correlation report for join coverage data (matched_rows, source_rows) across up to 200 supplied rows.","exampleAgentPrompt":"I have join coverage records for two groups — 'group-a' and 'group-b' — with matched_rows and source_rows measured daily from 2026-10-01 to 2026-10-04. Can you run a grouped numeric summary and a two-measure correlation report on the matched_rows field for me?","exampleUseCases":[{"title":"Daily join rate audit by dataset group","prompt":"I've got 4 days of join coverage data across two dataset groups. Can you give me a grouped numeric summary of matched_rows so I can see how each group is performing, plus a correlation between matched_rows and source_rows to spot any trends?"},{"title":"Pipeline health statistics for ETL review","prompt":"I'm reviewing our ETL pipeline and I have a CSV with row_id, dataset_group, date, matched_rows, and source_rows for about 150 rows. Run a grouped numeric summary and a correlation report on source_rows for me so I can present it to the team."},{"title":"Correlation check across multiple join datasets","prompt":"We have join coverage records from three different dataset groups collected over the past week. Can you compute both a grouped numeric summary and a two-measure correlation for the matched_rows field so we can see if source volume is driving match rates?"}],"resultDescription":"Returns two independent analytical reports: (1) a grouped numeric summary breaking down statistics for the chosen measure (matched_rows or source_rows) across dataset_group categories, and (2) a two-measure correlation report quantifying the relationship between matched_rows and source_rows across the supplied rows. No external data is fetched; all analysis is performed locally on the provided input.","failureModes":["Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","Submitting more than 200 rows exceeds the maxItems limit","Null values in both numeric fields may produce degenerate correlation results","Invalid field enum value (not 'matched_rows' or 'source_rows') causes rejection","Empty rows array fails minItems validation"],"whenToPreferThis":"Use this endpoint when you have pre-collected join coverage records (matched_rows, source_rows) and need both a grouped statistical summary and a correlation analysis in a single low-cost call. Ideal for data engineering teams reviewing ETL pipeline join quality across multiple dataset groups without needing live data fetching, predictions, or external integrations. Prefer over general analytics platforms when you need a quick, deterministic, self-contained computation on up to 200 rows for $0.01.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:38.421Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-grouped-numeric-summary-two-measure-correlation-4ceae5d6"}