{"uid":"cap_pRwnLgbLUG54s1eFu5a-z","slug":"time-series-completeness-duplicate-key-report-secondary-measure-b99ef39f","name":"Time Series Completeness — Duplicate Key Report + Secondary-Measure Weighted Mean","description":"Time series completeness — Duplicate key report + Secondary-measure weighted mean: Duplicate key report + Secondary-measure weighted mean for supplied time series completeness records (observed_points, expected_points). 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-16-067?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","observed_points","expected_points"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"expected_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"observed_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","expected_points":1,"observed_points":10},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","expected_points":2,"observed_points":20},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","expected_points":3,"observed_points":15},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","expected_points":4,"observed_points":30}],"maxItems":200,"minItems":1},"field":{"enum":["observed_points","expected_points"],"type":"string","default":"observed_points"}}},"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_45wmnqK4qeCI5UrcVf7Jj","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":"Analyzes supplied time series completeness records to produce a duplicate key report and a secondary-measure weighted mean, using shared local analytical engines — no external lookups.","exampleAgentPrompt":"Can you run a duplicate key report and compute a weighted mean of observed_points for these completeness records — I have 4 rows with dates 2026-10-01 through 2026-10-04, row IDs row-1 to row-4, groups group-a and group-b, with observed_points 10, 20, 15, 30 and expected_points 1, 2, 3, 4?","exampleUseCases":[{"title":"Daily sensor feed completeness audit","prompt":"I have daily completeness logs for two sensor groups over the past week — each row has a date, a group name, observed data points, and expected points. Can you check for any duplicate row IDs and compute the weighted mean of observed_points across all rows?"},{"title":"ETL pipeline data quality check","prompt":"After our nightly ETL run I need to validate our completeness table — run a duplicate key report on these 150 rows and also give me the secondary-measure weighted mean using expected_points as the field, so I can spot any anomalies before the morning report."},{"title":"Multi-group time series completeness summary","prompt":"We track completeness across three dataset groups daily. Here are about 80 rows with row_id, dataset_group, date, observed_points, and expected_points — can you produce both a duplicate key report and a weighted mean of observed_points so I can summarize data quality for my team?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any rows with repeated key combinations, and (2) a weighted mean of the selected secondary measure (observed_points or expected_points) across the supplied rows — computed locally with no external data access, covering up to 200 input rows.","failureModes":["Input exceeds 200 rows — request rejected","Missing required fields (row_id, date, observed_points, expected_points) — validation error","Invalid date format not matching YYYY-MM-DD pattern — schema rejection","Null values in numeric fields may affect weighted mean computation","Empty rows array — minimum 1 item required"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous analytical operations on a batch of time series completeness records — duplicate key detection plus weighted mean computation — without any external data lookups or predictions. Ideal for data quality pipelines, ETL validation, and completeness monitoring workflows where you supply your own data (up to 200 rows) and need fast, local statistical analysis at low cost ($0.01 USDC for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:27.204Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-duplicate-key-report-secondary-measure-b99ef39f"}