Absolute beginner here so please bear with me. I have a county level data for total population for different age categories. I also have a column for respective state for each county. I have a map of united states with population for each state. I want a piechart below the map where clicking on a state will display population breakdown for different age category. Solution I found was to create a pivot table, download the data and upload it as another data set to then create the piechart. Are there other options available? Please let me know if I need to provide additional details. Thanks.
Hi @sadhikari1
You can create the pie chart using the same dataset.
Quicksight visuals have a filter action which you can use to filter other visuals. So you can map field values from your map visual to the pie chart visual which would act as filters.
The Quicksight documentation has details how to setup filter actions.
Regards,
Giri
Hi @sadhikari1,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @sadhikari1,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.
Thank you!