What is your process for determining the rolling average of a specific metric over a certain length of time?

Question

Anonymous · Accepted Answer

SELECT 
    date,
    metric_value,
    ROUND(AVG(metric_value) OVER (
        ORDER BY date 
        ROWS BETWEEN 6 PRECEDING AND CURRENT ROW
    ), 2) AS rolling_avg_7d
FROM 
    tbl
ORDER BY 
    date;

Anonymous · Answer

select

avg(metric column) over (order by date column rows between n preceding and
current row) as [rolling average]

from table

What is your process for determining the rolling average of a specific metric over a certain length of time?

Practice this question with AI

Go Premium

Practice More Questions

Community Answers

Unlock Community Insights

Unlock Community Insights

Everything You Need to Ace DS Interviews