{"uid":"cap_Yd0q_mia6x_9yzd2pD75l","slug":"schema-conformity-analytics-category-frequencies-date-by-category-pivot-e871db07","name":"Schema Conformity Analytics: Category Frequencies + Date-by-Category Pivot","description":"Schema conformity — Category frequencies + Date by category pivot: Category frequencies + 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-110?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_kMBGibOxwfzK2Ig3y3AhD","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 schema conformity records (valid_records, checked_records) to produce two reports: category frequency counts and a date-by-category pivot table, for up to 200 rows.","exampleAgentPrompt":"I have schema conformity records for four dataset groups — group-a and group-b — with dates from 2026-10-01 to 2026-10-04 and valid_records counts. Can you give me both a category frequency breakdown and a date-by-category pivot for the valid_records field?","exampleUseCases":[{"title":"Data Quality Audit by Team","prompt":"I have 150 rows of schema conformity data across five dataset groups, each with a date, valid_records, and checked_records. Can you give me category frequencies and a date-by-category pivot so I can see which groups have the most conformity issues over the past month?"},{"title":"Daily Validation Pipeline Summary","prompt":"My pipeline logs schema conformity results daily — each row has a dataset_group, a date, and counts for valid_records and checked_records. Run both the category frequency and the date-by-category pivot on checked_records so I can review the summary for the last 30 days."},{"title":"Comparing Valid vs Checked Records Distribution","prompt":"I've got conformity records for three dataset groups across two weeks. Can you analyze the valid_records field and produce both a category frequency table and a pivot of valid_records by date and group, so I can spot which group is most frequently out of conformity?"}],"resultDescription":"Returns two independent analytical reports: (1) category frequency counts showing how often each dataset_group appears in the supplied rows, and (2) a date-by-category pivot table showing the selected field (valid_records or checked_records) aggregated by date and dataset_group. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Fewer than 1 row supplied — request rejected (minItems: 1)","More than 200 rows supplied — request rejected (maxItems: 200)","Missing required fields (row_id, dataset_group, date, valid_records, checked_records) — validation error","Date field not matching YYYY-MM-DD pattern — validation error","Invalid field enum value (not valid_records or checked_records) — validation error","Null values in numeric fields may affect aggregation results","Payment of 0.01 USDC not completed — request blocked by x402 payment protocol"],"whenToPreferThis":"Choose this endpoint when you need two complementary analytical views — category frequencies 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 pipelines, validation audits, or compliance reporting where you want to understand distribution by group and trends over time without building custom aggregation logic. Prefer it over general-purpose analytics tools when your data fits the strict schema (up to 200 rows, with row_id, dataset_group, date, valid_records, checked_records) and you want a deterministic, reproducible offline computation for $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T00:47:22.900Z","isFirstParty":false,"canonicalSlug":"schema-conformity-analytics-category-frequencies-date-by-category-pivot-e871db07"}