You're going to need to create calculated field with a CASE statement, or set up a secondary data source that has the Physician ID and Name, and use a Data Blend for that.
So... now not only do I manually have to update the list in my parameter, but I also have to manually update the list in my calculated field? Sigh.
Thanks Jonathan. Not what I wanted to hear, but it is what it is. I guess until Tableau decides to make their parameters better, I am stuck with it.
1 of 1 people found this helpful
If you can, look into the data blend option and/or creating the dimension table and using that in your query, you can get most everything you want and then updates are a matter of just changing or adding rows and not opening up the Tableau workbook.