I've got a tough one, been racking my brains on this for a bit. In short I'm trying to create a "hierarchy" key based on everyone above an individual. For example if I'm four levels down from the CEO, my hierarchy key will be my id, my bosses id, his bosses id, and the CEO.
The CEO doesn't have a supervisor and will have a "level of 1", Created a google sheet with an example of what the data would look like and the output: https://docs.google.com/spreadsheets/d/1UyLF277Lb1gJ4Q0rd6mbrPVq87tMbx7hchITEoBSYp4/edit?usp=sharing
Any help would be appreciated!
The CEO doesn't have a supervisor and will have a "level of 1", Created a google sheet with an example of what the data would look like and the output: https://docs.google.com/spreadsheets/d/1UyLF277Lb1gJ4Q0rd6mbrPVq87tMbx7hchITEoBSYp4/edit?usp=sharing
Any help would be appreciated!