Forum Discussion
How to filter 2 visuals when you dont have a solid relationship between 2 tables?
Hi undefined,
Assuming that you have tables of Test1, Test2 and Test3 DBs in separate queiries, i.e. The Tables of Test1 will be in a separate Query, Test2 in another Query and So on. you can achieve what you are looking for.
Use the below steps:
1. Create a new column in all the 3 queries of Test1, Test2 and Test3. This Column should have the Database Name in it.
2. All the Columns of the 3 Queries should have the same name
3. Append the 3 Queries together to for a single Query
4. Use the DBName column to a visual to fiter using it and the tables and size in a different visual.
Follow the screenshots below
Similar to Test1 also add DBName column to Test2 and Test3
After Appending the tables, the Query looks like
The Resultant Output
Append Option
Hope this is what you need!!!
If this fixes your need, Appreciate with a Kudo and accept as solution!!!!
Thank you it worked but do you know how can i get values to not populate the graph until clicked on?
Solution SageIn my sample this is exactly the behavior on the right hand visual. I used a blocking if function based on HASONEVALUE of TEST you would use the same measure or do sometihng simlar for whatever your plotting on your graph.
Thank you so much