#Analytics

3 snippets

• SQL

  Percent of total with a window function

  Show each row's share of the grand total or of its group without a self-join.

• SQL

  Moving average with a window frame

  Compute a 7-day rolling average with AVG over a ROWS BETWEEN frame.

• SQL

  Fill in missing dates with generate_series

  Produce a row for every day in a range and left join your data so days with no activity show zero.