I have a field name status and second column is count of each but I was not able achieve percentage of each in Quicksight…below is the expected output I’m looking for.
|IL|100|15.82%|
|NYC|200|31.65%|
|VA|320|50.63%|
|MA|12|1.90%|
Hi @hellosai321,
When using percentOfTotal, you need to pass a metric which is second column in your example for SUM and then it partitions by the dimension.
So for your case, percentOfTotal is not recommended approach.
|IL|100|15.82%|
|NYC|200|31.65%|
|VA|320|50.63%|
|MA|12|1.90%|
Instead, you would need to create a calculated field for the total using sum and then for the next calculation you would divide the actual number by the sum total and multiple by 100.