How can I prevent a running backlog total beastmode from hitting zero?

I'm working on building a labor model for my department to track where our projected backlog will be over the next several weeks. One problem I'm running into is when the incoming backlog is less that what we're projected to process, the backlog goes into the negative instead of hitting zero which then throws off all subsequent projections. Any idea on how to rewrite this so that the total will never drop beyond 0?
Below is a simplified version of the beastmode I currently have written
/*current total backlog*/
SUM(SUM(`backlog per unit`)) OVER()
+
/*Incoming/Projected backlog Beastmode*/
SUM(SUM(`incoming backlog`)) OVER (ORDER BY `week starting`)
-
SUM(SUM(`units processed`)) OVER (ORDER BY `week starting`)
Answers
-
@TylerMarshall How is your data grouped in the card? You many need to add a PARTITION BY and/or ROWS clause in your window functions
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive