SQL Growth Rate

What & Why

Growth rate compares the current growth.daily_active_users.dau value with the previous day's value: (current_dau - previous_dau) / previous_dau * 100.

LAG(dau) OVER (ORDER BY date_day) supplies the previous day's DAU without collapsing daily rows. NULLIF(previous_dau, 0) protects the denominator.

See How It Works

SELECT
  date_day,
  dau,
  LAG(dau) OVER (ORDER BY date_day) AS previous_dau,
  ROUND(100.0 * (dau - LAG(dau) OVER (ORDER BY date_day)) / NULLIF(LAG(dau) OVER (ORDER BY date_day), 0), 2) AS growth_rate
FROM growth.daily_active_users
ORDER BY date_day;