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:
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)
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 .
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.