I can't open your attachment as it's a .twb and not a .twbx (meaning that it doesn't contain your data).
However I think I know the reason anyway!
It sounds like your Keyword isn't unique (to each row) is your week 2 dataset. When you join data and the join field is repeated it will create a row for each occurrence. Hopefully the below image helps explains what's going on
Thank you for you help, I check my excel source, the "keyword" is unique in each row,please see my screenshot
I tried to put the two table into one table and then the data was correct in Tableau, However, in this way, I can't make a duel axis link chart to compare the two weekly ad report
Here is the duel-axis link chart I want to make:
I upload a correct tableau workbook file into my question and I also upload my excel data source, please take a look
You can still make the dual axis, what you need to do is add a flag that tells you that the row is from which week.
This you can do at the start when you are preparing your data.
Then you can create two calc fields for each week and use that for dual axis.
What is adding a flag? Do you mean add a column after "date" and added "last week" and "two weeks ago" as value into it?
Can you tell me what calc field I need to create? Can you give me an example?
Thank you so much