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/en-us/articles/4408174643607-Beast-Mode-FIXED-Functions
**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/en-us/articles/4408174643607-Beast-Mode-FIXED-Functions
**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