{"uid":"cap_KYSz8m7YtpFc_eyp9E8NH","slug":"time-series-completeness-adjacent-row-changes-date-by-category-pivot-beb2cd3c","name":"Time Series Completeness — Adjacent Row Changes & Date-by-Category Pivot","description":"Time series completeness — Adjacent row changes + Date by category pivot: Adjacent row changes + 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-160?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_kWrBKOhiTWnRAK83Q4g1o","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 time series completeness records to produce two reports: adjacent row change analysis and a date-by-category pivot table, for up to 200 rows.","exampleAgentPrompt":"Can you run two completeness reports on my time series data — one showing adjacent row changes and one pivoting observed_points by date and dataset group? Here are the rows: [{\"row_id\":\"r1\",\"dataset_group\":\"sensors\",\"date\":\"2025-01-01\",\"observed_points\":95,\"expected_points\":100},{\"row_id\":\"r2\",\"dataset_group\":\"sensors\",\"date\":\"2025-01-02\",\"observed_points\":88,\"expected_points\":100}].","exampleUseCases":[{"title":"Daily sensor data completeness audit","prompt":"I have daily sensor readings for January — can you run adjacent row change and date-by-category pivot reports on these completeness records to see where observed_points dropped relative to expected_points? Here are 30 rows with row_id, dataset_group, date, observed_points, and expected_points fields."},{"title":"Multi-group ETL pipeline gap detection","prompt":"We have two ETL pipeline groups, 'pipeline-A' and 'pipeline-B', and I want to spot completeness gaps across dates. Run both the adjacent row changes report and the date-by-category pivot on these 120 completeness records for the observed_points field."},{"title":"Weekly reporting on data ingestion completeness","prompt":"For our weekly data quality review, can you analyze these completeness records — about 80 rows covering last week across three dataset groups — and give me the row-to-row change analysis plus a pivot of observed_points by date and category?"}],"resultDescription":"Returns two analytical reports: (1) an adjacent row changes report showing how observed_points or expected_points shift between consecutive rows, and (2) a date-by-category pivot table summarizing the selected metric across dataset groups and dates — all computed locally from the supplied data, no external lookups.","failureModes":["Input rows exceed 200 item limit — request will be rejected","Missing required fields (row_id, dataset_group, date, observed_points, expected_points) cause validation failure","Invalid date format (not YYYY-MM-DD) triggers pattern validation error","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) rejected","Payment of 0.01 USDC not fulfilled — endpoint returns 402","Empty rows array not accepted (minItems: 1)"],"whenToPreferThis":"Choose this endpoint when you need two complementary completeness reports — adjacent row change analysis and date-by-category pivot — in a single low-cost call ($0.01 USDC) on up to 200 rows of time series completeness data. Ideal for data quality audits, ETL monitoring, and reporting workflows where you already have the completeness records and need fast local analytical computation without any external data lookup or live prediction.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:37:50.989Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-adjacent-row-changes-date-by-category-pivot-beb2cd3c"}