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