Reverse Running Total by Date
Can I get some help in understanding how to take the reverse of cumulative totals based on date? I've attached a sample of the data, which has US State and County cumulative data by date and I would like to calculate total from one date vs the previous date and keep the grouping of state and county.
Any help would be much appreciated.
Comments
-
... if you google both "cumulative sum domo" and "running total domo" there are solutions that immediately pop up.
is there something specific that stops those solutions from being applicable?
https://www.youtube.com/watch?v=ZPf41Fjn1H8 // how to calculate cumulative sum.
https://www.youtube.com/watch?v=cnc6gMKZ9R8 // how to use lag to get yesterday's value.
---
the above solutions work, but force you to keep each date on the axis (in order to use LAG). if you don't want to keep date on the axis, then you can use an offset calendar
https://www.youtube.com/watch?v=CDKNOmKClms
You can use the same Window function and can avoid LAG()
OR just use a case statement sum(case when date = today() - 1 day end. ) -- this is pseudocode.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 564 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive