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
 All Categories
 1.2K Product Ideas
 1.2K Ideas Exchange
 1.3K Connect
 1K Connectors
 267 Workbench
 Cloud Amplifier
 3 Federated
 2.5K Transform
 78 SQL DataFlows
 524 Datasets
 1.9K Magic ETL
 2.9K Visualize
 2.2K Charting
 433 Beast Mode
 22 Variables
 508 Automate
 114 Apps
 386 APIs & Domo Developer
 8 Workflows
 26 Predict
 10 Jupyter Workspaces
 16 R & Python Tiles
 331 Distribute
 76 Domo Everywhere
 255 Scheduled Reports
 65 Manage
 65 Governance & Security
 1 Product Release Questions
 Community Forums
 40 Getting Started
 26 Community Member Introductions
 67 Community Announcements
 4.8K Archive