2 Replies Latest reply on Dec 12, 2016 6:21 PM by Joseph Skye

    Group duplicates by the number of times they appear

    Joseph Skye

      Hi there! Just recently got to start on tableau, and have reading up a lot.

      Quick question, is there a way to group values by the number of times they appear (i.e. once / twice / thrice) ?

      Right now I have a set of data with 100,000 ID values, with many duplicates.

       

      I created a new calculated field - count(ID); put that in rows and ID into columns, but the result was the number of times each ID appears instead.

      Will I need to create a bin using count(ID) instead?