Query editor
1select month, new_loans, 2sum(new_loans) over (order by month) as cumulative_loan_count3from (4select 5date_trunc('month', evt_block_time) as month,6count(distinct unique_id) as new_loans7from query_30157488group by 1)9order by month desc
select month, new_loans,
sum(new_loans) over (order by month) as cumulative_loan_count
from (
select
date_trunc('month', evt_block_time) as month,
count(distinct unique_id) as new_loans
from query_3015748
group by 1)
order by month desc