7 Replies Latest reply on Aug 9, 2013 2:35 PM by Kyle Wong

    Is there a way to calculate the times a value in Column A shows up in Column B?

    Kyle Wong

      I'm hoping someone can help me out.

      I'm having trouble trying to create a calculated field (if possible) that counts the number of time Column B shows up in Column C.

       

      The attached is a sample of my excel data set where I have used the countif function in Column D to get the value I want, but I'd like a calculated field in Tableau to do this.

       

      Example:

      ColourID = "016746" shows up twice in Column = "Bin ID"

       

      End result is to have the counts be adjusted if I choose to filter out a Group (for example, exclude Orange). the example above would yield a count of 0.