{"uid":"cap_liD1yTxO8mZWaeKEe-hHl","slug":"time-series-completeness-numeric-interval-filter-date-by-category-pivot-57e25c93","name":"Time Series Completeness — Numeric Interval Filter + Date by Category Pivot","description":"Time series completeness — Numeric interval filter + Date by category pivot: Numeric interval filter + 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-133?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"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_9nQG_g_mbD8rQhsYBsI5Z","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 (observed vs expected points) using a numeric interval filter and a date-by-category pivot table, delivering two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have 50 time series completeness records with observed_points and expected_points per dataset group and date — can you run a numeric interval filter keeping rows where observed_points is between 0 and 100, and also generate a date-by-category pivot, using my supplied data?","exampleUseCases":[{"title":"Data pipeline completeness audit","prompt":"I have daily completeness logs for two data pipelines — group-alpha and group-beta — with observed and expected point counts from the past month. Can you filter rows where expected_points falls between 5 and 50, and also pivot the data by date and group so I can see coverage at a glance?"},{"title":"Monitoring dashboard completeness slice","prompt":"Here are 120 completeness records across four sensor dataset groups. Run a numeric interval filter on observed_points between 10 and 200 to isolate mid-range rows, and give me a date-by-category pivot so I can see which groups had data on which days."},{"title":"QA report for time series ingestion","prompt":"I'm doing a QA review — I have completeness records with observed vs expected points for three dataset groups over the last quarter. Filter for rows where observed_points is between 0 and 80, and pivot by date and category so I can spot gaps in ingestion."}],"resultDescription":"Returns two analytical reports: (1) a numeric interval-filtered subset of the input rows where the selected field (observed_points or expected_points) falls within the specified minimum/maximum range, and (2) a date-by-category pivot table aggregating completeness metrics across dataset groups and dates. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, date, observed_points, expected_points) — validation error","Date field does not match YYYY-MM-DD pattern — schema validation failure","minimum greater than maximum causing empty interval filter result","Payment not confirmed (x402 protocol) — 402 response before processing"],"whenToPreferThis":"Choose this endpoint when you need two complementary views of time series completeness data in a single paid call: a numeric range filter to isolate rows within a specific observed/expected point band, plus a date-by-category pivot to visualize group coverage over time. It is ideal for data quality audits, pipeline monitoring, and ingestion QA where you already have the completeness records and need fast local analytics without any external data lookup.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:20.966Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-numeric-interval-filter-date-by-category-pivot-57e25c93"}