{"uid":"cap_-uA1eKNVCDD11xDNQxXQc","slug":"join-coverage-analytics-trailing-mean-series-equal-width-histogram-29c7288a","name":"Join Coverage Analytics: Trailing Mean Series + Equal-Width Histogram","description":"Join coverage — Trailing mean series + Equal-width histogram: Trailing mean 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-148?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"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_T2PaH0Yrq0H55EFBOW4k_","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 trailing mean time series and an equal-width histogram for join coverage metrics (matched_rows, source_rows) from up to 200 supplied records.","exampleAgentPrompt":"Can you run a trailing mean series and equal-width histogram on my join coverage data? I have 50 records with matched_rows and source_rows per date, grouped by dataset group — use a window of 7 and 10 bins, analyzing the matched_rows field.","exampleUseCases":[{"title":"Monitor join match rate trends","prompt":"I want to see a smoothed trailing mean of matched_rows over time for my pipeline join coverage records — I have 120 rows with dates and dataset groups, use a rolling window of 5 and analyze the matched_rows field."},{"title":"Distribution of source rows across bins","prompt":"Can you build an equal-width histogram with 8 bins for the source_rows field across my join coverage data? I have about 80 records spanning the last quarter grouped by two dataset groups."},{"title":"Audit join coverage for data quality review","prompt":"For my data quality review, run both a trailing mean series with window size 3 and a 5-bin histogram on the matched_rows in my join coverage records — I have 200 rows across multiple dataset groups and dates."}],"resultDescription":"Returns two analytical reports: (1) a trailing mean series showing smoothed values of the selected field (matched_rows or source_rows) over the date sequence using the specified window size, and (2) an equal-width histogram showing frequency counts across evenly spaced bins for the selected field. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Fewer than 1 or more than 200 rows submitted — validation error","Window size larger than number of rows — trailing mean may produce minimal or no output","Invalid date format (not YYYY-MM-DD) — schema validation failure","Bins set outside 1–30 range — rejected by schema","Null values in matched_rows or source_rows may affect computation accuracy","Missing required fields (row_id, date, dataset_group) — request rejected"],"whenToPreferThis":"Choose this endpoint when you have up to 200 join coverage records with matched_rows and source_rows and need both a smoothed time-series trend (trailing mean) and a frequency distribution (histogram) in a single low-cost call. Ideal for data engineers or analysts who want quick statistical summaries of join quality metrics without setting up local analytics tooling. Prefer this over generic stats APIs when your data is framed specifically around join coverage with dataset groups and dated records.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:36.659Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-trailing-mean-series-equal-width-histogram-29c7288a"}