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
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive