Best Mode: Cumulative Sum
I am trying to create in Best Mode a Cumulative Sum of column `Amount` to be represented in a table format.
I want to take the `Amount` 50 and count it for all months from `Start Date` to `End Date`. In the example below, I would like to count 50 for July, August, September, October and November.
Do you know if that is possible in Best Mode? I have tried a few formulas, but I can't get the results I am looking for.
|ITEM||Amount||Start Date||End Date|
|A||50||2020-07-16 05:00:00||2020-11-12 05:59:59|
|B||10||2020-01-01 06:00:00||2020-04-18 04:59:59|
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部