How to add a calculation to beast mode that involves uncollapsing columns into rows
I have a Data table with the Actual amounts for Accounts Receivables to which I have appended another table that has the budget amounts on a monthly basis. I created a sumo card to view the data in pivot format . I now need to add a calculation to the sumo card, but the calculation involves data that comes from the same column.
I assumed that I would have to uncollapse this column in MAgic ETL and then add a calculation as a separate column so that I can view it in a sumo card. But this didn't work
I have attached an excel sheet to explain the dataset I have and what I currenrly see in Sumo View, and what I actually want to see.
Can Someone guide me through this? I Know it should be simple but I am clearly missing some logic here.
I will also include a screenshot of what I tried in Magic ETL
Comments
-
I struggled with this one. This may be a case where Excel performs better than Domo at the moment. I could not find a way to get the calculated `Delta Budget` field to calculate currectly for the total row. Instead, you have to pick an agregate function (sum, min, max, avg, etc.) which does not work at all.
You can see in the above screenshot, it simply summed the delta budget field. It would be nice if the Total Row would allow the beast mode calculation to be performed on the other totals in the row. However, I do not believe that is possible in Domo right now.
You can build some other visuals, unless you are tied to the sumo card / pivot table look:
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
Hi Scott,
I tried the same method that you did and you're right I had to pick an aggregate which did not give me the right answers. I need this to be in the sumo view as it gives me the closest match to the way the data needs to be presented. But thankyou for helping. ?
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive