{"uid":"cap_relprNC5g3XDqsSo-hicc","slug":"data-freshness-analytics-trailing-mean-series-date-by-category-pivot-c889ca60","name":"Data Freshness Analytics: Trailing Mean Series + Date-by-Category Pivot","description":"Data freshness — Trailing mean series + Date by category pivot: Trailing mean series + Date by category pivot for supplied data freshness records (age_minutes, record_count). 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-06-152?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","age_minutes","record_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"age_minutes":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"record_count":{"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","age_minutes":10,"record_count":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","age_minutes":20,"record_count":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","age_minutes":15,"record_count":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","age_minutes":30,"record_count":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["age_minutes","record_count"],"type":"string","default":"age_minutes"},"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_Avb1DLQs_K32tMS2dpFA1","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 moving-mean time series and a date-by-category pivot table for supplied data freshness records (age_minutes, record_count) — two independent analytical reports in one call.","exampleAgentPrompt":"Run a trailing mean series and date-by-category pivot on my data freshness records — the field is age_minutes with a window of 3 — using these rows: group-a on 2026-10-01 had age 10 min and 1 record, group-b on 2026-10-02 had age 20 min and 2 records, group-a on 2026-10-03 had age 15 min and 3 records.","exampleUseCases":[{"title":"Pipeline freshness trend monitoring","prompt":"I have daily freshness logs for two data pipelines — 'etl-core' and 'etl-secondary' — across the past week with age_minutes values. Can you compute a trailing mean series with a window of 4 on age_minutes so I can see if either pipeline is getting staler over time?"},{"title":"Cross-group freshness pivot for reporting","prompt":"Pivot my data freshness records by date and dataset_group for my monthly report — I have about 60 rows across three groups (raw-ingest, transformed, curated) with dates in October 2026, and I want to see how record_count is distributed across groups by day."},{"title":"Anomaly investigation via rolling average","prompt":"Something looks off in my data freshness metrics for group-b — can you run a trailing mean with a window of 5 on age_minutes for these 30 rows and also give me the date-by-category breakdown so I can spot where the staleness spiked?"}],"resultDescription":"Returns two independent analytical reports: (1) a trailing moving-mean time series over the chosen field (age_minutes or record_count) using the specified window size, and (2) a date-by-category pivot table cross-tabulating values by date and dataset_group — both computed locally from the supplied rows with no external data access.","failureModes":["Fewer rows than the window size yields incomplete or no trailing mean values","Missing required fields (row_id, dataset_group, date, age_minutes, record_count) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","More than 200 rows submitted exceeds the row limit and is rejected","Null numeric values in the selected field may produce NaN or skipped entries in the mean series","Invalid field enum value (not age_minutes or record_count) causes a schema error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 data freshness records with age_minutes and/or record_count values and need both a rolling/trailing mean time series AND a date-by-category pivot in a single low-cost call ($0.01 USDC). Ideal for data engineers or analysts monitoring pipeline freshness across multiple dataset groups over time. Not appropriate if you need live data lookup, forecasting, external enrichment, or more than 200 rows processed.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T07:21:46.377Z","isFirstParty":false,"canonicalSlug":"data-freshness-analytics-trailing-mean-series-date-by-category-pivot-c889ca60"}