{"uid":"cap_qG8IkoOwIEdmH6jp9UrIO","slug":"validation-rule-results-analytics-numeric-row-ordering-date-by-63ae1bf2","name":"Validation Rule Results Analytics — Numeric Row Ordering + Date by Category Pivot","description":"Validation rule results — Numeric row ordering + Date by category pivot: Numeric row ordering + Date by category pivot for supplied validation rule results records (passed_rules, total_rules). 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-08-122?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","passed_rules","total_rules"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rules":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"passed_rules":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rules":1,"passed_rules":10,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","total_rules":2,"passed_rules":20,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","total_rules":3,"passed_rules":15,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","total_rules":4,"passed_rules":30,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["passed_rules","total_rules"],"type":"string","default":"passed_rules"}}},"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_LMELMA_VEo8bWmF_QFgJ7","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":"Generates two local analytical reports (numeric row ordering and date-by-category pivot) from supplied validation rule result records containing passed_rules and total_rules fields.","exampleAgentPrompt":"I have 4 validation rule records for two dataset groups — group-a on 2026-10-01 with 10 passed out of 1 total and on 2026-10-03 with 15 passed out of 3 total, and group-b on 2026-10-02 with 20 passed out of 2 total and on 2026-10-04 with 30 passed out of 4 total — can you give me both a numeric row ordering and a date-by-category pivot on the passed_rules field?","exampleUseCases":[{"title":"Data pipeline quality audit ranking","prompt":"I've got validation results from our nightly pipeline run — 6 rows across two dataset groups with dates ranging from 2026-09-01 to 2026-09-06 and passed_rules counts like 5, 12, 8, 20, 3, 17 out of various totals — rank them numerically by passed_rules and also pivot the passed_rules by date and group so I can see which groups improved over the week."},{"title":"Compliance dashboard pivot by team","prompt":"Our compliance team tracks rule checks per department every day — I have 10 records with group names like 'finance' and 'ops' and dates from 2026-11-01 to 2026-11-10, each with passed_rules and total_rules — give me the numeric ordering report and the date-by-category pivot on total_rules so we can see who's running the most checks."},{"title":"Data quality regression investigation","prompt":"After our last schema change I want to investigate which dataset groups regressed — I have 8 validation records across groups 'raw_ingest' and 'transformed' from 2026-08-15 to 2026-08-22 with passed_rules counts between 0 and 50 — sort them numerically and pivot by date and group on passed_rules so I can spot the dip."}],"resultDescription":"Returns two analytical reports computed entirely from the supplied data: (1) a numeric row ordering report ranking rows by the selected field (passed_rules or total_rules), and (2) a date-by-category pivot table showing field values broken down by date and dataset_group. No external data is fetched; all computation is local.","failureModes":["Missing required fields (row_id, dataset_group, date, passed_rules, total_rules) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","More than 200 rows submitted exceeds the maxItems limit","Invalid field enum value (anything other than passed_rules or total_rules) causes rejection","All-null numeric values may yield empty or degenerate reports","Payment of 0.01 USDC not submitted correctly via x402 protocol results in 402 response"],"whenToPreferThis":"Choose this endpoint when you have up to 200 validation rule result records (with passed_rules and total_rules counts) and need both a ranked numeric ordering and a date-by-category pivot in a single low-cost call. It is ideal for data quality audits, compliance reporting, and pipeline health dashboards where you supply the data and need fast local analytics 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-12T12:51:39.058Z","isFirstParty":false,"canonicalSlug":"validation-rule-results-analytics-numeric-row-ordering-date-by-63ae1bf2"}