Using Total as figure in Beast calc
This might be obvious, but I couldn't find how to do this. Is it possible to use the total figure (row total) as an individual figure in beast mode calcs? I have tried to do the following calc:
Amount/SUM(Amount)
The above calc is only doing the calculation on a row by row basis and is not using the sum figure/total figure.
Best Answer

You're not able to do this at the card level and would need to calculate this at within your ETL/Data Transform process.
Calculations at the card level are viewed "rowbyrow" so if your calculation is comparing Amount in Row 1, a SUM(Amount) would only return the amount of Row 1 at Row 1 since it's not grouped and still broken out by each row.
An alternative would be to calculate the SUM(Amount) ahead of time and add it as a constant value column to your dataset. This would let you do Amount / (Precalculated SUM(Amount)) for each row.
Let me know if you have any other questions,
Valiant_Ronin
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Answers

You're not able to do this at the card level and would need to calculate this at within your ETL/Data Transform process.
Calculations at the card level are viewed "rowbyrow" so if your calculation is comparing Amount in Row 1, a SUM(Amount) would only return the amount of Row 1 at Row 1 since it's not grouped and still broken out by each row.
An alternative would be to calculate the SUM(Amount) ahead of time and add it as a constant value column to your dataset. This would let you do Amount / (Precalculated SUM(Amount)) for each row.
Let me know if you have any other questions,
Valiant_Ronin
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Categories
 All Categories
 1.7K Product Ideas
 1.7K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 292 Workbench
 4 Cloud Amplifier
 8 Federated
 2.8K Transform
 95 SQL DataFlows
 600 Datasets
 2.1K Magic ETL
 3.7K Visualize
 2.4K Charting
 685 Beast Mode
 43 App Studio
 38 Variables
 656 Automate
 170 Apps
 439 APIs & Domo Developer
 42 Workflows
 5 DomoAI
 32 Predict
 12 Jupyter Workspaces
 20 R & Python Tiles
 384 Distribute
 110 Domo Everywhere
 268 Scheduled Reports
 6 Software Integrations
 111 Manage
 108 Governance & Security
 8 Domo University
 25 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 98 Community Announcements
 Domo Community Gallery
 4.8K Archive