I'm working with a manager hierarchy where there are 5 levels of managers (e.g. Tom is the top-line mgr with 5 direct reports, each direct report has 4 direct reports, and so on). I'm displaying survey results for each top-down manager in the hierarchy with a parameter to view by top down level.
|Tom Smith||Sally Smith||Rona Collings|
|Tom Smith||Sally Smith||Anita Deemer|
|Tom Smith||Sally Smith||Robin Mcconkey|
|Tom Smith||Sally Smith||Charis Barnes|
|Tom Smith||Kelly Thompson||Stuart Hellickson|
|Tom Smith||Kelly Thompson||Katrice Proto|
|Tom Smith||Kelly Thompson||Evonne Lacroix|
|Tom Smith||Kelly Thompson||Theodore Parrott|
|Tom Smith||Mike Johnson||Kattie Fuller|
|Tom Smith||Mike Johnson||Vesta Durfee|
|Tom Smith||Mike Johnson||Belinda Providence|
|Tom Smith||Mike Johnson||Meta Foos|
|Tom Smith||Victor Haynes||Sharron Bolz|
|Tom Smith||Victor Haynes||Missy Teter|
|Tom Smith||Victor Haynes||Ashli Hund|
|Tom Smith||Victor Haynes||Blair Geeter|
|Tom Smith||Janice Crawford||Rosalva Alonzo|
|Tom Smith||Janice Crawford||Marcy Tarango|
|Tom Smith||Janice Crawford||Corrie Duarte|
|Tom Smith||Janice Crawford||Sonja Wingate|
So for example, if I choose Level 3 from the parameter, i see a list of all managers 2 levels down from Tom (all 20 mgrs) with the survey results aggregated for those employees who roll up to them. Also, i have a quick filter on the dashboard so that you can choose a level of manager for whom you'd like to see results by. Again, as an example, if i choose Level 3 manager from the parameter, but i want to see the results for a particular Level 2 manager such as Sally Smith, i can set the Manager Level 2 quick filter to Sally Smith and see the results for each level 3 manager beneath her.
So here's the rub, i have my results displayed in a horizontal bar chart for % of favorable responses, and another horizontal bar chart for difference from the overall average for the entire survey. This difference chart works fine when i look at the top level. But as i filter down from there, the difference from total is off because the total has now been filtered.
What i'm trying to figure out is whether or not there is another way to accomplish what i'm trying to do? Thoughts?
Part two of my question is whether or not i can create a visual of this hierarchy where if i'm looking at the results for each manager beneath Tom Smith (bar chart with one line per manager for Sally Smith,Kelly Thompson, etc.) can i click on the bar for Sally Smith and now have the visualization filter Sally SMith and display a bar char for each manager beneath her (Rona Collings, Anita Deemer, etc.)?'
All help is appreciated. Thanks,