{"uid":"cap_YSwNPr245ogFb7Im4VAjD","slug":"aggregation-checks-numeric-interval-filter-secondary-measure-weighted-319e745f","name":"Aggregation Checks — Numeric Interval Filter + Secondary-Measure Weighted Mean","description":"Aggregation checks — Numeric interval filter + Secondary-measure weighted mean: Numeric interval filter + 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-132?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"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_I9fanuyPFY0lBNsFtUvXj","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":"Filters aggregation check records by a numeric interval on a chosen field and computes a secondary-measure weighted mean, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"For these aggregation check rows I'm uploading (up to 200 records with source_sum and aggregate_sum fields), filter on source_sum between 0 and 100, and give me both the interval-filtered report and the secondary-measure weighted mean report.","exampleUseCases":[{"title":"ETL pipeline sum validation","prompt":"I have 150 aggregation check records from our ETL pipeline with source_sum and aggregate_sum columns. Can you filter the rows where source_sum falls between 500 and 50000 and compute the weighted mean of aggregate_sum across those rows? I need both the interval filter report and the weighted mean report."},{"title":"Financial reconciliation outlier review","prompt":"Here are my daily reconciliation rows grouped by dataset_group with source_sum and aggregate_sum values. Filter out anything outside the range 1000 to 999999 on source_sum and tell me the weighted mean of aggregate_sum — I want to spot if any group is pulling the average out of line."},{"title":"Data quality audit for reporting period","prompt":"I need to audit these 80 aggregation check records for October 2026. Please filter on aggregate_sum between 0 and 10 and compute the weighted mean using aggregate_sum as the secondary measure, so I can see which groups are within acceptable bounds."}],"resultDescription":"Returns two analytical reports: (1) a numeric interval filter report listing rows where the chosen field (source_sum or aggregate_sum) falls within the specified minimum–maximum range, and (2) a secondary-measure weighted mean report computing the weighted average of the complementary measure across all supplied rows or the filtered subset. Results are based entirely on the supplied data with no external lookups.","failureModes":["Missing required fields (row_id, dataset_group, date, source_sum, aggregate_sum) cause validation errors","Submitting more than 200 rows exceeds the row limit and results in a rejection","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Minimum value greater than maximum value may yield an empty filtered set with no weighted mean","Null values in both source_sum and aggregate_sum may produce undefined weighted mean","Payment not included or insufficient USDC causes x402 payment-required error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 aggregation check records with source_sum and aggregate_sum fields and need both a numeric interval filter report and a weighted mean in a single paid call. It is ideal for lightweight ETL validation, data quality audits, or financial reconciliation checks where no external data lookups are needed and results must be derived purely from supplied data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:39:17.963Z","isFirstParty":false,"canonicalSlug":"aggregation-checks-numeric-interval-filter-secondary-measure-weighted-319e745f"}