Cumulative sum for group by of time range

Hi, I made a stack bar chart 100% for cumulative sum of payment thethod need breakout to the payment method as here:

My expectation is to bring the previous time to the current time then running up total. For example as in the picture, 12-sep-2021 should include cod and card from 29-Aug-2021 then add some number of card payment to. But because the time of 12-sep-2021 only payment by card so it isn't as my expectation.
Any chance to do it?

Hi @iris2908
From your screenshot it seems like you're hitting this limitation: - upvote by clicking :+1: on the first post

Hi, I would like to ask if I can replace it by a new model count group by payment method running total. Not sure how to do it

@iris2908 I don't understand what you are trying to do, but you cannot use cumulative with multiple breakouts.
You would have to write your own SQL if you need that.

I made it now

By write SQL to show all running total however I don't know why the chart only shows the first date/week.