{"uid":"cap_5NjFGGSxl0dGT4IpiGv-5","slug":"join-coverage-trailing-mean-series-base-100-series-f2a60cf6","name":"Join Coverage — Trailing Mean Series + Base-100 Series","description":"Join coverage — Trailing mean series + Base-100 series: Trailing mean series + Base-100 series 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-147?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"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":0}}},"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_JiEoaqdcokhz_ExpqYxW9","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 moving average series and a base-100 indexed series for join coverage metrics (matched_rows, source_rows) across up to 200 supplied rows.","exampleAgentPrompt":"Analyze my join coverage data for group-a and group-b across October 2026 — compute both a trailing mean series with a window of 3 and a base-100 series starting from index 0 for the matched_rows field across these 4 rows.","exampleUseCases":[{"title":"Monthly join coverage trend smoothing","prompt":"I have daily join coverage records for two dataset groups over the past month. Can you run a trailing mean with a window of 7 on the matched_rows field and also index everything to the first row as base 100, so I can see the smoothed trend and relative change?"},{"title":"Pipeline health baseline comparison","prompt":"Here are 50 rows of source_rows counts from my ingestion pipeline across several dataset groups. Please compute a base-100 series anchored at index 0 and a trailing mean with window 5 on source_rows, so I can benchmark how each group deviates from its starting point."},{"title":"Join ratio anomaly investigation","prompt":"I want to spot anomalies in my join coverage — can you take these 120 daily matched_rows records, apply a trailing mean series with window 4 and a base-100 index from row 0, and show me both series so I can see where things spike or drift?"}],"resultDescription":"Returns two analytical report series for the supplied join coverage rows: (1) a trailing mean series over the chosen field (matched_rows or source_rows) using the specified rolling window, and (2) a base-100 indexed series anchored at the chosen base index row — both computed locally from user-supplied data with no external lookup.","failureModes":["Missing required fields (row_id, date, dataset_group, matched_rows, source_rows) cause validation errors","More than 200 rows submitted — request rejected at schema limit","Window size larger than number of rows may produce incomplete trailing means for early rows","base_index out of bounds for the provided row count","Malformed date strings not matching YYYY-MM-DD pattern fail schema validation","Null values in matched_rows or source_rows may affect series continuity"],"whenToPreferThis":"Choose this endpoint when you have already-collected join coverage data (matched_rows, source_rows) and need two complementary time-series analytics — rolling average smoothing and base-100 normalization — computed together in a single call for up to 200 rows. It is ideal for data engineers monitoring pipeline join health over time who want trend smoothing and relative baseline comparison without any external data fetching or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:36.104Z","isFirstParty":false,"canonicalSlug":"join-coverage-trailing-mean-series-base-100-series-f2a60cf6"}