Filter one table visual based on other table visual's result

Hello, this seems a rather simple concept but not sure how to do it.

I have a table visual that is using a dataset ‘A’, here’s an example of the visual with its data:

image

This table visual is being filtered by date to be on May 1.

What I want is to obtain that list of ids (7627 and 9824) and display them on other table visual which is using a different dataset ‘B’.

I know I can do it with ‘Actions’ feature and do field mapping, but this way I have to select all the ID’s on the first table no?, how can it be done automatically? (i.e once the first table is filtered, the second one also updates)

Thank you in advance.

Hi @Serge,

I am assuming you have the date column in both datasets
1/then you could set the filter on date ( Adding filters - Amazon QuickSight ) and the Applied to will be : * All applicable visuals – The filter applies to any visuals that have valid column mappings.

2/Using actions with field mapping. If you just use the date column and set an action on that, it will still show all ID’s in your other dataset.
If you use both id and date from dataset 1 , set an action to filter so that it affects the other dataset . Then it would filter on the combination of cell you clicked.
Note: You cannot multi select ID’s from a visual .

Kind regards,
Koushik

1 Like

Hi @Koushik_Muthanna ,

Both solutions will not work because the date fields in both datasets correspond to different types of data. Let me give you an example: Let’s say on dataset ‘A’ the date field corresponds to date at which that item ID was Sold while on dataset ‘B’ the date field corresponds to the date at which the item ID was Created. This means that, continuing with my original example, if If i were to follow your solutions, the second table visual using dataset ‘B’ would contain information about items that were Created in day 1 of May, instead of showing information about the item IDs 7627 and 9824 which is what I want.

Hope i made myself clear.

Best,
Sérgio

Hi @Serge,

I understand it as following

Dataset A [Filter By Date] and you get ID’s 7627 , 9824 .
Use the result set of 7627 and 9824 in another DatasetB

Based on your example since the date has a different meaning in both datasets, you would have take the method of using actions. There is no possibility that the output of a filter from Dataset A is automatically used for filtering in Dataset B .

Again using actions, you will not be able to select all the ID’s. So once the data is filtered by date and you have the relevant values in Dataset A. You can check if the workaround in the following post How can I select multiple lines from a table? (and how could I then DESELECT those items to exclude them form the analysis?) will help you with multi selecting which will filter the data in Dataset B.

Kind regards,
Koushik

1 Like