Help With Creating % Of Total Column
Hello!
I have a similar following dataset:
Group  Claim Amount:
A  $75.00
A  $20.00
B  $100.00
D  $200.00
C  $100.00
C  $30.00
A  $400.00
Total: 7 Claims
I am trying to figure out how I can create a beast mode that will give me a percentage of total claims by count.
So, trying to add a column that would output the following:
A: .43%
B: 14%
C: 29%
D: 14%
Attempting the following:
COUNT(`Group`) / sum(count(`Group`)) but it doesn't seem to work.
Hoping to get this done by just a beast mode since I do not have access to backend data/access to window functions, etc
Best Answer

@SLam The beast mode as you have it won't work because both the numerator and denominator will only be counting loans in each group. You will need to use the FIXED function in your denominator to get the total of everything:
https://domohelp.domo.com/hc/enus/articles/4408174643607BeastModeFIXEDFunctions
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
1
Answers

@SLam The beast mode as you have it won't work because both the numerator and denominator will only be counting loans in each group. You will need to use the FIXED function in your denominator to get the total of everything:
https://domohelp.domo.com/hc/enus/articles/4408174643607BeastModeFIXEDFunctions
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
1
Categories
 10.5K All Categories
 7 Connect
 917 Connectors
 250 Workbench
 464 Transform
 1.7K Magic ETL
 69 SQL DataFlows
 477 Datasets
 190 Visualize
 252 Beast Mode
 2.1K Charting
 11 Variables
 17 Automate
 354 APIs & Domo Developer
 89 Apps
 3 Workflows
 20 Predict
 5 Jupyter Workspaces
 15 R & Python Tiles
 246 Distribute
 62 Domo Everywhere
 243 Scheduled Reports
 21 Manage
 42 Governance & Security
 173 Product Ideas
 1.2K Ideas Exchange
 12 Community Forums
 27 Getting Started
 14 Community Member Introductions
 55 Community News
 4.5K Archive