Forum Discussion
Dynamic Filter based on Drill Down
Dear all,
I'm facing a feature request in one of our dashboards for which I cannot find a solution. If there is already a thread, I'm sorry for reposting - wasn't able to find it on my own.
Let's assume this kind of Dataset:
| Proj ID | Proj Info xxx | Division | LeadCenter | Top 5 Division | Top 5 Leadcenter |
| 1 | … | A | A-A | TRUE | TRUE |
| 2 | … | B | B-A | TRUE | FALSE |
| 3 | … | A | A-A | FALSE | TRUE |
| 4 | … | A | A-B | FALSE | FALSE |
| 5 | … | B | B-B | TRUE | FALSE |
| 6 | … | A | A-A | TRUE | FALSE |
The request:
On the one side we would like to have a Treemap with a Drilldown from Division to Leadcenter and on the other side a Table that shows the Top5 Projects. So far so good - Now it gets tricky. The need is to filter the Table for Top 5 Division = TRUE if the Division is selected in the Treemap and then filter the same Table for Top 5 LeadCenter = TRUE if the Treemap is drilled down to LeadCenter level and a Leadcenter is selected.
Use Case Example:
- I drill down Division A in Treemap -> Treemap shows LeadCenter A-A & A-B -> Table shows Proj. ID 1 & 6 (All Top 5 Division = TRUE Items in Division A)
- I select LC A-A in Treemap -> Treemap highlights LeadCenter A-A -> Table shows Proj. ID 1 & 3 (All Top 5 LeadCenter = TRUE Items in LeadCenter A-A)
Is there a smart way to implement this dynamic filter between a Treemap and a Table based on Drill Down feature?
Thank you very much for the support and Best regards
Philipp