Graphic total amount of deliveries / country / month

Hi all!
I want to make a Graphic that shows the total amount of deliveries / country in time.
However, I can make a graphic that show the deliveries per month, but I want to visualize growth.
So I want to see the trend of a graphic going up every month calculating all the deliveries since the beginning of the operation.

I have no idea how to continue this question and how to summarize this accordingly. Any ideas?

13

Hi @MarieNeren
You need to use cumulative sum, but you're going to hit this issue if you create multiple "group by":
https://github.com/metabase/metabase/issues/2862 - upvote by clicking :+1: on the first post
So you can do it for each country in it's own question and then combine multiple questions on a dashboard:
https://www.metabase.com/docs/latest/users-guide/09-multi-series-charting.html#combining-two-saved-questions
Not great workaround, but otherwise you would have to do the query in SQL yourself.

Allright, amazing, thanks for your help! I'm looking into it :slight_smile:

I had the feeling a cumulative sum was needed here, but then I was struggling of what I'd need to make the sum off. I'd say amount of deliveries, but that just showed me a flat graphic.