3 Replies Latest reply on Mar 10, 2017 6:24 AM by Tom W

    tableau version 10 : find occurence of value in a column and number them

    Anindam Das

      here is the detail description

       

      The user has below data in excel

       

      Name

      a

      b

      a

      c

      d

      d

      a

      b

      b

      a

       

      The user want to have a calculated field say Count which will have below value

       

      Name

      count

      a

      1

      b

      1

      a

      2

      c

      1

      d

      1

      d

      2

      a

      3

      b

      2

      b

      3

      a

      4

       

      Its counting the occurrence and numbering it  …. like first occurence of 'a' as 1 the second occurence of 'a' as 2 similarly

       

      Kindly suggest

       

      Pls note I am not looking for this : { FIXED [Name] : SUM([Number of Records])}