{"uid":"cap_hXDTayDG6Eou05UEdx_OK","slug":"schema-conformity-analytics-trailing-mean-series-date-by-category-pivot-b91bf2cf","name":"Schema Conformity Analytics: Trailing Mean Series + Date by Category Pivot","description":"Schema conformity — Trailing mean series + Date by category pivot: Trailing mean series + Date by category pivot for supplied schema conformity records (valid_records, checked_records). 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-02-152?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","valid_records","checked_records"],"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},"valid_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"checked_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","valid_records":10,"checked_records":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","valid_records":20,"checked_records":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","valid_records":15,"checked_records":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","valid_records":30,"checked_records":4}],"maxItems":200,"minItems":1},"field":{"enum":["valid_records","checked_records"],"type":"string","default":"valid_records"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_WueQ2higkuIwV3WHte8Pk","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 trailing moving-average time series and a date-by-category pivot table for schema conformity data (valid_records, checked_records) in a single API call.","exampleAgentPrompt":"Can you run a trailing mean series and a date-by-category pivot on my schema conformity data? I have 4 rows with dataset groups 'group-a' and 'group-b', dates from 2026-10-01 to 2026-10-04, valid_records values of 10, 20, 15, 30 and checked_records of 1, 2, 3, 4 — analyze the valid_records field with a rolling window of 2.","exampleUseCases":[{"title":"Data pipeline quality trend monitoring","prompt":"I want to track how our valid_records are trending over the past week across two dataset groups, 'prod-pipeline' and 'staging-pipeline'. Can you compute a trailing mean with a window of 3 and also pivot the results by date and group? Here are my 10 rows of daily conformity data."},{"title":"Compliance audit schema conformity summary","prompt":"For our compliance audit I need both a rolling average and a date-by-category breakdown of our checked_records across the 'finance' and 'hr' dataset groups. Use a window of 5 and here are the 50 conformity records for last month."},{"title":"Comparing valid vs checked records across teams","prompt":"Can you analyze our schema conformity logs for the 'team-alpha' and 'team-beta' groups? I want a trailing mean series using a window of 4 on the checked_records field, plus a pivot table by date and category — I have about 30 rows covering the past month."}],"resultDescription":"Returns two analytical reports: (1) a trailing moving-average time series for the chosen field (valid_records or checked_records) over the specified window size, and (2) a date-by-category pivot table grouping the same field values by date and dataset_group — both derived from the up-to-200 supplied rows, with no external data lookups.","failureModes":["Fewer than 1 row or more than 200 rows supplied returns a validation error","Window size less than 2 or greater than 200 is rejected","Invalid date format (not YYYY-MM-DD) causes schema rejection","Missing required fields (row_id, dataset_group, date, valid_records, checked_records) cause request failure","Field enum value other than 'valid_records' or 'checked_records' is rejected","Numeric values outside ±1,000,000,000,000 are rejected"],"whenToPreferThis":"Choose this endpoint when you need both a rolling/trailing mean time series AND a pivot-by-category breakdown of schema conformity metrics (valid_records or checked_records) in a single low-cost call. It is ideal for data quality monitoring, governance reporting, or compliance workflows where you supply your own data (up to 200 rows) and need local analytical computation without any external lookups or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:14.562Z","isFirstParty":false,"canonicalSlug":"schema-conformity-analytics-trailing-mean-series-date-by-category-pivot-b91bf2cf"}