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 table 2 to only list the data of which the metric 2 is filtered in table 1.
For example: With filter 1 applied in table 1, table 1 lists 2 rows with metric 2=‘ABC’ and ‘DEF’. I want table 2 to show records for metric 2=‘ABC’ and ‘DEF’.
What I have tried:
Apply “Action” to table 1, but it only gives me single record in table 2 by clicking single metric 2 value in table 1. It can’t give me both records.
Add 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 option.
It seems as a join could solve your problem. When you join/merge the data from Dataset 1 and Dataset 2 by your metric 2 you can use your filter as before.
Hi Nico, thanks for the reply! There will be too much data when joining 2 dataset and it will take very long time for data refresh that’s why I am not doing this way.
could you upload some dummy/sample data to QuickSight 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.
Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!
