2 Replies Latest reply on Feb 14, 2017 4:36 PM by Madhusudhan Khambham

    Passing Id in the where clause for filters but show the value in workbook ?

    dipti.patel.2

      Is there a way to pass the ID in the where clause when the filters change. As, we have to use the "Only Relevant Values" and this is passing the String values even thought we have them indexed them in DB, index on id number would be faster?

       

      Any way to show the value but pass the id behind the scenes?

       

      I have a filter for example Category, Item. Have then set only relevant values.

      So on the dashbaord in quick filters i want to show the Category name and Item Name but when a user interacts with them and the query generated by tableau I want to pass the Category Id and Item Id as it would result in faster response due to indexes in the Id column ?