I'd want to provide the user a user-friendly description field, but have that pick convert into a performance filter on an indexed field.
Assume I have a Widget table with two fields and tens of millions of rows. WidgetKey is a number, and WidgetDescription is a string. I need to allow the user to choose from a list of WidgetDescriptions, however the SQL should filter on the WidgetKey value.
Is it possible to accomplish this using a Tableau fast filter?