How to filter multiple datasets using a single filter originating from a separate dataset in Analysis?

Q&A
, ,
5

Hey @Koushik_Muthanna,

I have a similar Problem and do not get it to work. The join operation betweens these datasets is way too big and creates way too many rows and thus performance issues for the Snowflake DB.
Thus I need the filtering by controls to work in accordance to your example to work.

1. Dataset: Product_KPI_Dataset : Customer, Brand, ASIN , …
This Dataset holds the KPI Data for all products.

2. Dataset: Product_Groups_Dataset : Product Group, ASIN, Customer, Brand
Every product groups holds a number of ASINs for the customer and the Brand.

Mission: The 1. Product_KPI_Dataset should be filtered by the Product Group selected by Product_Groups_Dataset. Only products (ASINs) of that product group shall be displayed in the Product_KPI table.

Steps taken: In accordance to the provided instructions

  1. Create filters using the 5th (here 1st Product_Groups_Dataset) dataset (Product Group, PG_ASIN, Customer, Brand) for a visual. You can later hide it using free-form layout and conditional rules.
    Filters: Customer, Brand, Product Group, PG_ASIN

  2. Create a cascading control Show relevant values only [Adding filter controls to analysis sheets - Amazon Quick Sight ]

Cascading rules:

  • Product Group filtered by Customer selected
  • PG_ASIN filtered by Product Group selected
  • Customer filtered by Product Group, PG_ASIN selected
  • Brand filtered by Product_Group, PG_ASIN, Customer selected
  1. Create a visual from 1st dataset and 2nd dataset [Use a table visual, easier for comparison]
  • done: Product KPI Table
  1. Add the common key (Account ) to filter for both visuals . Filter properties > Applied to > All applicable visuals.
  • done: Customer, Brand, PG_ASIN
  1. Select a country and segment . It should show only relevant values for account. The same account should also be filtered in 1st and 2nd dataset if available.

Problems:

  1. The Product Groups does not filter the Product KPI Table.
  2. Selecting single ASINs from PG_ASINS does the job: it filters the table, but “Select All” always gives the full unfiltered product list from Product KPI Table, not filtered by Product Group.

=> Issue 1 is way more Important then issue 2. We need these filters to work. Please help us and let me know, where the mistake is
=> here is the example Dashboard: https://eu-central-1.quicksight.aws.amazon.com/sn/accounts/166698189686/dashboards/a09ccd8c-f25b-4141-9339-eca0a338e765?directory_alias=movesell-analytics-user

2 Likes