{"uid":"cap_b27KAFZ7Ooc63_TiudIEj","slug":"time-series-completeness-base-100-series-date-by-category-pivot-246b79f8","name":"Time Series Completeness — Base-100 Series + Date by Category Pivot","description":"Time series completeness — Base-100 series + Date by category pivot: Base-100 series + 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-167?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"},"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_Nc-gG6CxQGpXrnnlIbZn8","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 Base-100 indexed time series and a date-by-category pivot table from supplied time series completeness records (observed vs expected data points), returning two analytical reports in one call.","exampleAgentPrompt":"I have completeness records for two dataset groups — group-a and group-b — across dates in October 2026 with observed and expected point counts. Can you run a base-100 series analysis indexed from row 0 on the observed_points field, plus a date-by-category pivot, for up to 4 rows of data?","exampleUseCases":[{"title":"Daily pipeline completeness audit","prompt":"I have daily observed and expected data point counts for three pipeline groups across the past month. Can you index the observed_points as a base-100 series starting from day 0, and also give me a date-by-category pivot so I can see which groups are falling behind?"},{"title":"Sensor coverage gap analysis","prompt":"I want to check completeness for my IoT sensor feeds — I have observed and expected readings per sensor group by date. Run a base-100 index on expected_points from the first row and pivot the results by date and sensor group so I can spot coverage gaps."},{"title":"Reporting dataset validation","prompt":"Before I finalize my monthly report, I need to verify how complete my datasets are — I have 50 rows of observed vs expected point counts grouped by dataset category and date. Can you give me both a base-100 normalized series and a date-by-category pivot on the observed_points?"}],"resultDescription":"Returns two analytical reports: (1) a Base-100 indexed time series normalizing the selected field (observed_points or expected_points) relative to the specified base row, and (2) a date-by-category pivot table cross-tabulating the field values by date and dataset_group. Both reports are derived from the supplied rows with no external data or live lookups.","failureModes":["Exceeding 200 rows causes rejection — keep input to maxItems:200","Missing required fields (row_id, dataset_group, date, observed_points, expected_points) cause validation errors","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","base_index out of range (0–199) or pointing to a non-existent row index causes computation error","Null values in observed_points or expected_points may affect base-100 indexing accuracy","Payment failure (insufficient USDC balance or x402 protocol error) returns 402 response"],"whenToPreferThis":"Choose this endpoint when you need both a normalized base-100 time series view and a date-by-category pivot for data completeness records in a single low-cost call. It is ideal for data engineering and data quality workflows where you are tracking observed vs expected data point counts across multiple groups over time and want two complementary analytical views without writing custom code. Prefer this over generic analytics tools when your data fits within 200 rows and you want instant structured output for completeness auditing.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:38:08.187Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-base-100-series-date-by-category-pivot-246b79f8"}