{"uid":"cap_0S_Q9RnzAAMgByQwiXkDL","slug":"sampling-observations-trailing-mean-series-date-by-category-pivot-f23385b8","name":"Sampling Observations — Trailing Mean Series + Date by Category Pivot","description":"Sampling observations — Trailing mean series + Date by category pivot: Trailing mean series + Date by category pivot for supplied sampling observations records (sample_value, sample_weight). 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-15-152?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","sample_value","sample_weight"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"sample_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"sample_weight":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","sample_value":10,"dataset_group":"group-a","sample_weight":1},{"date":"2026-10-02","row_id":"row-2","sample_value":20,"dataset_group":"group-b","sample_weight":2},{"date":"2026-10-03","row_id":"row-3","sample_value":15,"dataset_group":"group-a","sample_weight":3},{"date":"2026-10-04","row_id":"row-4","sample_value":30,"dataset_group":"group-b","sample_weight":4}],"maxItems":200,"minItems":1},"field":{"enum":["sample_value","sample_weight"],"type":"string","default":"sample_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_-vm9KHslh414nuU8Ydgao","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 a trailing mean time series and a date-by-category pivot table for up to 200 sampling observation records (sample_value or sample_weight).","exampleAgentPrompt":"I have 120 sampling observation rows with dates, sample values, sample weights, and group labels — can you run a trailing mean series with a window of 5 and also pivot those records by date and category, using the sample_value field?","exampleUseCases":[{"title":"Rolling average for A/B test measurements","prompt":"I've got two groups of experiment observations (group-a and group-b) recorded daily over the past month. Can you compute a trailing mean series with a window of 7 days on the sample_value field and also give me a pivot of values by date and group?"},{"title":"Weighted sample trend analysis","prompt":"I have 80 rows of survey sampling records with dates, sample weights, and group labels. Please run a trailing mean series with window 10 on the sample_weight field and generate a date-by-category pivot so I can see how weights differ across groups over time."},{"title":"Quality control batch inspection summary","prompt":"Here are 150 QC inspection readings across three product categories from the last quarter — can you calculate a rolling mean with a 4-sample window on sample_value and pivot the results by date and category so I can spot which category is trending up or down?"}],"resultDescription":"Returns two analytical reports: (1) a trailing mean time series showing smoothed values of the selected field (sample_value or sample_weight) over time using the specified window size, and (2) a date-by-category pivot table cross-tabulating the selected field across dataset groups and dates — both computed locally from the supplied rows, with no external data fetching.","failureModes":["Fewer than 1 or more than 200 rows supplied — validation error","date field does not match YYYY-MM-DD format — pattern validation failure","sample_value or sample_weight outside allowed range [-1e12, 1e12] — schema rejection","window size less than 2 or greater than 200 — parameter validation error","field value not one of 'sample_value' or 'sample_weight' — enum validation error","Missing required fields (row_id, dataset_group, date) on any row — schema error","Payment of 0.01 USDC not completed — 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you need two specific analytical outputs from sampling observation data in a single call: a trailing (rolling) mean time series AND a date-by-category pivot, without needing prediction, external data lookup, or professional assessment. It is ideal when your data fits within 200 rows, you want local computation only, and cost efficiency matters (both reports for $0.01 USDC). Prefer alternatives if you need correlation analysis, outlier detection, deduplication, or string normalization — sibling endpoints on the same platform cover those.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:38:00.992Z","isFirstParty":false,"canonicalSlug":"sampling-observations-trailing-mean-series-date-by-category-pivot-f23385b8"}