-
1. Re: Creating a global filter for worksheets using different data sources
Pallavi Deshmukh Apr 4, 2017 10:02 PM (in response to Sneha K)1 of 1 people found this helpfulHi Sneha,
With Tableau 10 onwards you can use one common column among all the extracts as a common filter for all the sheets. For example, if all your extracts have 'Drug Name' as a common column then it can be used directly(see screenshot attached 'All using related data source').
If you are using version below Tableau 10 then it has to be done using parameters and having filter actions based on the common value.
Please attach a workbook which simulates your scenario. I will be able to explain better in that case.
Regards,
Pallavi Deshmukh
-
2. Re: Creating a global filter for worksheets using different data sources
sunil.sachdeva Apr 4, 2017 10:03 PM (in response to Sneha K)1 of 1 people found this helpfulHI,
please check this Filter Data Across Multiple Data Sources
hope that helps.
Another way to do is:
1. create relationships in data sources.
2. create all desired filters on one sheet (with any one of data source), lets call it dummy sheet.
3. use dummy sheet in all dashboards and apply filters on desired sheets.
4. Hide dummy sheet by change layout options and keeping width and height as 1 pxl.
Hope that helps.
-
3. Re: Creating a global filter for worksheets using different data sources
Sneha K Apr 4, 2017 11:10 PM (in response to sunil.sachdeva)Thank you Sunil and Pallavi, it works.