ขนาดวิดีโอ: 1280 X 720853 X 480640 X 360
แสดงแผงควบคุมโปรแกรมเล่น
เล่นอัตโนมัติ
เล่นใหม่
sum(amount) over(partition by customer_id order by visited_on desc range between current row and interval 6 day following) as cum_sum and later on average wil also work fine I guess. just an alternative solution
sum(amount) over(partition by customer_id order by visited_on desc range between current row and interval 6 day following) as cum_sum and later on average wil also work fine I guess. just an alternative solution