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 want to see the total of each race. so if john is “white:asian” and joseph is “white:asian”, then the pie chart should show asian 2 and white 2 but it currently is showing “white:asian” 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