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