Filtering a table based on clicking a grouped value in another table

I have 2 tables:

Table 1: Details

Details related to assets

Table 2: Change Summary

The number of assets for which an attribute was changed after a certain date X. For ex: For Cluster = North and Site = Site_A, category_change = 34, there are 34 assets in that Cluster+Site the “Category” of which was changed after the date X.

This is how I set it up in Quicksight:

The column “category change” itself is a binary column. 1 means changed, 0 means not changed. Therefore, SUM is how I am getting the total number of changes in each Cluster+Site.

Question: I want that when I click on any cell in Table 2, only those Asset Details show up in Table 1. For ex, clicking on 34 under Category_change, should display only those 34 assets in details table. However, the issue I am facing is that when I click on 34, I get ALL the assets for the corresponding Cluster+Site combo, not the 34 changed ones.

Can anyone please provide some direction/help schedule office hours?

Hi @uc06,
So I’m guessing that since you mentioned that you get a response on Table 1 when clicking Table 2, you’ve setup a filter action already, correct?

Could you share a screenshot of the filter action you have in place?

Sure. Here it is:

Hi @uc06 and apologies for missing your last response.
When building actions to filter visuals, QuickSight does not allow you to filter on an integer/decimal field which could make this difficult to achieve.

To work around this, you could try converting your ‘category_change’ field to a string, something that returns ‘True’ instead of a number. Then you can filter by cluster, site and this new field to limit the returned data on the second visual.

Hi @uc06

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

Hi @uc06

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!