Display Hierarchies in Quicksight

Question & Answer
1

Hi everyone,
we always have one requirement for which we don’t have any solution: To display a cost center Hierarchy (to navigate through the data) Is this possible in Quicksight? (Parent-Child Relationships for one characteristic?)

hier
hier457×632 120 KB

Thx and regards
Hannes

2

Where exactly do you need to show the hierarchy?

QuickSight shows hierarchies differently in different places. When you use Pivot Table visual, you will be able to see hierarchies with ability to expand and collapse dimension values.
In other visuals, QuickSight shows a single layer of the hierarchy with ability to Drill Up or Drill Down.

To define a hierarchy you need to add columns into the same field well (e.g. add Country, then add State, then add City)

3

PivotTable for example.

One characteristic cost center. I would like to show a (virtual) hierarchy.

Cost center A
   - Cost center F
Cost center B
   - Cost center C
        --Cost center D
        --Cost center E

Is this possible?

Thx
Hannes

4

Today, in pivot table, different levels of hierarchy are displayed in different columns. Here is an example

800×205 19.8 KB

Does this approach work for your needs or do you need something else (e.g. show all levels of hierarchy in a single column so that table takes less horizontal space. This is not available yet but is currently planned).

5

That approach works because you have your hierarchy in discrete columns. What the OP was originally asking for sounds more like a straight forward tree, where each node in the tree refers to it’s parent. I would upvote that because many of us dealing with say Salesforce Account data are dealing with heirarchies of accounts we want to visualise.

Also on your Pivot there, it’s really messy in QuickSight at the moment as you can’t fold in and out like you can with Hierarchies in Tableau:

At the moment you always see the columns you’ve said you aren’t interested in when you folded up at higher levels.

2 Likes
6

Great! Do you have a timeline for that?

Regards
Hannes

7

We can’t release our timelines, but you can keep an eye on what we release here: Announcements - Amazon QuickSight

8

Are you able to confirm if we will have the option to add hierarchies that are not related to location?

9

It is something we have planned for in the roadmap, but we can’t make a commitment as things can change

1 Like
10

great, thanks for the update

11

Hi Hannes,
We are adding a similar feature to our pivot tables towards the end of this year where you would be able to visualize parent-child hierarchy.

12

This are great news!Thx and regards Hannes

13

@Bchadha Hi. Has there been any progress made on this feature request yet?

14

@Bchadha @Tatyana_Yakushev - I just received a similar hierarchy requirement. In addition, I need a Filter of a “tree” type allowing the user to easily navigate the hierarchy whereby nodes can be opened and closed - like a file explorer.

Following on this, the visual would need to filtered by the selected filter node showing all data relative to that node in hierarchy down. Pivot tables and cascading filters will not cut it.

Any status update or design pattern you can recommend until such feature?

Thanks

15

search for [ Improved space optimizations ] What’s new with data visualization in Amazon QuickSight – 2023 in review | AWS Business Intelligence Blog