Cumilative running total bar
I have a running total bar that I am trying to have give the running total for all time but when I try to show only this year it is only giving me the running total since 1/1/23 (as if 1/1/23 started at zero)
Is there I way that I can have it still give the all-time total while only displaying this year as the output?
I have date range set to All time
graph by set to Month
date filter set to all time, but when I change it to only show a part that is when it changes the "start date" to not pull all time
Answers
-
You'll need to pre-aggregate your data with a window function in Magic ETL in order to keep all-time around. Window functions in Beast Modes will only apply on the data that is available after filtering.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
@pauljames
this is the full chart I have (this output does not show all the column labels since there are so many)
I want to be able to view just the current month but have it continue to use all the data from the before this year in the total0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 194 Apps
- 483 APIs & Domo Developer
- 88 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 118 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive