3 Replies Latest reply on Nov 14, 2013 9:15 AM by Matt Lutton

    How to calculate distinct value for repeating user?

    Eva Lee

      Hello, I am trying to calculate the conversion rate for visits to walk-through/trial. Below is the type of data I am working with.

       

       

       

      I know I can get unique visitor by create a new calculation field with COUNTD([Contact E-mail]) which give me 15 in this case. But don't know how to get unique visits to walk-through/trial for each distinct visitor. From just counting my table I know the unique visits to walk-through/trial is 13.

       

      And this will give me a conversion rate of 13/15 = 87%. I know logically what I want to do but not sure how to achieve in Tableau.

       

      Can anyone help me?

       

      Thank you

       

      Eva