3 Replies Latest reply on Sep 17, 2018 4:57 AM by Johny Rinto

    Filter list with name, Query with ID

    Biyin Cai



      Currently, I have an action filter (with the list of ID-Name pairs) that allows me to jump from one dashboard to another with the filtering on both ID and Name; and I apply this filter to all worksheets on the second dashboard and I can change my filtering. I want the filter showing the list of names on the dimension (Let's say Employee name), and make sure the query to DB is sent using the ID (i.e. Employee ID).


      The reason is performance. Tableau runs the query using both id and name for filtering with my current filter. I have huge DB, and filtering by name is not efficient.


      This may be a simpple task, but I havent figured out how to do it, I appreciate your ideas.