{"uid":"cap_R_zIfpykAO_E7A9IHMmby","slug":"time-entries-trailing-mean-series-6308dd45","name":"Time Entries Trailing Mean Series","description":"Time entries - Trailing mean series: Trailing mean series for Time entries. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded trailing mean series deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-time-entries-rolling?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","project","date","hours","billable_hours"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"project":{"type":"string","default":"","maxLength":80},"billable_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","hours":10,"row_id":"row-1","project":"group-a","billable_hours":1},{"date":"2026-10-02","hours":20,"row_id":"row-2","project":"group-b","billable_hours":2},{"date":"2026-10-03","hours":15,"row_id":"row-3","project":"group-a","billable_hours":3},{"date":"2026-10-04","hours":30,"row_id":"row-4","project":"group-b","billable_hours":4}],"maxItems":200,"minItems":1},"field":{"enum":["hours","billable_hours"],"type":"string","default":"hours"},"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_2ZJXNq_CsfXgEKT_3VwLG","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 (rolling) mean series over time entry records for hours or billable_hours fields, using a configurable window size.","exampleAgentPrompt":"Calculate a trailing mean series for these time entries using a window of 3, smoothing the hours field: row-1 on 2025-01-01 for project Alpha with 8 hours (6 billable), row-2 on 2025-01-02 for project Beta with 10 hours (8 billable), row-3 on 2025-01-03 for project Alpha with 6 hours (5 billable), row-4 on 2025-01-04 for project Beta with 12 hours (9 billable).","exampleUseCases":[{"title":"Smooth weekly hours for project reporting","prompt":"I have 30 days of time entries across two projects — can you compute a trailing mean series with a window of 7 on the hours field so I can see smoothed weekly trends? Here are the rows: row-1 through row-30 spanning 2025-03-01 to 2025-03-30 for projects Alpha and Beta with varying hours."},{"title":"Detect billing trend with rolling average","prompt":"Run a trailing mean series on billable_hours for my consulting time entries over the past month using a window size of 5. I have 20 entries from 2025-02-01 to 2025-02-28 across projects ClientA and ClientB."},{"title":"Validate data smoothness before payroll","prompt":"Before we finalize payroll, can you apply a trailing mean with window 4 to our team's hours entries for January 2025 — 15 rows across projects Ops and Dev — using the hours field, so we can spot any outlier spikes that need review?"}],"resultDescription":"A series of trailing mean values aligned to each input row, where each value represents the rolling average of the selected numeric field (hours or billable_hours) over the specified window of preceding records. Rows with insufficient preceding data (fewer than window size) are typically handled with available data or marked accordingly. Output covers up to 200 input rows.","failureModes":["Fewer than the minimum 1 row supplied — request rejected","Window size larger than number of provided rows — partial or edge-case results","Invalid date format (not YYYY-MM-DD) — validation error","Field value outside allowed numeric range — rejected","More than 200 rows submitted — exceeds maxItems limit","Missing required fields (row_id, project, date, hours, billable_hours) — schema validation failure"],"whenToPreferThis":"Choose this endpoint when you need a locally-computed, deterministic rolling/trailing mean series on time entry data (hours or billable_hours) without any external data enrichment or forecasting. Ideal for smoothing noisy time-tracking data, detecting trends in logged hours, or preparing data for reporting — especially when you have up to 200 structured records and need a simple, low-cost ($0.01) statistical operation with no side effects.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:39:23.549Z","isFirstParty":false,"canonicalSlug":"time-entries-trailing-mean-series-6308dd45"}