Helllo everyone, I hope you are doing well. I need help creating a Parent/Child hierarchy and I am unsure what is the best way to do it. I have tried to use: Substring / Locate
This is my table…
This is what I want.
Any thoughts?
@emilyzhu , @Max , @Ramon_Lopez have you ever tried to create something like that?
Thank you
What is parameter you are using to identify Parents and Childs . Once you add that in your dataset you can use calculated field and display on Table
Sorry @vaquarkhan , the parent Column is my Parent… and then if you realize the child depends on the column Code (that can be also the parent) it depends on what you are analyzing. could you clarify your suggestion? tks
Hello @woliveiras , dynamically adding columns (and multiplexing rows) based on a flattened structure present in a source column (path) is not possible to do directly on the data preparation/visualization phase in QuickSight.
Your need requires (artificially) adding more data to the source dataset which would need to be done at earlier in the data pipeline assuming a simple pipeline that includes the following:
In this case the this would need to be done in the transformation phase where tools such as Glue Data Brew or Glue Studio where this de-multiplexation can be done.
This is recommended not only as a best practice but also to improve the efficiency of the dashboard, as otherwise all the transformation complexity will be pushed to the visualization layer.
Hope it helps, please mark this solution as solved if that’s the case also to help other members of the community., otherwise let us know.
Happy dashboarding!
Hi @woliveiras, we don’t support explicit hierarchy in QS today, as you are adding fields into the field well, the order of the fields follows implicit hierarchy. However to you case, your hiararchy is not linear, which will make the case even more complicated. For now, QS is not able to solve it, as @EnriqueS mentioned, you probably have to do a specific design in your upstream data transformation layer for the hierarchy.
Hi @EnriqueS and @emilyzhu Thank you for your answer. I do not have Data Brew or Glue Studio, and I understand that it is possible when you can make a pre-processing. I found a simple solution to create it using the path column and split function in our Dataset (Calculated field for each level) . However, I cannot replace our numbers with the respective name based on my columns (cod and name). My “solution” is available in the following image.
I created 4 levels:
Level 1 = parseInt(split({Portfolio Id Path},“/”,1))
Level 2 = parseInt(split({Portfolio Id Path},“/”,2))
Level 3 = parseInt(split({Portfolio Id Path},“/”,3))
Level 4 = parseInt(split({Portfolio Id Path},“/”,4))
What do I need now? Replace my cod in each column I’ve created to use the respective name in our name column.
Any thoughts?
