{"uid":"cap_l_yy8a8dqwC41rS6WY9W8","slug":"duplicate-observations-analytics-trailing-mean-series-date-by-374d5034","name":"Duplicate Observations Analytics: Trailing Mean Series + Date by Category Pivot","description":"Duplicate observations — Trailing mean series + Date by category pivot: Trailing mean series + Date by category pivot for supplied duplicate observations records (duplicate_rows, total_rows). 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-04-152?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","duplicate_rows","total_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"duplicate_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rows":1,"dataset_group":"group-a","duplicate_rows":10},{"date":"2026-10-02","row_id":"row-2","total_rows":2,"dataset_group":"group-b","duplicate_rows":20},{"date":"2026-10-03","row_id":"row-3","total_rows":3,"dataset_group":"group-a","duplicate_rows":15},{"date":"2026-10-04","row_id":"row-4","total_rows":4,"dataset_group":"group-b","duplicate_rows":30}],"maxItems":200,"minItems":1},"field":{"enum":["duplicate_rows","total_rows"],"type":"string","default":"duplicate_rows"},"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_akhlZNk8_DHW4aj1Hts4R","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 duplicate-observation metrics (duplicate_rows, total_rows) across up to 200 supplied data rows.","exampleAgentPrompt":"I have duplicate observation records for two dataset groups over the past week — can you run a trailing mean series and a date-by-category pivot on the duplicate_rows field using a window of 3, for these rows: row-1 on 2026-10-01 group-a with 10 duplicates out of 100 total, row-2 on 2026-10-02 group-b with 20 duplicates out of 200 total, row-3 on 2026-10-03 group-a with 15 duplicates out of 150 total?","exampleUseCases":[{"title":"Data quality trend monitoring","prompt":"I've been tracking duplicate rows in our nightly ETL pipeline across two dataset groups for the last 30 days — can you compute a trailing mean series (window of 7) on the duplicate_rows field and also pivot the data by date and group so I can spot which groups are getting worse over time?"},{"title":"Weekly deduplication audit report","prompt":"Run a trailing mean and date-by-category pivot on total_rows for our four dataset groups using a window of 5 — here are the 20 rows from our weekly audit: group-a through group-d across dates 2026-09-01 to 2026-09-20, with total_rows ranging from 500 to 5000."},{"title":"Data governance dashboard analytics","prompt":"I need two reports on our duplicate observation data for the governance review: a rolling mean series with window 4 on duplicate_rows, and a pivot of duplicate counts by date and dataset category — I have 50 records across three groups spanning October 2026."}],"resultDescription":"Returns two independent analytical reports computed from the supplied rows: (1) a trailing mean series over the chosen field (duplicate_rows or total_rows) using the specified window size, and (2) a date-by-category pivot table showing the field values broken down by date and dataset_group. Both reports are computed locally on the provided data without any external lookups.","failureModes":["Fewer than 1 row supplied — minimum 1 row required","More than 200 rows supplied — exceeds maximum item limit","Window size larger than number of rows — trailing mean may produce insufficient data points","Invalid date format (not YYYY-MM-DD) — fails pattern validation","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — schema validation error","Numeric values outside allowed range (-1T to +1T) — rejected","Invalid field enum value — must be 'duplicate_rows' or 'total_rows'","Payment failure — 0.01 USDC required per call via x402 protocol"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of duplicate observation records and need both a trailing moving average time series AND a date-by-category pivot in a single cost-efficient call ($0.01 USDC for both reports). It is ideal for data quality monitoring, ETL auditing, and governance dashboards where offline computation on supplied data is sufficient and no live lookup or external data is needed.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:02:12.632Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-analytics-trailing-mean-series-date-by-374d5034"}