5 Replies Latest reply on Jun 12, 2018 8:24 AM by Cristian Saavedra

    Please help me understand tableau

    Sudha Rawlley

      I have an excel sheet with employee master data of my company.

      I have employee names, with codes and their reporting manager along with employee statau( active/inactive).

       

      I wish to use tableau to identify who are the employees who are mapped to a manager who is inactive.

       

      This i can easily do in excel using lookup. How can i replicate the same in tableau as i want to explore tableau.

       

      As in the example below, Reporting manager of A1201 who is an active employee has an inactive employee for reporting manager i.e B1204.

       

      I want to identify such cases and change reporting managers.

       

      Employee Code
      Namereporting manager codeEmployee status
      A1201JerryB1204Active
      B1204TomC1360Inactive