{"uid":"cap_FB9tLK0pP9YqdvoHf98f-","slug":"time-series-completeness-duplicate-key-report-date-by-category-pivot-211b8158","name":"Time Series Completeness — Duplicate Key Report + Date by Category Pivot","description":"Time series completeness — Duplicate key report + Date by category pivot: Duplicate key report + 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-068?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_LTAciodooGKaEbL1oI-G0","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 a duplicate key report and a date-by-category pivot table for up to 200 rows.","exampleAgentPrompt":"Can you run a duplicate key report and date-by-category pivot on my time series completeness data? I have rows with row_id, dataset_group, date, observed_points, and expected_points — here are my 20 records, and I want to analyze the observed_points field.","exampleUseCases":[{"title":"Audit ETL pipeline completeness logs","prompt":"I have completeness records from our ETL pipeline — each row has a row_id, dataset_group, date, and observed vs expected data points. Can you run a duplicate key check and pivot the results by date and dataset group so I can spot where data is missing or repeated? I'll pass in about 80 rows and want to analyze the observed_points field."},{"title":"Detect duplicate sensor readings by date","prompt":"We're ingesting sensor completeness data and I think some row IDs are being duplicated. Can you run a duplicate key report and show me a date-by-category pivot for these 150 records? The fields are row_id, dataset_group, date, observed_points, and expected_points — check the observed_points column."},{"title":"Validate data export completeness by group","prompt":"Before I sign off on this data export, I need to check for any duplicate row IDs and see a pivot of completeness by date and dataset group. I have 50 rows with observed and expected point counts — can you generate both the duplicate key report and the date-category pivot for the expected_points field?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying row_ids that appear more than once in the supplied data, and (2) a date-by-category pivot table cross-tabulating the selected metric (observed_points or expected_points) across dates and dataset_group categories. Both reports are computed locally on the supplied data with no external lookups.","failureModes":["Fewer than 1 row provided — returns validation error","More than 200 rows submitted — rejected, maxItems limit exceeded","Invalid date format (not YYYY-MM-DD) — schema validation failure","Missing required fields (row_id, date, observed_points, expected_points) — request rejected","Invalid field enum value (not 'observed_points' or 'expected_points') — schema error","Numeric values outside allowed range — validation error"],"whenToPreferThis":"Choose this endpoint when you need both duplicate key detection and date-by-category pivot analysis on time series completeness records in a single $0.01 call. Ideal when your data has fewer than 200 rows and you want offline, deterministic analysis with no external data lookups. Prefer this over general analytics APIs when your data includes observed_points and expected_points completeness metrics grouped by dataset_group and date.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:39:02.938Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-duplicate-key-report-date-by-category-pivot-211b8158"}