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

Question & Answer

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 Question & Answer quicksight , calculations , Business-Intelligence-Engineer	1	311	September 27, 2023
How to create percent Of Total Question & Answer calculations , Business-Intelligence-Engineer	7	23	November 14, 2024
A question related to percentoftotal Question & Answer calculations	2	1407	February 21, 2023
Calculate Percent of Total For Pivot Table Question & Answer calculations , how-to	3	3301	December 15, 2022
Turning Values into Percentages for a Pivot Chart Visual Question & Answer analysis , how-to	11	239	August 28, 2023

Problems with PercentOfTotal in Calc Fields

Related topics