3 Replies Latest reply on Jun 11, 2018 9:52 AM by Michel Caissie

    Count Number of Duplicate in a column

    jessica GERVAIS

      Hi Tableau community,

       

      I am relatively new to Tableau and I am trying to do a simple calculation, that is equivalent to the COUNTIF function in Tableau. I have a column that contains numbers (they can appear several times or only once). I would like to create a new column (calculated field) that counts for each item the number of times it appears in the column. So in Excel that would be COUNTIF(Cell, Range). I have tried in TABLEAU: {Fixed[ID]: COUNTD([ID])}, but this does not bring the expected results. I have attached a screenshot of my tableau workbook.

       

      Would anyone be able to help?

       

      Many thanks

       

      Jessica