Section: Running metrics

Running count

sql
sql
SELECT event_time,
       user_id,
       COUNT(*) OVER (
         ORDER BY event_time
         ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
       ) AS running_events
FROM events;
Explanation

Helpful for event streams and operational dashboards.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Running metrics
Running total
Cumulative sum ordered by date.
OpenIn sheetsqlsame section
Cumulative maximum
Track the best-so-far value.
OpenIn sheetsqlsame section
3-row moving average
Average current row and previous two rows.
7-row moving sum
Rolling weekly sum on daily rows.
Centered moving average
Use prior and following rows together.
Running total per category
Reset the running total by partition.