Natalie, does it need to be a single select or a multi-select filter?
Shawn: It would be a single select filter :]
1 of 1 people found this helpful
In that case you can use a parameter/calculate field combination. You create a parameter with a list of all the things you want to filter on. Then you'll set up a CASE/WHEN/THEN statement in. Here's one I had lying around:
CASE [Select y-axis:]
WHEN 'Clicks' THEN SUM([Clicks])
WHEN 'Impressions' THEN SUM([Impressions])
WHEN 'Interactive Impressions' THEN SUM([Interactive Impressions])
WHEN 'Rich Media Impressions' THEN SUM([Rich Media Impressions])
WHEN 'Click Rate' THEN [Calc Click Rate]
WHEN 'Media Cost' THEN SUM([Media Cost])
WHEN 'CPM' THEN [Calc CPM]
WHEN 'CPC' THEN [Calc CPC]
WHEN 'Click-Thru Conversions' THEN SUM([Click-through Conversions])
WHEN 'View-Thru Conversions' THEN SUM([View-through Conversions])
WHEN 'Total Conversions' THEN SUM([Total Conversions])
WHEN '% Clicks by Site' THEN [% Clicks by Site]
WHEN '% Impressions by Site' THEN [% Impressions by Site]
WHEN '% Spend by Site' THEN [% Spend by Site]
WHEN 'Video Completion Rate' THEN [Video Completion Rate]
WHEN 'Interaction Rate' THEN [Interaction Rate]
Then you'll put a copy of this on the filter shelf for all three of the different data connections. If the field names are are NOT exactly the same for all three sources, then modify the THEN part of the statement.
Fantastic, Shawn. I will give it a try! Thanks so much.
It's been a while since I originally asked this question. I didn't figure it out back then but found a way around the problem, but it has crept up on me again. I haven't used parameters before so Shawn Wallwork's answer above is difficult for me to implement. I'm hoping that Shawn or someone else can provide more guidance.
I've got two data sources. Both contain a Date dimension. I have created a bunch of visualizations, each of which only uses a single data source, and placed them all on a dashboard. Thus, the dashboard contains visualizations that use the two data sources. I'd like to place a filter on the dashboard to filter all the visualizations by Date. I'm not sure how to set-up my parameter or CASE/WHEN/THEN statement to make this work. Does the CASE/WHEN/THEN statement need to address every dimension included in the visualizations that are in the dashboard?
Natalie, welcome back! The short answer is: Yes. But there are many other ways to get a viz to work the way you want it to. So it really is best to post a packaged workbook with a bit of sample data so we can best direct you in, well, the right direction.
Fortunately I got a spot in a Parameters breakout session and was also able to get an appointment with a Tableau doctor at TC14 to get this problem sorted. I saw that you were up on stage with the rest of the Zen Masters! How did you enjoy the conference?
I ended up making a month parameter and then using the following calculation, which I used as a filter on all of the workbooks in my dashboard:
ELSEIF DATETRUNC('month', DATEPARSE("MMMM yyy", [Month])) = DATETRUNC('month', [Date])
Thanks again! Cheers!
Natalie, glad you got it worked out. As to the conference? What's not to like! They sure can put on a show (and party). That Zens on stage part was the hardest part of the conference for me (but at least I didn't trip!) How was your conference? What was your favorite session?
As to your calculation you can probable shorten it up a bit:
OR DATETRUNC('month', DATEPARSE("MMMM yyy", [Month])) = DATETRUNC('month', [Date])
Doesn't really matter, just wanted you to be aware of OR, AND, NOT.
I had a great time too, and learned a lot. I liked many of the hands-on sessions, but especially the one on analyzing survey data in Tableau. Thanks for the help on the calculation!