So from Tableau 10.0 (and beyond) we can just do this "out the box"
In prior versions...
You can use a parameter (as per the link from Nachiket)...although the drawbacks are; one single values and parameter values don't update dynamically (i.e. if a data update leads to extra values).
You can use Actions (which can go across data sources)
Finally, and it is only viable is specific situations (where the Viz is made up of blending 2 data sources), you can use blending (where filtering one data source means that the data coming from the second is, essentially, filtered). Hopefully, you can just use T10 (or the other 2 methods) but if not can you post an example of what you are trying to filter and I'll see if we can set it up as a blend.
Hi Simon & Nachiket,
I have two data data sources say 1 .DS for Sales related information(DS1)
2.DS for Returns related Information.(DS2)
I am creating a dashboard where i need to show the complete profile of a particular customer.So I need a filter for customer name.I have this customer name field in both DS.I made dashboard and when i started using the customer name filter,it only filter out sheets in dashboard which uses the DS1.sheets from DS2 is not changed or getting affected by my filter.I am not able to make it as Global filter as shown by Andy Kreibel article.I dont know why the global filter option not coming up for me as its shown by Andy Kriebel.
And Simon if i was using Tableau 10 it would not been a problem , as I see the option for All using related data sources in that pic.Thats really cooolll.....
But I use tableau 9.3 version
1 of 1 people found this helpful
Simon if i was using Tableau 10 it would not been a problem , as I see the option for All using related data sources in that pic
Yes good old Tableau...they do listen!!
So you have a few options...
1. Change the data-model and so join the 2 datasources into a single datasource (very much like superstore example data where "Returns" are joined to the main sales data)
2. Use actions to filter. If you make your filter from another sheet. You can make them look pretty good and can justify the extra space (they won't be drop-downs) by adding some extra information (say a bar chart with total sales by customer)
3. Attached is an example, where the view is built from DS1 (with the filter only on DS1), but brings in data from DS2. This means that DS1 get's filtered, and so Tableau can only "blend" onto the remaining data.
4. upgrade to Tableau 10!!
Hope that helps
I think My computer settings something might be causing the problem.I am using my company system,dont know they have put some restrictions on attachment or something like that. I encountered the same problem before.I got it in my mail Thanks.Let me go through it.
Got it now.I changed to full view.I can see it now.Thanks.