5 Replies Latest reply on Jun 20, 2016 11:48 AM by Joe Oppelt

    Filtering

    Morgan Strong

      Hi All -

       

      I'm not sure how to label this question, but what I am trying to do is filter a set of records by a unique ID and create a visualization from it. I have the below data set as an example:

      What I am trying to do is avoid counting each "Message ID" more than once. This is what I am currently getting:

      But what I want to capture is 4 records for "Completed" and 6 records for "Validated".  If a Message ID is populated more than once, they will always have the same "Status".  Is there any easy way to filter this data? I have attached a sample workbook for reference. I am also working off Tableau 9.1

       

      Thank you!

      Morgan