{"uid":"cap_NM0v5n2M3eD69u-Ov9VEH","slug":"time-series-completeness-weighted-mean-date-by-category-pivot-dc703ce0","name":"Time Series Completeness: Weighted Mean + Date-by-Category Pivot","description":"Time series completeness — Secondary-measure weighted mean + Date by category pivot: Secondary-measure weighted mean + Date by category pivot 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-185?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_nwT2S8SaSmRoA-x_o6vk0","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 secondary-measure weighted mean and a date-by-category pivot table for up to 200 time series completeness records (observed_points vs expected_points) in a single call.","exampleAgentPrompt":"I have completeness records for two dataset groups over 4 days — group-a and group-b — with observed_points and expected_points for each day. Can you run a weighted mean and a date-by-category pivot on the observed_points field for those rows?","exampleUseCases":[{"title":"Daily pipeline completeness report","prompt":"I'm tracking data pipeline completeness for 'pipeline-alpha' and 'pipeline-beta' across the last 30 days. Each row has a date, observed_points, and expected_points. Can you compute the weighted mean and a date-by-group pivot table on the expected_points field so I can see where coverage drops?"},{"title":"Sensor coverage gap analysis","prompt":"We have completeness records for three sensor groups — 'region-north', 'region-south', and 'region-east' — over the past two weeks, with observed and expected point counts per day. Run a secondary-measure weighted mean plus a date-by-category pivot on observed_points so I can spot coverage gaps by region and date."},{"title":"ETL job monitoring summary","prompt":"I need to review completeness for our ETL jobs across 'batch-1' and 'batch-2' dataset groups for October. I have about 60 rows with date, observed_points, and expected_points. Give me the weighted mean and a pivot of observed_points by date and group."}],"resultDescription":"Returns two analytical reports: (1) a secondary-measure weighted mean of the selected field (observed_points or expected_points) across the supplied rows, and (2) a date-by-category pivot table cross-tabulating values by date and dataset_group — both computed locally without external lookups, covering up to 200 input rows.","failureModes":["More than 200 rows submitted — request rejected or truncated","Missing required fields (row_id, date, dataset_group, observed_points, expected_points) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Null values in observed_points or expected_points may affect weighted mean calculation","Invalid field enum value (not 'observed_points' or 'expected_points') — rejected"],"whenToPreferThis":"Choose this endpoint when you need both a weighted mean aggregation and a date-by-category pivot on time series completeness data (observed vs expected points) in a single cheap call ($0.01 USDC). Ideal for lightweight, local analytics on up to 200 rows without needing external data sources, predictions, or ML models. Best suited for data quality monitoring, pipeline completeness dashboards, and coverage reporting scenarios where you control the input data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:39:14.523Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-weighted-mean-date-by-category-pivot-dc703ce0"}