Is there a way to drill down based on parent-child relationship in AWS QuickSight? For example revenue of restaurants where the restaurants are in group hierarchy and we want to show the sum of revenue on specific level of hierarchy. The group levels are dynamic and based on parent-child structure.
Here is how we render the groups in web app:
Group data is in table with columns group_id, group_name, group_parent_id.
2 Answers
You could do this when you create the visual by adding a drill-down layer in the field well. See the link here -
2An alternative approach is using actions and parameters. By passing the field that establishes the join between the parent and the child, using a parameter, you could achieve that drill down. It is a more elegant method than the previous URL only approach. It is explained quite well in this workshop : AWS Quicksight - Adding Interactivity
2
