3 Replies Latest reply on Oct 19, 2016 11:36 AM by Jarod Floyd

    Displaying values based on mutiple values in another column.

    Jarod Floyd

      I've tried to search this but I'm not certain I am wording this correctly.  

       

      I have data that is a history in CSV format. (See below)

       

      I want to see all of column c for every distinct item in column a if column c has value q1 and q2.

       

      In the CSV:

         

         

      abcd
      48110/29/20152:56:27q1
      48110/29/20152:56:28q2
      48110/29/20152:56:40z9
      48310/29/20154:06:42q2
      48310/29/20154:06:43m8
      48310/29/20154:06:44z9
      49811/3/201516:26:00q1
      49811/3/201516:26:01m8
      49811/3/201521:07:26z9
      49910/29/20153:18:54q1
      49910/29/20153:18:55m8
      49910/29/20153:19:18z9

       

       

      What I want to be filtered to in Tableau:

       

         

      abcd
      48110/29/20152:56:27q1
      10/29/20152:56:28q2
      10/29/20152:56:40z9

       

       

       

      Any ideas?

       

       

      Thanks,

       

      Jarod