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
- 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