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?
From your screenshot it seems like you're hitting this limitation:
https://github.com/metabase/metabase/issues/2862 - upvote by clicking 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.