{"uid":"cap_cd5zu1sKyjr0rG2KgqvQy","slug":"numeric-precision-comparisons-daily-sum-series-trailing-mean-series-b49bdf64","name":"Numeric Precision Comparisons — Daily Sum Series + Trailing Mean Series","description":"Numeric precision comparisons — Daily sum series + Trailing mean series: Daily sum series + Trailing mean series for supplied numeric precision comparisons records (source_value, transformed_value). 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-20-136?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_value","transformed_value"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"transformed_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_value":10,"dataset_group":"group-a","transformed_value":1},{"date":"2026-10-02","row_id":"row-2","source_value":20,"dataset_group":"group-b","transformed_value":2},{"date":"2026-10-03","row_id":"row-3","source_value":15,"dataset_group":"group-a","transformed_value":3},{"date":"2026-10-04","row_id":"row-4","source_value":30,"dataset_group":"group-b","transformed_value":4}],"maxItems":200,"minItems":1},"field":{"enum":["source_value","transformed_value"],"type":"string","default":"source_value"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_rpPutWLFF0eVGxFFRQfC4","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 daily sum series and trailing mean series for numeric precision comparison records (source_value vs transformed_value) across up to 200 rows.","exampleAgentPrompt":"I have 4 rows of numeric precision comparison data — dates from 2026-10-01 to 2026-10-04, source values [10, 20, 15, 30] and transformed values [1, 2, 3, 4] in groups group-a and group-b — can you run the daily sum series and trailing mean series reports on source_value with a window of 2?","exampleUseCases":[{"title":"ETL pipeline transformation validation","prompt":"I ran an ETL job and have 50 rows with original source values and their transformed counterparts, each with a date and group label. Can you compute the daily sum series and the trailing mean series (window of 7) on the transformed_value field so I can spot where the transformation diverges over time?"},{"title":"Financial data precision drift analysis","prompt":"I have 120 rows of financial records with daily dates, source amounts, and rounded/transformed amounts across two groups. Please generate the daily sum and trailing mean (window of 5) for source_value so I can see cumulative drift in our rounding logic."},{"title":"A/B test numeric output comparison","prompt":"We have 80 rows comparing model A outputs as source_value and model B outputs as transformed_value, each tagged by date and dataset group. Run both the daily sum series and trailing mean series reports with a window of 3 on transformed_value so I can evaluate model B's daily behavior."}],"resultDescription":"Returns two independent analytical reports for the supplied rows: (1) a daily sum series aggregating the chosen field by date, and (2) a trailing (rolling) mean series for the chosen field over the specified window size. Both reports are computed locally on the submitted data with no external lookups. Output covers up to 200 rows.","failureModes":["Fewer than 1 row or more than 200 rows submitted returns a validation error","Invalid date format (not YYYY-MM-DD) causes a schema rejection","source_value or transformed_value outside the ±1,000,000,000,000 range causes a validation error","window value less than 2 or greater than 200 is rejected","field value not in ['source_value','transformed_value'] enum causes rejection","Missing required row fields (row_id, dataset_group, date) returns a schema error"],"whenToPreferThis":"Choose this endpoint when you need both a daily sum aggregation and a rolling/trailing mean computed together on a small-to-medium dataset (≤200 rows) of numeric precision comparison pairs (source vs transformed) without requiring any external data lookup or live service. It is ideal for validating ETL transformations, spotting numeric drift over time, or auditing rounding/precision changes in a data pipeline at very 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-15T06:40:32.109Z","isFirstParty":false,"canonicalSlug":"numeric-precision-comparisons-daily-sum-series-trailing-mean-series-b49bdf64"}