Amazon QuickSight includes a new advanced filter type: nested filters. Authors can use a nested filter to use one field in a dataset to filter another field in the dataset. You might know this by another name such as in SQL this would be known as a correlated sub-query and in shopping analysis this would be known as market basket analysis.
Nested filtering enables authors to show additional contextual data, rather than filtering it out if it doesn’t meet an initial condition. This can be useful in many different scenarios including market basket analysis where it is now possible to find out sales quantity by product for those customers who have purchased a specific product or who did not purchase a specific product. It is now also possible to find out the group of customers who did not purchase any one of the selected product list or only purchased a specific list of products.
Nested filters are now available in all supported Amazon QuickSight regions – US East (Ohio and N. Virginia), US West (Oregon), Asia Pacific (Mumbai, Seoul, Singapore, Sydney and Tokyo), Canada (Central), Europe (Frankfurt, Ireland and London), South America (São Paulo) and AWS GovCloud (US-West). See here for QuickSight regional endpoints.
For more on how to set up a nested filter, go to our documentation here and blog post here.
Source:: Amazon AWS