Help

Org Chart - Counting the Number of FTEs Under Leadership

1545 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeff_Kan
4 - Data Explorer
4 - Data Explorer

Hi everyone - I’ve been able to create a large org chart for my organization and it looks and works great - however, I was wondering if there’s any functionality that would allow me to understand how many total FTEs report to certain leaders. I’ve got 15000 entries, so its a pretty big organization - so trying to figure out if 500 people ultimately report to this one VP vs another has been a headache!

Appreciate any help folks can lend - thanks!

Jeff

1 Reply 1

Hi @Jeff_Kan - not sure how your data is structured and this is hugely simplified, but maybe there is something that can work for you here:

Screenshot 2019-05-28 at 18.33.16.png

My table has a self-linking field ({Manager}) and you can do repeated look-ups on this field:

Manager’s manager:

Screenshot 2019-05-28 at 18.35.31.png

Manager’s manager’s manager:

Screenshot 2019-05-28 at 18.35.39.png

At the lowest level of my table I’ve got all 4 levels of management:

Screenshot 2019-05-28 at 18.36.51.png

Staff -> Manager -> VP -> CEO

I can now filter where either the Manager is “X” or the Manager’s Manager is “X” (as I’m looking for totals at VP level)

Screenshot 2019-05-28 at 18.39.03.png

In the view summary totals, I can see that there are 35 records where “X” is the manager or the manager’s manager:

Screenshot 2019-05-28 at 18.40.26.png

Appreciate that this might be more difficult with 15000 employees and, presumably, more than 4 levels!

JB