Forum Discussion

cnschulz's avatar
cnschulz
Helper IV
7 years ago
Solved

Managerial Hierarchy

Gday, 

 

I have a data set with two colums: EmployeeName and ManagerName. This is a recursive structure and *almost* fits the Heirarchy Chart visualisation constraints. The problems I have are:

 

- The *absolute* top record (the CEO) does not exist so there will be no records that have a NULL in the ManagerName field

- We want to be able to slice this data at any level to look at department/divison/team structures. Again, the top level manager will not have a NULL in the manager field. The manager of this department is managed by someone but they are not in our selection criteria.

 

I dont really need a visual flowchart as such, an indented (collapsible?) text based list would suffice. 

 

Does anyone have any experience in this area? 

  • Finally got around this one. HeirarchySlicer was the answer. It allows you to hide empty nodes, whereas using a "non-blank" filter caused missing records in other slicers.

1 Reply

  • Finally got around this one. HeirarchySlicer was the answer. It allows you to hide empty nodes, whereas using a "non-blank" filter caused missing records in other slicers.