6 Replies Latest reply on Sep 4, 2015 5:23 AM by Jay Chang

    employee hierarchy

    Bibhu Chaudhury

      I have the classic employee, manager, department data and would like to represent it in a hierarchy. I would like to represent the data visually in a drill down in Tableau - cumulative counts (direct & indirect reports) of employees by manager. Pls see attached for the data and what I would like to do. E.g. manager id 1 has 2 direct + 6 indirect = 8 employees under her while manager id 10 has 4 direct + 0 indirect = 4 employees under her.

       

      Lets assume the number of levels is dynamic and can change with time. Is there a way this can be done in Tableau?