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.
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?
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.
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.