1 of 1 people found this helpful
By coincidence I just ran into this problem myself a couple of weeks ago. I had a Name field of the structure "Last, First" and tried to filter it via URL parameters and it wouldn't work. As far as I can tell (after extensive testing) the reason why is that Tableau accepts multiple values in the URL parameter and they are separated by a comma, so a URL parameter of the form ?Name=Smith, John filters for Name=Smith OR Name=John.
There are two workarounds:
1) Names generally aren't good to use for filters because multiple people can share the same name (especially when the culture is more homogenous, for example I live in a community with many French-Canadians so there are a lot of Cotes and Dubois's) and names often change, instead find something like an employee ID, partner ID, etc. and use that. However, sometimes common ID fields aren't available in all sources, so...
2) Get rid of the comma in the field used to generate the URL parameter and create a calculated field in the target that doesn't have the comma. This what I ended up using in my viz, I had ?FilterName=[Last Name]%20[First Name] as the URL parameter and a FilterName field in the target source that was REPLACE([Name], "," "") to get rid of the unwanted comma.
Creative and simple. I will do that. Thank you!