I'm not entirely sure you can do this easily with a dimension filter. I tried different approaches. Each had their limitations.
"Long story short, I want to pick the (Home country) dimension filter selected values and pass on the same on to sheet 2 (Moved to country column) as both the columns got same values".
The above comment in your question is a description of an action filter. So, the best approach to pass a dimension from one worksheet to the other will be to use an action filter not quick filters. Your requirement seems tricky that even action filters will not give you a perfect solution. My approach uses action filters and a helper worksheet which will serve as a dimension selector.
Step 1: Create Sheet 1 and Sheet 2 as required.
Step 2: Normally, Tableau doesn't allow a worksheet to filter itself using an action filter. We are going to create a helper sheet to achieve this and especially to allow for multiple home country selection. I called this "Home Country Filter".
Step 3: Create 2 dashboard action filters as shown below.
Go to Dashboard -> Actions -> Add Action -> Filter
Hope this helps.
Thanks for your efforts in explaining this with screenshots.
I have tried this action filter procedure in the first place. But, for some reason my report user want to select the country name using quick filter option instead of action filter..
This is a road block for me. I'm still trying to achieve this.
Really I appreciate your efforts. Thanks.
The common (both Source and Destination) filter
could be made from the UNIONed datasource,
then applied to both Source and Destination views
(as a Cross-Datasource Filter).
Please find the attached.
1 of 1 people found this helpful
Good approach Yuriy.
I was also working on a UNION approach when I saw your post. My approach doesn't involve data blending.
@ Raghava, the solution depends on the type of data source. If your tables are in a SQL database; then I'll use a Custom SQL to create a UNION. The idea is to rename Home Country to Moved To Country in the second table. Then you can switch them around in Tableau using a calculated field.
The custom SQL for a SQL database will look like this.
SELECT Table1.Home Country AS [Home Country],
Table1.moved to country AS [moved to country],
"Source 1" AS [Source],
SELECT Table1.Home Country AS [moved to country],
Table1.moved to country AS [Home Country],
"Source 2" AS [Source],
Using an Excel data source, I have simply duplicated the table in Excel, swapped the column headers and added a Source column. Then Unioned the tables in Tableau.
See attached workbook.
Hope this helps.
Thanks for the work around. I believe, this would be a good one for me. Thanks for your time and efforts.
I couldn't find the work book in the attachments.
I have a data source in .tde format with 3.5 million records(can't use custom SQL) I think in my case making a Union of the data set will kill the performance
I will try this approach and let you know. Thanks you so much.
My datasource is .tde file, I mean i will receive data source in the .tde . format.
Unfortunately, I don't have much control over the data source to create a union.the workaround is very good for smaller datasets. but, in my case its killing the performance. Thanks Ossai.