{"uid":"cap_PtQsqdaq1jw-p-y66KArF","slug":"join-coverage-analytics-grouped-numeric-summary-numeric-row-ordering-1bc911e9","name":"Join Coverage Analytics: Grouped Numeric Summary + Numeric Row Ordering","description":"Join coverage — Grouped numeric summary + Numeric row ordering: Grouped numeric summary + Numeric row ordering 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-087?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_IR85ekrFfjNPETU08k2TD","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 numeric row ordering for join coverage data (matched_rows, source_rows) across up to 200 supplied records, returning two analytical reports.","exampleAgentPrompt":"Can you run a grouped numeric summary and row ordering on my join coverage data? I have 4 rows — row-1 through row-4 dated 2026-10-01 to 2026-10-04, with matched_rows of 10, 20, 15, 30 and source_rows of 1, 2, 3, 4 across groups group-a and group-b — and I want the analysis focused on matched_rows.","exampleUseCases":[{"title":"ETL pipeline join quality audit","prompt":"I have join coverage data for our ETL pipeline across two dataset groups — can you give me a grouped numeric summary and row ordering for matched_rows? Here are 6 records with row IDs etl-1 through etl-6, dates from 2026-11-01 to 2026-11-06, matched_rows ranging from 50 to 300, source_rows from 10 to 60, split between groups 'warehouse' and 'staging'."},{"title":"Data reconciliation coverage review","prompt":"Run a grouped summary and numeric ordering on these source_rows figures for my data reconciliation job — I've got 8 records dated 2025-03-10 through 2025-03-17, row IDs recon-1 to recon-8, matched_rows between 100 and 800, source_rows between 90 and 750, across dataset groups 'customers' and 'orders'. Use source_rows as the field to analyze."},{"title":"Daily join match rate comparison","prompt":"Can you summarize and rank this daily join coverage report by matched_rows? I have 5 rows — daily-2025-01 through daily-2025-05 — with dates 2025-06-01 to 2025-06-05, matched_rows of 200, 180, 220, 195, 210, source_rows of 200, 200, 220, 200, 210, all in dataset group 'transactions'. I want the grouped numeric summary and ordering report."}],"resultDescription":"Returns two analytical reports: (1) a grouped numeric summary aggregating matched_rows or source_rows statistics by dataset_group, and (2) a numeric row ordering ranking the supplied rows by the chosen field. Both reports are derived entirely from the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request rejected","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — validation error","Date field does not match YYYY-MM-DD format — validation error","Invalid field enum value (must be 'matched_rows' or 'source_rows') — validation error","Empty rows array — validation error","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) — validation error","Payment not completed via x402 protocol — request not processed"],"whenToPreferThis":"Choose this endpoint when you have join coverage records with matched_rows and source_rows metrics and need both a grouped aggregate summary by dataset_group and a numeric ordering of individual rows in a single call. It is ideal for data engineers auditing ETL join quality, data reconciliation analysts comparing match rates across groups, or any workflow needing two complementary analytical views on join coverage data without any external data enrichment or prediction.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:54:11.630Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-grouped-numeric-summary-numeric-row-ordering-1bc911e9"}