Thank you very much for taking the time to think about and respond to my query. Prior to my original post, I had reviewed some of these links you were kind enough to provide . It seems I've hit the parameters limitation with Tableau, which I find amazing.
Below is the feature I'm looking for. The ability to search on values entered so the user can figure out which. This is from their quick filter. Its the "Search as you type" feature not available when using the Parameter as a filter that is lacking. As a regular filter, this works great.
So....still searching for a viable workaround.
Hello Christopher - You are right. Tableau has limitation on using parameter. But Tableau purposefully made that for improving performance. When User clicks a filter then an expensive database query fires to find unique values and then user can select one of the value(s). But in case of parameter, Tableau doesn't fire any database operation to generate the filter list. Now when you have multiple data sources then you only can use Parameter to filter among all these data sources.
In Tableau 10 (Beta) they have came with some new solution for filtering multiple datasources using filter.
But all said and done, values in Parameter can't be loaded automatically from fields. This is a manual process ("Add from field")
PS: You might have to manually load these field values on a periodic interval
I see what you mean about the dropdown for parameters not including the search field. Could you perhaps create a copy of your parameter, but make the copy a search box? Therefore you would have a dropdown as well as a search box (though they'd be separate parameters).
Note: I just looked and it appears that while the parameter search box does perform auto-complete, it does not perform like a true search box. In other words, if I type "manag" it will auto-complete to "management" but will not show "document management".
Shanka - thank you so much for taking the time to think about and respond to my dilemma.
I did think about this solution you provided, but yours is a bit nicer. However it still is archaic, but would probably a worst case solution. But I really appreciate what you provided and very well may end up using this!!!
I just hate providing a customer with so much automation only to tell them, with something so basic as this, ...ok...you can search for what you want, then once you find it, rather than just clicking on the one you want, you will need to type the relevant number in this other field to get your desired results.
Your thought is exactly what I originally did. I then took it off because I felt it would aggravate the customer more. Its like saying...ok you can look this up, then once you find what you're looking for, rather than selecting [clicking] on the one you found, manually take that number and type it in this other field to get your results.
Thanks again for the help.