I have a user table with a ‘race’ column where there can be multiple races. for example, in the database, john may be both white and asian. It would show as “white:asian” in the race column. In AWS Quicksight, if I add a pie chart with the group being ‘race’ and the value being a count of ‘race’ I …

Display Pie chart with field that has multiple values

japeter89 January 4, 2024, 5:08pm 2

I have found this and will turn to aws glue to transform and create multiple rows - Split values from a field and create rows for each value

Topic		Replies	Views
Multiple FIELDS in VALEU section of Pie Chart Q&A charts , quick-sight , how-to	6	1177	September 15, 2022
How to add in a pie chart multiple calculated fields? Q&A quick-sight , calculations , how-to	4	981	January 17, 2023
How to create multiple plots based on values of a column Q&A analysis , quick-sight , how-to	2	735	March 7, 2022
How Grouping from Multiple Column on Pie Chart Q&A quick-sight , how-to	4	1610	September 1, 2023
Adding 3+ measures in a donut or pie chart Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	3	381	March 18, 2024