{"uid":"cap_J6u8EjN_PdCE1ZN_Wx20S","slug":"data-reconciliation-grouped-numeric-summary-category-frequencies-937cbaba","name":"Data Reconciliation — Grouped Numeric Summary + Category Frequencies","description":"Data reconciliation — Grouped numeric summary + Category frequencies: Grouped numeric summary + Category frequencies for supplied data reconciliation records (source_total, target_total). 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-11-086?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_total","target_total"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_total":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"target_total":{"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","source_total":10,"target_total":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_total":20,"target_total":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_total":15,"target_total":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_total":30,"target_total":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["source_total","target_total"],"type":"string","default":"source_total"}}},"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_kWA0e4lavJCunu9gsbDtz","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 grouped numeric statistics and category frequency distributions for data reconciliation records containing source and target totals, processing up to 200 rows in two independent analytical reports.","exampleAgentPrompt":"Analyze these 150 reconciliation records for me — group them by dataset_group and give me a numeric summary of source_total values, plus frequency counts for each category.","exampleUseCases":[{"title":"Daily ETL reconciliation audit","prompt":"I have 120 rows of yesterday's ETL reconciliation data with source_total and target_total figures across three dataset groups — can you give me a grouped numeric summary and show me how frequently each group appears?"},{"title":"Monthly financial close discrepancy review","prompt":"Here are 200 month-end reconciliation records across our finance groups. Summarize the source_total field numerically by dataset_group and tell me the category breakdown so I can spot which groups have the most records."},{"title":"Data pipeline health check","prompt":"Run a grouped summary and category frequency analysis on these 80 pipeline reconciliation records — I want to see min, max, and average of target_total by group and how many rows fall into each dataset category."}],"resultDescription":"Returns two independent analytical reports: (1) a grouped numeric summary (e.g. count, min, max, mean, sum) of the chosen field — source_total or target_total — broken down by dataset_group, and (2) category frequency counts showing how many records belong to each dataset_group, all computed locally without external lookups.","failureModes":["Fewer than 1 row or more than 200 rows submitted returns a validation error","Missing required fields (row_id, dataset_group, date, source_total, target_total) causes rejection","Date strings not matching YYYY-MM-DD pattern fail schema validation","Numeric values outside ±1,000,000,000,000 are rejected","Invalid field enum value (not 'source_total' or 'target_total') causes an error"],"whenToPreferThis":"Choose this endpoint when you need two quick, serverless analytical views — grouped numeric descriptives and category frequency counts — on a batch of up to 200 reconciliation records with source and target totals, without needing external data enrichment, predictions, or live lookups. It is ideal for lightweight ETL audit checks, financial close reviews, or data quality assessments where you already have the rows in hand and want fast local computation at low cost ($0.01 USDC for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:55.091Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-grouped-numeric-summary-category-frequencies-937cbaba"}