I have a field that should show the % of that field by distinct count.
Is there a workaround for percentOfTotal
I have created one example in below. showing sales by industry and total sales in column 2. In column 3, I am calculating the percentage of sales for each industry. is it what you are looking for?
if yes, you may calculated field by using Level Aware Calculation
Total Sales by Industry: sum(Sales)/sumOver(sum(Sales), [])
Level Aware Calculation: Using level-aware calculations in Amazon QuickSight - Amazon QuickSight
2 Likes
This will show the percentage of the sales,
I want to have a percentage of the field that has a distinct count and its percentage.
Did you try using function distinct count over?
You can follow the same calculation logic, instead of using sum, can use distinct count