{"uid":"cap_VdMSk9Rc1ZHHrtaT9Kglj","slug":"schema-conformity-analytics-weighted-mean-date-category-pivot-0d61f847","name":"Schema Conformity Analytics: Weighted Mean & Date-Category Pivot","description":"Schema conformity — Secondary-measure weighted mean + Date by category pivot: Secondary-measure weighted mean + 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-185?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"}}},"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_za2N9N8Ke-EGmssEnS0yr","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 weighted mean of a secondary measure and a date-by-category pivot table for schema conformity records (valid_records, checked_records) across up to 200 rows.","exampleAgentPrompt":"Can you run a weighted mean on valid_records and also pivot those schema conformity records by date and dataset_group? I have about 50 rows with row_id, dataset_group, date, valid_records, and checked_records fields.","exampleUseCases":[{"title":"Data quality dashboard aggregation","prompt":"I have 120 rows of schema conformity data with columns row_id, dataset_group, date, valid_records, and checked_records — can you compute the weighted mean of valid_records and also give me a pivot table broken down by date and dataset_group?"},{"title":"Multi-group conformity trend analysis","prompt":"We're tracking schema validation results across group-a and group-b over October. Can you take these conformity records and produce both a weighted mean of checked_records and a date-by-category pivot so I can see trends per group?"},{"title":"Batch reporting for schema audit","prompt":"I need two reports on this conformity dataset — a secondary-measure weighted mean using checked_records as the weight field and a date-by-category pivot — for up to 180 rows. Can you run both at once?"}],"resultDescription":"Returns two analytical reports computed from the supplied schema conformity rows: (1) a weighted mean of the selected measure (valid_records or checked_records) weighted by the secondary measure, and (2) a date-by-category pivot table grouping conformity counts by date and dataset_group. Both reports are derived locally from the submitted data with no external lookups.","failureModes":["Missing required fields (row_id, date, valid_records, checked_records) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","Submitting more than 200 rows exceeds the row limit and returns an error","Null numeric values may affect weighted mean computation if all weights are null","Empty rows array is rejected (minItems: 1)","Invalid field enum value (not 'valid_records' or 'checked_records') causes rejection"],"whenToPreferThis":"Choose this endpoint when you need both a weighted mean and a date-by-category pivot on schema conformity data (valid_records, checked_records) in a single low-cost call. It is ideal for data quality monitoring pipelines where you want two complementary analytical views — aggregation and cross-tab — without building custom analytics. Best suited for batch analysis of up to 200 conformity records at $0.01 USDC per call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-14T00:36:09.593Z","isFirstParty":false,"canonicalSlug":"schema-conformity-analytics-weighted-mean-date-category-pivot-0d61f847"}