10 Replies Latest reply on Jul 26, 2016 8:08 AM by Rohit Kumar

    Countif function in Tableau

    Aida Novo



      I'm a new Tableau user and I'm wondering whether someone can help me with an excel countif formula in Tableau.  I have 3 columns one with the employee number and another with the Manager ID number.  I have a third column that identifies whether an employee is a people manager. What I would like to do is identify those employees that are people managers how many employees that they have reporting up to them. So the number of time their employee number shows up in the Manager ID column.  Is someone able to help me with that formula.


      The excel formula I was using is =countif(B:B, A2)   where column B is the Manager ID and column A is the employee number


      Thanks and much appreciated