Dataclip for New Users Monthly

gistfile1.sql

WITH monthrollup as (
select count(*) as signups, 
       date_trunc('month', created_at) as date
from users
WHERE created_at >= current_date - interval '24 months'
group by 2
)

SELECT date,
       signups
FROM monthrollup
WINDOW w as (order by date) 
ORDER BY date ASC;