I am trying to make grouped running sum to plot inventory level per vendor.
I have a simple dataset :
Date Vendor Qty
1/1 V1 +200
1/1 V2 +50
10/1 V1 -50
I can run the query, but I have not figured how to get the running sums per vendor. Can Metabase do that?
If yes how should I write my question in metabase?
I am coming back on what I said, it looked liked it worked, but now that additional data has been added to the table, it is not working as I need.
I need a running sum of inventory over time per vendor. The running sum groups vendor and date appropriately, but the running sum does not reset.
I need the running sum to be reset to 0 when the vendor group value changes. Like I can get when using sum(qty) over (partition by vendor ordered by date).