Running Total Line Chart using Beastmode Calculation
I am trying to use a line chart to display the running total of a beast mode calculation but I have not been able to find the correct solution. The beast mode calculation is a simple ratio, SUM(Column A)/SUM(Column . The issue I am having is that the beast mode calculates separately for each period depending on the date grain used for the chart and then aggregates the calculated ratios for each period for the running total which is not what I need. I need the ratio to be calculated each month based on the YTD data rather than each month independently. Is this possible?
Comments
-
Hello @tmullins,
A beastmode sees data as a row by row comparison. When you aggregate the column by using SUM() it tries to aggregate the data down to one row. Then the card is trying to group by the date you are trying to show on your card. This combination is confusing the card.
I will send you an email in a moment so we can connect on this and ensure we are able to find the best solution to resolve this.**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 778 Automate
- 190 Apps
- 482 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 412 Distribute
- 120 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive