cumulative orders

[rndmnm]

Hi,

I need some help finding cumulative orders value in MySQL.

[Cyril_MTL_Analy]

Hello @rndmnm and welcome!

In pure SQL, you would need to go through a subquery and a window function. Something like this:

with temp_table as (

select

date_trunc('week', created_at) as created_week
, count(distinct order_id) as orders_count

from orders

group by 1)

select 

created_week
, orders_count
, sum(orders_count) over (order by created_week asc rows between unbounded preceding and current row) as cumul_orders_count

from temp_table

group by 1,2

But you can easily do that in LookML/Table calculation already without going through a SQL query.