4 Replies Latest reply on Jun 15, 2012 7:21 AM by sinadashtipour

Filters to affect multiple datasources

sinadashtipour Jun 15, 2012 3:46 AM

Hello All,

I'm trying to apply a filter to two different data sources.

Please see the attached workbook. If you look at the Drill Down tab you can see that when you change the filter (Download Year) it only affect the No of Downloads column, but it doesnt affect the No of Uploads because that is coming from the Uploads data source.

Is there a way to make sure they are both affected. So for example when you change the Download Year to 2012, it should also change the Upload Year (from Uploads datasource) to 2012.

I hope I have explained this clearly.

Many thanks,in advance

1. Re: Filters to affect multiple datasources

Russell Christopher Jun 15, 2012 4:07 AM (in response to sinadashtipour)

Hi Sina -

The conversation I'm having here http://community.tableau.com/thread/118454 is very similar to what you're looking for: "I want a single filter to act against multuiple datasources". The info you need is towards the end of the thread in question

Have fun!
Like Show 0 Likes(0)

Actions
2. Re: Filters to affect multiple datasources

sinadashtipour Jun 15, 2012 6:18 AM (in response to Russell Christopher)

Hi Russell,

I did try to your approach with the use of Parameters. However, I am not able to drop the new fields to the Filters shelf. I can only drop new field which is coming from the primary data source, NOT from secondary data source.

I have also tried to use the Action Filter feature, But I can only set filters on columns from the primary data source to primary data source. Not primary --> secondary.

I hope this helps.

Thanks.
.
Like Show 0 Likes(0)

Actions
3. Re: Filters to affect multiple datasources

Russell Christopher Jun 15, 2012 6:39 AM (in response to sinadashtipour)
Sorry, it wasn't clear you were using Blending - I didn't look at your sample.

Try this:

In each data source, make a duplicate of the date field and rename it to "Year".
Add "Year" from "Downloads" data source to Level of Detail
Remove existing filter
Right-click Year in Level of Detail and Show Quickfilter

Sample attached

RL_Forum.twbx.zip 66.8 KB
Like Show 0 Likes(0)

Actions
4. Re: Filters to affect multiple datasources

sinadashtipour Jun 15, 2012 7:21 AM (in response to Russell Christopher)

Thanks a million. thats seems to work :-)
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Filters to affect multiple datasources

1. Re: Filters to affect multiple datasources

2. Re: Filters to affect multiple datasources

3. Re: Filters to affect multiple datasources

4. Re: Filters to affect multiple datasources

Actions

More Like This