Running Total Group Bar - keep running total but show only current month, possible?
Hey all I have an end user that is requesting for a running total graph to only show current month but still retain the running total.
When I filter for current month, it does exactly that, filters only to current month so the running total from the previous 2 months is lost, as I expected. I'm wondering if its possible to show only current month but keep the running total.
I'm anticipating that I will probably need to calculate the running total in the dataflow and use that instead for this chart but I thought I would ask.
Any and all ideas appreciated!
You are correct that you would need to create a separate calc in your dataflow if the user wants to filter to the current month but still the running total. You could do this pretty easily with the rank and window tile in Magic ETL.
You might also look at some different card types. Maybe using the multi-value card or a couple single value cards and have them next to each other.**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
@Crisocir don't do it in ETL.
If you calculate running totals in ETL you can't filter
show all your months on the axis. and then use a CASE statement to only accumulate data in the current month
(case when month = current_month then amount) ... this is very puedo code.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"1
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 477 Transform
- 1.8K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 218 Visualize
- 260 Beast Mode
- 2.1K Charting
- 12 Variables
- 88 Cards, Dashboards, Stories
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive