I am trying to do something simple - take a % total of my records (count of my properties) by state (dimension). Following the documentation: percentOfTotal ( count({propertyid}), [state] ) When I chart this new attribute vs. state, every row = 100% [image] Is this user error or a bug?

Hello @Drew , welcome to the Quicksight Community! Have you tried the solution suggested here?: [image] Percentoftotal is not working Question & Answer I have a field name status and second column is count of each but I was not able achieve percentage of each in Quicksigh…

Problems with PercentOfTotal in Calc Fields

Q&A

duncan January 18, 2024, 5:58pm 2

Hello @Drew , welcome to the Quicksight Community!

Have you tried the solution suggested here?:

Topic		Replies	Views
Percentoftotal is not working Q&A quick-sight , calculations , Business-Intelligence-Engineer	1	321	September 27, 2023
A question related to percentoftotal Q&A quick-sight , calculations	2	1416	February 21, 2023
Calculate Percent of Total For Pivot Table Q&A quick-sight , calculations , how-to	3	3400	December 15, 2022
How to create percent Of Total Q&A quick-sight , calculations , Business-Intelligence-Engineer	7	25	November 14, 2024
Turning Values into Percentages for a Pivot Chart Visual Q&A analysis , quick-sight , how-to	11	243	August 28, 2023

Problems with PercentOfTotal in Calc Fields

Related topics