Tree map group hierarchy

I’m building a tree map in Amazon Quicksight.

I have checked that my data is structured correctly. Sector (field) is the highest group level, Industry (field) is the mid group level and Symbol (field) is the lowest group level. All are strings.

I would like to show the Tree map visual to include each Sector. Within each Sector thee should be the Industries associated with that Sector. Within each Industry there should be the Symbols associated with that Industry and Sector.

However, Nested hierarchical groups aren’t appearing in my Amazon Quicksight, it only shows one Field level at a time, either Sector OR Industry OR Symbol. I can create a drill down to go to each group/field, but I want them to show all at once in a single visual.

Tableau has this functionality. Does QuickSight not support this? If so, how do you create the view?

Thank you,
Eric

Hii @Eric_Davidson hope this message finds you well!!

To tackle the issue of creating a tree map in qs that displays all hierarchical levels simultaneously, it’s crucial to understand that qs doesn’t natively support this functionality like Tableau does ( or there’s something new that I don’t know as well). It allows for drill-down, where you can click to explore deeper levels, but not to display all levels at once. You can set up a drill-down hierarchy by adding your fields (Sector, Industry, Symbol) to the tree map visual, arranging them in the desired hierarchical order, and enabling drill-down in the visual settings. If displaying all levels at once is essential, consider using a different type of visual that better supports hierarchical data, such as a pivot table or a custom visual. Additionally, providing feedback to AWS can be beneficial, as they frequently update their services based on user feedback. By following these steps, you can work within qs current capabilities to achieve a similar effect, even if it’s not exactly the same as tableau’s functionality.

hope this help you :smiley:

thank you for the answer lary_andr!