If I create a calculated field to pull the value from a parameter (rather than use the Measure Names shelf), I can't consistently format it properly.
Read this link: http://community.tableau.com/thread/118621
A couple of notes:
- I'm not sure that LOOKUP() trick of Joe's still works in the latest version of T (I think he mentioned that it doesn't)
- You can't do this if you need to use an extract
- So you can't use this on Public
Those are mostly the tricks I was trying, but it's still less than ideal. Great to have all those examples in one place, however... I would not have thought of the RAWSQL thing. I did vote up some of the related ideas linked to in that thread as well, so... many thanks!
I think the only "real" solution is going to be a change by Tableau, however. *le sigh*