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 "row-by-row" 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 "row-by-row" 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
- 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
- 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