WITH events_per_month AS ( SELECT DATE_TRUNC('month', event_time) AS month, COUNT(*) AS events_count FROM tools_shop.events WHERE event_name = 'view_item' GROUP BY DATE_TRUNC('month', event_time)) SELECT *, COUNT(events_count) OVER (ORDER BY DATE_TRUNC('month', event_time)) FROM events_per_month