{"uid":"cap_XSEOUyZ08lNxpTKWlCZVy","slug":"time-series-completeness-date-by-category-pivot-keyed-dataset-8eed3746","name":"Time Series Completeness — Date by Category Pivot + Keyed Dataset Comparison","description":"Time series completeness — Date by category pivot + Keyed dataset comparison: Date by category pivot + Keyed dataset comparison 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-188?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"},"other":{"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":21},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","expected_points":3,"observed_points":17},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","expected_points":4,"observed_points":33}],"maxItems":200,"minItems":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_LaRWxRca0H5Noa6cLXyJV","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 by producing a date-by-category pivot table and a keyed dataset comparison report from supplied observed/expected data points.","exampleAgentPrompt":"Can you run a date-by-category pivot and a keyed dataset comparison on my time series completeness records? I have two datasets — the primary rows include dates like 2026-10-01 through 2026-10-04, groups 'group-a' and 'group-b', with observed_points and expected_points values, and a second dataset to compare against — use 'observed_points' as the field to analyze.","exampleUseCases":[{"title":"IoT Sensor Coverage Audit","prompt":"I have two months of IoT sensor readings organized by sensor group and date — each row has observed_points and expected_points. Can you pivot the data by date and group and then compare it against last month's baseline dataset to see where completeness dropped?"},{"title":"Multi-Group Data Pipeline QA","prompt":"We're running a QA check on our ETL pipeline. I've got a primary dataset and a reference dataset, both with observed and expected data point counts by date and dataset_group. Can you generate a date-by-category pivot on observed_points and then do a keyed comparison between the two to flag discrepancies?"},{"title":"Marketing Campaign Metrics Completeness Check","prompt":"I need to audit the completeness of our daily campaign metrics — I have records for two campaign groups over the past week with observed and expected data point counts. Please pivot those by date and category, and compare the current week's dataset against last week's to see where we're missing data."}],"resultDescription":"Returns two analytical reports: (1) a date-by-category pivot table showing the selected field (observed_points or expected_points) broken down by date and dataset_group, and (2) a keyed dataset comparison between the primary rows and the secondary 'other' dataset, highlighting differences in completeness metrics. Up to 200 rows processed per call.","failureModes":["Empty rows array — request rejected (minItems: 1)","Rows exceed 200 — request rejected (maxItems: 200)","Invalid date format (not YYYY-MM-DD) — validation error","Missing required fields (row_id, dataset_group, date, observed_points, expected_points) — schema validation failure","Invalid field enum value (not 'observed_points' or 'expected_points') — error","Numeric values outside allowed range (±1,000,000,000,000) — validation error","Payment failure — x402 payment not processed, request blocked"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously produce a date-by-category pivot AND compare two versions or snapshots of a time series completeness dataset in a single paid call. It is ideal for data quality audits, ETL validation, and completeness monitoring where you have structured rows with observed vs. expected point counts grouped by category and date. Prefer this over single-report endpoints when you need both pivot and comparison analytics at once to minimize cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:43:10.180Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-date-by-category-pivot-keyed-dataset-8eed3746"}