{"uid":"cap_0bGPEGD_56b4Y_UU-t66Z","slug":"aggregation-checks-category-frequencies-secondary-measure-weighted-mean-95dadc39","name":"Aggregation Checks — Category Frequencies + Secondary-Measure Weighted Mean","description":"Aggregation checks — Category frequencies + Secondary-measure weighted mean: Category frequencies + Secondary-measure weighted mean for supplied aggregation checks records (source_sum, aggregate_sum). 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-17-109?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_sum","aggregate_sum"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_sum":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"aggregate_sum":{"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_sum":10,"aggregate_sum":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_sum":20,"aggregate_sum":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_sum":15,"aggregate_sum":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_sum":30,"aggregate_sum":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["source_sum","aggregate_sum"],"type":"string","default":"source_sum"}}},"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_qFXk3bvLFl-q4WOBfpvvO","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 category frequencies and a secondary-measure weighted mean for up to 200 rows of aggregation check records containing source_sum and aggregate_sum fields.","exampleAgentPrompt":"Can you run aggregation checks on my dataset — compute category frequencies and a weighted mean for source_sum weighted by aggregate_sum? I have rows with dataset_group values like 'group-a' and 'group-b', dates in 2026, and source_sum values ranging from 10 to 30.","exampleUseCases":[{"title":"Reconciliation data group breakdown","prompt":"I have 150 reconciliation records with a dataset_group, a date, a source_sum, and an aggregate_sum for each row. Can you compute how frequently each category appears and what the weighted mean of source_sum is across those groups?"},{"title":"Audit aggregation totals by category","prompt":"I'm auditing my pipeline and need category frequency counts plus a weighted mean of aggregate_sum across my dataset groups — here are my rows with row IDs, dates, source sums, and aggregate sums. Run the aggregation checks for me."},{"title":"Summarize grouped sales aggregates","prompt":"I've got grouped sales aggregation data — each row has a row_id, date, dataset_group, a source_sum, and an aggregate_sum. Can you give me a frequency breakdown by group and compute the weighted mean of source_sum using aggregate_sum as the weight?"}],"resultDescription":"Two independent analytical reports: (1) frequency counts for each category/dataset_group in the supplied rows, and (2) a weighted mean of the selected numeric field (source_sum or aggregate_sum) weighted by the secondary measure — both computed locally from the submitted data, covering up to 200 rows.","failureModes":["Rows array empty or missing — API returns validation error","More than 200 rows submitted — exceeds maxItems limit","Invalid date format (not YYYY-MM-DD) — schema pattern validation failure","source_sum or aggregate_sum out of allowed range (±1 trillion) — validation error","Missing required fields (row_id, dataset_group, date) — schema error","Invalid field enum value — rejected with schema validation error","Payment not included or insufficient — x402 payment required response"],"whenToPreferThis":"Choose this endpoint when you need both category frequency analysis and a weighted mean computation on a batch of aggregation or reconciliation records in a single call. It is ideal for data quality pipelines where you want to inspect group distributions and weighted averages of source and aggregate sums together, without needing external lookups or live data connections. Best suited for small-to-medium datasets up to 200 rows where both reports are needed at once.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T00:54:32.106Z","isFirstParty":false,"canonicalSlug":"aggregation-checks-category-frequencies-secondary-measure-weighted-mean-95dadc39"}