Three-Day Moving Average
Medium
Rolling Metrics
For each day return the average sales over that day and the two preceding days (fewer at the start), rounded to 2 decimals. Order by day.
Table schema
Daily(day DATE PRIMARY KEY, sales INT)Sample data
day | sales
2026-01-01 | 10
2026-01-02 | 30
2026-01-03 | 20
2026-01-04 | 50
2026-01-05 | 40
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.