I have Dataset 1 and Dataset 2. I created a table 1 by Dataset 1 with filter 1: metric 1 > parameter 1 (e.g. 0.05). metric 1 is a string calculated field controlled by parameter 2 (string). I also created table 2 by Dataset 2. Both table 1 and table 2 have metric 2. What I want to do is: Filter t…

[image] Yuchen: metric 2 as filter 2 in table 2 and set up “show relevant value only” then select parameter 1. But since parameter 1 is a number, it asks me to select field to match the text box value. I am not able to finish this step since parameter 1 is a user input which is not one of the o…

Filter QS view by numeric filtered data from another dataset

Q&A

Nico July 17, 2024, 11:52am 4

Hi @Yuchen ,

could you upload some dummy/sample data to Quick Sight Arena and rebuild what you are doing right now? Then we can understand it better and try out a solution, that is available for you in the end.

Here you can find information about Arena:

Best regards,
Nico

1 Like

Topic		Replies	Views
How to filter across different datasets Q&A filters , quick-sight , Business-Intelligence-Engineer	4	138	December 13, 2023
Data filtering for associated tables Q&A analysis , filters , parameters , quick-sight , Business-Intelligence-Engineer	5	84	June 17, 2024
Filter one table visual based on other table visual's result Q&A analysis , filters , parameters , quick-sight , filters-controls-and-parameters	3	2492	June 13, 2023
Create filter for a visual from one dataset that only shows the relevant values based off of a filter from another dataset Q&A filters , quick-sight , filters-controls-and-parameters	1	380	February 15, 2023
Two Dataset working together without doing any joins Q&A quick-sight , calculations , Business-Intelligence-Engineer	4	524	February 21, 2024

Filter QS view by numeric filtered data from another dataset

Related topics