3 Replies Latest reply on Jan 27, 2016 12:35 AM by panjala Srinath

How to create a set that include "Dimension A"- "Dimension B"

Derek Chen Jan 25, 2016 7:34 PM

Hi. I'm a beginner of Tableau, I want to create a set which only contains the different values in dimension A and dimension B

here is my case: I'm a online marketing, so I export my CPC advertising keyword reports from Google, the data sources include "keyword report week 1" and "keyword report week 2"

and in both reports there is a dimension called "keywords"

I want to create a sheet in tableau that can show me the new keywords performance. The "new keywords " are the keywords we added during week 2, so these keywords only included in the week 2 report and not included in week 1 report.

My idea is create a set called "new keywords" and make it only include the new keywords, but I don't know how to make the set calculation,

Anyone can help me?

Thanks

1. Re: How to create a set that include "Dimension A"- "Dimension B"

panjala Srinath Jan 25, 2016 11:27 PM (in response to Derek Chen)

Hi

After creating 2 sets , It is required to create a combined set.

Please follow the below links to get the requirement.

Step 1: Creating a Set

Step 2: Combining Sets

Regards
Srinath
Like Show 0 Likes(0)

Actions
2. Re: How to create a set that include "Dimension A"- "Dimension B"

Derek Chen Jan 26, 2016 8:11 PM (in response to panjala Srinath)

Thank you for you reply, but it's still not working this way, somehow the system doesn't allow me to create this combine set:

1. I right click the week2 keyword and create a set "week 2 keyword set" and select all the value

2. I did the same and create a set from week 1 keywords, called "week1 keyword set". However, I can't select these two sets in combine set. It only allows me to select a set I created before

I also tried to select these sets and use right click to do combine set, but it doesn't show me the combine set option.

My tableau version is 9.0. Data source is from excel

Please help
Like Show 0 Likes(0)

Actions
3. Re: How to create a set that include "Dimension A"- "Dimension B"

panjala Srinath Jan 27, 2016 12:35 AM (in response to Derek Chen)

Hi

Can you please upload the tableau packaged workbook , I will try that for you

Regards
Srinath. panjala
Like Show 0 Likes(0)

Actions