How to link two datasets in AWS QuickSight for interactive tables?

[Kokka]

Hi,

I’m working with two datasets in AWS QuickSight and have created two table visualizations in an analysis, one for each dataset. I want to make the tables interactive so that when I click on a row in the first table, the content of the second table updates based on the clicked row.

Both datasets have a linking field—table1_id in the first dataset and table2_id in the second dataset. My goal is that when I select a row in the first table, the second table should only show rows where the table2_id matches the table1_id from the selected row in the first table.

Is there a way to set up such interactions between tables using two different datasets in AWS QuickSight? If so, could you guide me on how to achieve this?

Thanks in advance!

[Sanjeeb2022]

Hi @Kokka - Please see the below blog details.

Show a table visual only on click of a row in another table

Hi, I am indeed using the Free Form Layout. How can I use the conditional rule mechanism here? Any help would be much appreciated. As I said in the previous post, a combination of three fields in Table 1 determine the data to be shown in Table 2. I have done parameter based Hiding/Rendering of visual based on rules in other areas. But in those scenarios there was a static value parameter which can be checked against. Is there any way to set a parameter value when a row is clicked? If possible…

Hope this will help you in passing a parameter from visual 1 to visual 2 and filter the data.

Regards,
Sanjeeb

[Brett]

Hi @Kokka,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

[Brett]

Hi @Kokka,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!