8 Replies Latest reply on Oct 10, 2018 11:52 AM by Michael Gillespie

    LOD based on parameter value

    Randolph Ralph

      I have a Tableau workbook that calculates the number of unique customers based on different sales categories. I am attempting to compare individual sales associates to all sales associates. I created a parameter to filter to a specific sales associate, but can not get the LOD expression to calculate correctly for the specific sales associate I am selecting.

       

      Here is the result I am getting in the Sales Associate Customers column when I change the Sales Associate parameter = James Rich.

      Incorrect Calculation.jpg

       

      Here is the result I would like.

      Correct Calculation.jpg

       

      Can Parameters not be used in Fixed LOD expressions? Is there a better approach to comparing all sales associates to a specific sales associate?