user direct_manager managers
foo bar bar tame tutu
barf tame tame tutu
jams tame tame tutu
I want two visualize where it shows all the hierarchy of manager and direct report for a manager
ie. if I select tame one report only should show
barf and james
second report should show foo, bar and james
how do I achieve it?
for now if I use word tame on filter bar it give me full hierarchy.
but then it want eliminate foo (because tame is not it's direct mangager)
I am so falling over this logic. LOL
I can easilly create new field or update any value on this data that is not a problem. but having hard time to figure this out.
I'd like to restate the problem to make sure we're both thinking about the same problem -
Given a manager, I want to see a list of direct reports and a list of indirect reports.
Assuming that statement is correct -
I think its helpful to start by structuring the data so that its easy to answer the question. Its not always possible but can save a lot of trouble when it is.
I'd modify the data structure as such -
user direct_manager indirect_managers
foo bar [tame, tutu]
barf tame [tutu]
jams tame [tutu]
Now if we query direct_manager for tame we will get barf and james. If we query indirect_managers for tame we will only get foo. Notice that indirect_managers is an array.
However, we need to be able to query both fields and show different data in different visualizations. I think it should work to query both the manager fields using a OR clause and then each visualization can have its own filter.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.